Add office photos
Filter interviews by
CAMSDATA Technologies India Software Engineer Interview Questions, Process, and Tips
CAMSDATA Technologies India Software Engineer Interview Experiences
1 interview found
I applied via Naukri.com and was interviewed in Jun 2021. There was 1 interview round.
Interview Questionnaire
7 Questions
- Q1. How to get a file name which has one string called "Virus" as complete word in one directory by UNIX ?
- Ans.
Finding a file name with the word 'Virus' in UNIX directory.
Use the 'grep' command to search for the word 'Virus' in the directory.
Use the '-w' option to match the complete word 'Virus'.
Use the '-l' option to print only the file names that contain the word 'Virus'.
- Q2. How to achieve SCD Type 2 in informatica, mention all the transformations used ?
- Ans.
SCD Type 2 in Informatica can be achieved using multiple transformations.
Use a Source Qualifier transformation to read data from the source.
Use an Expression transformation to derive new columns or modify existing ones.
Use a Lookup transformation to look up data in a reference table.
Use a Router transformation to route data to different targets based on conditions.
Use a Filter transformation to filter out unwanted data...
- Q3. How to improve performance of aggregator ? and what is Incremental aggregation ?
- Ans.
Improving aggregator performance and understanding incremental aggregation.
Optimize database queries and indexing
Reduce data processing time by parallelizing tasks
Use caching to reduce redundant data retrieval
Incremental aggregation involves updating only new or changed data instead of processing all data again
Example: Updating a daily sales report with only new sales data instead of recalculating the entire report
- Q4. What is Hash join and pragma exception in PL SQL
- Ans.
Hash join is a type of join used in database management systems. Pragma exception is used to handle exceptions in PL/SQL.
Hash join is used to join large tables efficiently by creating a hash table of one table and scanning the other table.
Pragma exception is used to handle exceptions in PL/SQL by specifying the action to be taken when an exception occurs.
Examples of actions that can be specified include raising an erro...
- Q5. What is the difference in Procedure and Function ?
- Ans.
Procedures do not return values while functions return values.
Procedures are used to perform an action while functions are used to calculate and return a value.
Functions have a return type while procedures do not.
Functions can be used in expressions while procedures cannot.
Functions can have input parameters while procedures can have both input and output parameters.
- Q6. Suppose lookup is getting 10k records normally in all days suddenly records count will be updated to 100 million then how lookup works ? Does lookup fail session , running session or succeed session.
- Ans.
Lookup will fail if the memory is not sufficient to handle the increased record count.
Lookup transformation caches the lookup table in memory
If the memory is not sufficient, the lookup will fail
Increasing the cache size or using persistent cache can help avoid failure
- Q7. We have 1 source qualifier and 3 targets and we want to load 2nd target first then 3rd secondly then 1st target thirdly, how to achieve it in Informatica ?
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
(12 Questions)
- Q1. Rate yourself in js, node js, react, MongoDB (separately)
- Q2. Typeof null, typeof undefined, typeof {}, typeof NaN
- Q3. What changes came in es6
- Ans.
ES6 introduced several new features and improvements to JavaScript, making it more powerful and efficient.
Arrow functions for more concise syntax
Let and const for block-scoped variables
Classes for easier object-oriented programming
Template literals for easier string interpolation
Default parameters and rest parameters for function arguments
Destructuring assignment for easier data extraction
Promises for asynchronous prog
- Q4. This keyword, closures, hoisting
- Q5. Are let and cont variables hoisted?
- Ans.
Yes, let and const variables are hoisted but not initialized.
let and const variables are hoisted to the top of their block scope, but they are not initialized until the actual line of code is executed.
This means that you cannot access a let or const variable before it is declared in the code.
For example, trying to access a let variable before it is declared will result in a ReferenceError.
- Q6. What is global context
- Ans.
Global context refers to the overall environment or setting in which something exists or operates.
Global context encompasses all variables, functions, and objects that are accessible throughout an entire program.
It can be thought of as the 'big picture' view of a program's execution.
In web development, global context includes the window object in JavaScript.
- Q7. What is temporal deadzone
- Ans.
Temporal dead zone is a period during the variable creation process where accessing the variable results in a ReferenceError.
Occurs when trying to access a variable before it has been declared with let or const
Happens due to the variable being in the temporal dead zone until it is declared
Example: accessing a variable before its declaration will result in a ReferenceError
- Q8. What is modules? types of modules in nodejs
- Ans.
Modules in Node.js are reusable blocks of code that encapsulate related functionality.
Modules in Node.js can be built-in modules like fs (file system) or third-party modules like express.
Modules help in organizing code into separate files for better maintainability and reusability.
Modules can be imported using the require() function in Node.js.
- Q9. Index in mongodb, why we need index, is index good or bad?
- Ans.
Indexes in MongoDB improve query performance by allowing the database to quickly locate and retrieve specific documents.
Indexes help to speed up query performance by allowing the database to quickly locate specific documents based on the indexed fields.
Without indexes, MongoDB would have to perform a collection scan, which can be slow and resource-intensive.
Indexes can be created on single fields or compound fields to ...
- Q10. What are hooks , use of useRef
- Ans.
Hooks are a feature in React that allow you to use state and other React features in functional components. useRef is a hook that allows you to create a mutable object that persists for the lifetime of the component.
Hooks are used to add state and lifecycle methods to functional components in React
useRef is used to create a mutable reference that persists between renders
useRef can be used to access DOM elements directl
- Q11. Fs module, http module, worker thread?
- Q12. Why we use mongoose not mongodb driver?
- Ans.
Mongoose is an Object Data Modeling (ODM) library for MongoDB that provides a higher level of abstraction and simplifies interactions with the database.
Mongoose provides schema validation which helps maintain data integrity.
Mongoose simplifies querying and data manipulation with built-in functions.
Mongoose supports middleware functions for pre and post processing of data operations.
Skills evaluated in this interview
Software Engineer Interview Questions & Answers
Apmosys Technologies
Anonymous
posted on 16 Dec 2024
Selected
I applied via Campus Placement and was interviewed in Nov 2024. There were 2 interview rounds.
The aptitude test was relatively straightforward, consisting of both aptitude and technical questions, with a difficulty level ranging from easy to medium.
(2 Questions)
- Q1. Was asked to write a code on basic DSA concept
- Q2. Then was asked basic questions on DSA and SQL
Interview Preparation Tips
I applied via Company Website and was interviewed in Jul 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Asking about the whereabouts
- Q2. Checking com skills and availability
(3 Questions)
- Q1. Basic questions based on resume
- Q2. Basic .net questions
- Q3. Logical questions related to problem solving
Interview Preparation Tips
Software Engineer Interview Questions & Answers
Thinkitive Technologies
Aditya Gupta
posted on 13 Aug 2024
Selected
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. What is single page application
- Ans.
Single page application is a web application that loads a single HTML page and dynamically updates the content as the user interacts with the app.
SPA uses AJAX and HTML5 to create fluid and responsive user experience.
It eliminates the need for page reloading during use, making it faster and more efficient.
Examples include Gmail, Facebook, and Google Maps.
- Q2. What is state management
- Ans.
State management is the process of managing the state of an application, including data flow, user interface updates, and user interactions.
State management involves storing and updating the state of an application to ensure data consistency.
It helps in managing user interface updates based on changes in the application state.
State management is crucial for handling user interactions and maintaining a seamless user exp...
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.
(1 Question)
- Q1. Basic flutter coding questions
(1 Question)
- Q1. What is jdk, string related questions, basic java oops questions?
The aptitude test was of moderate level.
It checked on the concepts of oops
(1 Question)
- Q1. How will you deal with tight delivery time.
- Ans.
I will prioritize tasks, communicate effectively with team members, and utilize time management techniques to meet deadlines.
Prioritize tasks based on importance and urgency
Break down tasks into smaller manageable chunks
Communicate effectively with team members to coordinate efforts
Utilize time management techniques such as Pomodoro technique or Agile methodologies
Identify and eliminate any potential roadblocks or bott...
Selected
I applied via Job Portal
(2 Questions)
- Q1. What's does the useCallback and usememo in react ?
- Ans.
useCallback and useMemo are hooks in React used for performance optimization.
useCallback is used to memoize a function and prevent unnecessary re-renders.
useMemo is used to memoize a value and prevent unnecessary re-computations.
Both hooks are used to optimize performance by reducing unnecessary re-renders and re-computations.
useCallback is useful when passing down functions to child components.
useMemo is useful when c...
- Q2. What's difference between async await and promise ?
- Ans.
Async/await is a syntactic sugar over Promises in JavaScript.
Async/await makes asynchronous code look and behave like synchronous code.
Promises are objects that represent the eventual completion or failure of an asynchronous operation.
Async/await is easier to read and write than Promises.
Async/await can only be used in functions that are marked as async.
Promises can be used anywhere in the code.
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. What is the difference between classes and struct
- Ans.
Classes are reference types while structs are value types.
Classes support inheritance while structs do not.
Classes have default access modifier as internal while structs have it as private.
Classes have a destructor while structs do not.
Classes are allocated on heap while structs are allocated on stack.
Classes can be null while structs cannot.
- Q2. Dispatch Queue vs operations
- Ans.
Dispatch Queue is a thread-safe way to execute tasks asynchronously, while Operations are a way to encapsulate tasks.
Dispatch Queue is a high-level API for managing concurrent operations.
Operations are objects that encapsulate a single task or multiple tasks.
Dispatch Queue is simpler to use and recommended for most use cases.
Operations provide more control over task dependencies and cancellation.
Both can be used togeth
Interview Preparation Tips
Skills evaluated in this interview
CAMSDATA Technologies India Interview FAQs
Some of the top questions asked at the CAMSDATA Technologies India Software Engineer interview -
Tell us how to improve this page.
CAMSDATA Technologies India Interviews By Designations
- CAMSDATA Technologies India Associate Project Management Manager Interview Questions
- CAMSDATA Technologies India CAE Analyst Interview Questions
- CAMSDATA Technologies India HR Executive Interview Questions
- CAMSDATA Technologies India Information Technology Recruiter Interview Questions
- CAMSDATA Technologies India Linux System Administrator Interview Questions
- CAMSDATA Technologies India Software Engineer Interview Questions
People are getting interviews through
Software Engineer Interview Questions from Similar Companies
CAMSDATA Technologies India Software Engineer Reviews and Ratings
based on 3 reviews
Rating in categories
|
Software Engineer
20
salaries
|  ₹2.4 L/yr - ₹11.2 L/yr |
|
Information Technology Recruiter
12
salaries
| ₹1.1 L/yr - ₹5 L/yr |
|
Softwaretest Engineer
10
salaries
| ₹4.5 L/yr - ₹12 L/yr |
|
Software Developer
9
salaries
| ₹4.3 L/yr - ₹18.1 L/yr |
|
Senior Software Engineer
9
salaries
| ₹11 L/yr - ₹27 L/yr |
TCS
Infosys
Wipro
HCLTech
Calculate your in-hand salary
- Home >
- Interviews >
- CAMSDATA Technologies India Interview Questions >
- CAMSDATA Technologies India Software Engineer Interview Questions
