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
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
(1 Question)
- Q1. About informatica,SQL,dwa
Interview Preparation Tips
Informatica ETL Developer Interview Questions & Answers
NTT DATA, Inc.
Anonymous
posted on 5 Aug 2021
Interview Questionnaire
1 Question
- Q1. Company is good but management was only supported here for permanent employment better options you can choose other Company of u want 2 grow ur future
I was interviewed 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
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
ETL Developer Interview Questions & Answers
Tech Mahindra
RAMAVATHULA CHANDRA NAIK
posted on 4 Feb 2025
(2 Questions)
- Q1. They were asking very logical and technical questions on interview time
- Q2. They were test our skills and time punctuation
(1 Question)
- Q1. They were discussed with some technical questions and based on knowledge
Interview Preparation Tips
Oracle Database Administrator Interview Questions & Answers
Accenture
Anonymous
posted on 10 Jan 2025
I applied via Approached by Company and was interviewed in Dec 2024. There was 1 interview round.
(2 Questions)
- Q1. Tell me the high level overview of dataguard installation?
- Q2. What are your daily tasks adn what things you handel in your team?
Jayashree Shinde
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
(5 Questions)
- Q1. Analytical functions difference
- Ans.
Analytical functions are used to perform calculations across a set of rows related to the current row.
Analytical functions operate on a group of rows and return a single result for each row
They can be used to calculate running totals, moving averages, rank, percentiles, etc.
Examples include ROW_NUMBER(), RANK(), SUM() OVER(), AVG() OVER()
- Q2. Which transformation uses in scd2?
- Ans.
The Slowly Changing Dimension Type 2 (SCD2) transformation is used for handling historical data changes in a data warehouse.
SCD2 transformation is used to track historical changes in dimension tables.
It maintains multiple versions of a record by adding new rows with updated information and end-dating the previous record.
Commonly used in scenarios where historical data needs to be preserved and queried.
Example: When a c...
- Q3. Unix basic, how to find particular file in directory?
- Q4. Given 2 table A and B. Find count of left join, right join, inner join, full outer join?
- Ans.
To find the count of different types of joins between two tables A and B.
Left join: Includes all records from table A and matching records from table B.
Right join: Includes all records from table B and matching records from table A.
Inner join: Includes only the matching records from both tables.
Full outer join: Includes all records when there is a match in either table A or table B.
- Q5. Incremental load
Skills evaluated in this interview
(2 Questions)
- Q1. Dataguard architecture
- Q2. Rman backup and restoration
(1 Question)
- Q1. Why you join inm
- Ans.
I joined inm because of the company's reputation for innovation and growth in the tech industry.
Attracted to company's reputation for innovation
Excited about opportunities for growth in tech industry
Impressed by company culture and values
(1 Question)
- Q1. DDL DML DCL TCL
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.2k
salaries
|  ₹5.1 L/yr - ₹16 L/yr |
|
Programmer Analyst
55.5k
salaries
| ₹2.4 L/yr - ₹9.7 L/yr |
|
Senior Associate
48.6k
salaries
| ₹9 L/yr - ₹27.3 L/yr |
|
Senior Processing Executive
28.9k
salaries
| ₹1.8 L/yr - ₹9 L/yr |
|
Technical Lead
17.6k
salaries
| ₹5.9 L/yr - ₹24.8 L/yr |
TCS
Infosys
Wipro
Accenture
- Home >
- Interviews >
- Cognizant Interview Questions >
- Cognizant Informatica ETL Developer Interview Questions
