AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Cognizant
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Cognizant Informatica ETL Developer Interview Questions, Process, and Tips
Cognizant Informatica ETL Developer Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in May 2022. There were 3 interview rounds.
(6 Questions)
- Q1. What is filter transformation
- Ans.
Filter transformation is used to filter rows from a data source based on specified conditions.
Filter transformation is an active transformation in Informatica PowerCenter.
It allows you to define conditions to filter rows from the source data.
Rows that meet the filter conditions are passed to the next transformation, while others are dropped.
Filter transformation can be used to eliminate unwanted data or select specific...
- Q2. Difference between connected and unconnected lookup
- Ans.
Connected lookup is used in mapping flow, while unconnected lookup is used in expression transformation.
Connected lookup is used in mapping flow, while unconnected lookup is used in expression transformation.
Connected lookup receives input values directly from the pipeline, while unconnected lookup receives input values from the calling transformation.
Connected lookup returns a value to the pipeline, while unconnected ...
- Q3. Diff between active and passive transformation
- Ans.
Active transformations change the number of rows that pass through it, while passive transformations do not.
Active transformations change the data stream by adding, deleting, or modifying rows
Passive transformations do not change the data stream, but may change the data within the stream
Active transformations include Filter, Router, Update Strategy, and Expression
Passive transformations include Aggregator, Joiner, Look
- Q4. How to improve performance
- Q5. What is pushdown automata
- Ans.
Pushdown automata is a type of automata that can recognize context-free languages.
Pushdown automata is a theoretical model of computation.
It has a stack that can be used to store and retrieve information.
It is used to recognize context-free languages.
It is more powerful than finite automata but less powerful than Turing machines.
Examples of context-free languages include arithmetic expressions and programming languages
- Q6. How to update table without using update startegy
- Ans.
Use SQL merge statement to update table without update strategy
Use SQL merge statement to update table
Specify the source and target tables
Define the join condition
Specify the columns to update
Use WHEN MATCHED THEN UPDATE statement
Use WHEN NOT MATCHED THEN INSERT statement
More on informatica and SQL code
(1 Question)
- Q1. Nothing difficult just discuss about pay scale
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Sep 2020. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. What is the difference between delete , truncate and drop?
- Ans.
Delete removes specific rows from a table, truncate removes all rows, and drop removes the entire table.
Delete is a DML operation, while truncate and drop are DDL operations.
Delete is slower as it logs individual row deletions, while truncate and drop are faster.
Delete can be rolled back, while truncate and drop cannot be rolled back.
Delete can have conditions to specify which rows to delete, while truncate and drop af...
- Q2. Write a SQL query to find the duplicates?
- Ans.
A SQL query to find duplicates in a table.
Use the GROUP BY clause to group the records by the columns that may have duplicates.
Use the HAVING clause to filter the groups that have more than one record.
Select the columns that you want to display in the result.
Order the result if necessary.
- Q3. Difference between union and union all
- Ans.
Union combines the result sets of two or more SELECT statements, while Union All combines all rows from two or more SELECT statements.
Union removes duplicate rows from the result set, while Union All does not.
Union requires the number and order of columns in all SELECT statements to be the same, while Union All does not have this requirement.
Union is slower than Union All because it performs a distinct operation, while...
- Q4. Write any analytical syntax.
- Ans.
An analytical syntax example is SELECT COUNT(*) FROM table_name;
Analytical syntax is used to retrieve and analyze data from databases
Commonly used in business intelligence and data warehousing
Other examples include GROUP BY, ORDER BY, and JOIN statements
Interview Preparation Tips
Skills evaluated in this interview
I appeared for an interview in Apr 2021.
Interview Questionnaire
1 Question
- Q1. Questions were basic and advanced level of questions.basically you will have two set of rounds technical and managerial round.
Interview Preparation Tips
(1 Question)
- Q1. About informatica,SQL,dwa
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. They will ask the questions on your background and working experience
Interview Questionnaire
1 Question
- Q1. General Questions
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jan 2020. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Normal Accounts related question like describe Depreciation, ammortization, and what do you mean by Reporting (RTR Activity).
- Q2. Some interviewer may ask what do you mean by EBITDA as in my case be prepared for this type of bouncers as well .
- Q3. Then they will ask you your previous work related question. In my case they ask if there is GL to SL mismatch what will you do to solve it.
- Q4. Then why do we do depreciation of companies what is the need for it
- Ans.
Depreciation is necessary to allocate the cost of an asset over its useful life.
Depreciation helps in matching the cost of an asset with the revenue it generates.
It allows for the recognition of the wear and tear, obsolescence, and loss of value of assets over time.
Depreciation expense reduces taxable income, resulting in tax savings for companies.
It helps in determining the true profitability and financial position of...
Interview Preparation Tips
Read the basics and if you are experienced be sure to explain every detail of how you used to do work.
Best of luck.
I applied via Naukri.com and was interviewed in Oct 2020. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. What is second level cache?How to implement second level cache?How to optimize sql query?what are solid principles?
- Ans.
Second level cache is a caching mechanism used to improve performance by storing frequently accessed data in memory.
Second level cache is implemented at the application level and can be configured using frameworks like Hibernate.
To optimize SQL queries, one can use indexes, avoid using SELECT *, and use JOINs instead of subqueries.
SOLID principles are a set of design principles for writing maintainable and scalable cod...
- Q2. Mostly FAQ but somewhat in depth?
- Q3. How to deploy application in aws?
- Ans.
To deploy an application in AWS, you need to create an EC2 instance, configure security groups, install necessary software, and upload your application code.
Create an EC2 instance in the desired region and select the appropriate instance type
Configure security groups to allow traffic to and from the instance
Install necessary software and dependencies on the instance
Upload your application code to the instance
Start the ...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Referral and was interviewed before Mar 2021. There was 1 interview round.
(1 Question)
- Q1. About pointers and their types
Interview Preparation Tips
I applied via Campus Placement
Interview Questionnaire
4 Questions
- Q1. What is multithreading? ( I used it in my project )
- Ans.
Multithreading is the ability of a CPU to execute multiple threads concurrently, improving performance and responsiveness.
Multithreading allows for parallel execution of tasks, utilizing multiple CPU cores.
It enables concurrent processing, where multiple threads can execute simultaneously.
Thread synchronization mechanisms like locks and semaphores are used to prevent data inconsistencies.
Multithreading can be used to i...
- Q2. How is socket programming different from other programmings?( Again a question from my project)
- Q3. Difference between constructors and destructors.
- Ans.
Constructors are used to initialize objects while destructors are used to destroy objects.
Constructors are called when an object is created while destructors are called when an object is destroyed.
Constructors have the same name as the class while destructors have the same name as the class preceded by a tilde (~).
Constructors can be overloaded while destructors cannot be overloaded.
Constructors do not have a return ty...
- Q4. Oops basics
Interview Preparation Tips
Skills evaluated in this interview
Cognizant Interview FAQs
Tell us how to improve this page.
Cognizant Interviews By Designations
- Cognizant Programmer Analyst Interview Questions
- Cognizant Programmer Analyst Trainee Interview Questions
- Cognizant Associate Interview Questions
- Cognizant Senior Associate Interview Questions
- Cognizant Processing Executive Interview Questions
- Cognizant Software Engineer Interview Questions
- Cognizant Senior Processing Executive Interview Questions
- Cognizant Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Informatica Developer Interview Questions
- ETL Developer Interview Questions
- Senior ETL Developer Interview Questions
- ETL Lead Interview Questions
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- Show more
Cognizant Informatica ETL Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Cognizant Informatica ETL Developer Reviews and Ratings
based on 12 reviews
Rating in categories
|
Associate
72.3k
salaries
|  ₹5.2 L/yr - ₹16 L/yr |
|
Programmer Analyst
55.6k
salaries
| ₹2.4 L/yr - ₹9.3 L/yr |
|
Senior Associate
50.3k
salaries
| ₹9 L/yr - ₹28.6 L/yr |
|
Senior Processing Executive
29.1k
salaries
| ₹1.8 L/yr - ₹9 L/yr |
|
Technical Lead
17.7k
salaries
| ₹6 L/yr - ₹25 L/yr |
TCS
Infosys
Wipro
Accenture
- Home >
- Interviews >
- Cognizant Interview Questions >
- Cognizant Informatica ETL Developer Interview Questions
