Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Cognizant Team. If you also belong to the team, you can get access from here

Cognizant Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Cognizant Informatica ETL Developer Interview Questions, Process, and Tips

Updated 23 Jun 2022

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.

Round 1 - Technical 

(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...

  • Answered by AI
  • 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 ...

  • Answered by AI
  • 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

  • Answered by AI
  • 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

  • Answered by AI
  • 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

  • Answered by AI
Round 2 - Coding Test 

More on informatica and SQL code

Round 3 - HR 

(1 Question)

  • Q1. Nothing difficult just discuss about pay scale

Interview Preparation Tips

Interview preparation tips for other job seekers - Strong on basic transformation and SQL queries

Skills evaluated in this interview

Interview questions from similar companies

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

Interview preparation tips for other job seekers - Just be confident at what you learn

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...

  • Answered by AI
  • 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.

  • Answered by AI
  • 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...

  • Answered by AI
  • 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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through all the youtube video consisting of high level queries. Practice those query as much possible.

Skills evaluated in this interview

Round 1 - Technical 

(1 Question)

  • Q1. About informatica,SQL,dwa
Round 2 - Group Discussion 
Pro Tip by AmbitionBox:
Don’t treat group discussions as an argument. Group discussion is about reaching a meaningful conclusion.
View all tips

Interview Preparation Tips

Interview preparation tips for other job seekers - Good knowledge on Informatica and oracle sql

I applied via Campus Placement and was interviewed in Sep 2020. There were 4 interview rounds.

Interview Questionnaire 

7 Questions

  • Q1. Why should we hire you?
  • Q2. What are your strengths and weaknesses?
  • Q3. What do you know about our company?
  • Q4. Are u willing to relocate?
  • Q5. What are your educational qualifications?
  • Q6. What are your technical skills?
  • Q7. How can you define you are a different person from others?

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident and maintain good communication skills and eye contact with the interviewer.

I applied via Campus Placement and was interviewed in Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. 1. Introduce yourself?
  • Q2. 2.Why DXC?
  • Q3. 3.As a non-IT why to software? (I'm from ece)
  • Q4. 4. About your weakness and how you overcome it?

Interview Preparation Tips

Interview preparation tips for other job seekers - My interview is good. My advice is that don't panic, overtensed or nervous. This is the chance to prove yourself what you are. And other this is many people think there is no need of preparation for interview, in my point of view.. For fresher must and should prepare or beware of that. As we all know that are the HR questions but we don't know the answers for that so, be prepared for that. And important thing is RESUME many questions about this so, build your resume by you and study about your projects and all.
All the best ✊
Thankyou 😊

I applied via Campus Placement and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Tell me about yourself
  • Q2. What is your strength and weaknesses

Interview Preparation Tips

Interview preparation tips for other job seekers - it was good

I applied via Recruitment Consulltant and was interviewed in Aug 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Basic oops concepts Attribute routing Sal query

Interview Preparation Tips

Interview preparation tips for other job seekers - Only two round second interview is manager round

I applied via Walk-in and was interviewed in Apr 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself and technical knowledge.

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay calm you will achieve it.

I applied via Naukri.com and was interviewed in Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. About my previous work experience
  • Q2. About achievements

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good. I was asked everything in detail and the managers make you comfortable enough so that answer each and evry question

Cognizant Interview FAQs

How many rounds are there in Cognizant Informatica ETL Developer interview?
Cognizant interview process usually has 3 rounds. The most common rounds in the Cognizant interview process are Technical, Coding Test and HR.
What are the top questions asked in Cognizant Informatica ETL Developer interview?

Some of the top questions asked at the Cognizant Informatica ETL Developer interview -

  1. How to update table without using update start...read more
  2. Difference between connected and unconnected loo...read more
  3. What is filter transformat...read more

Tell us how to improve this page.

Cognizant Informatica ETL Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Accenture Interview Questions
3.8
 • 8.2k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
View all
Cognizant Informatica ETL Developer Salary
based on 254 salaries
₹3.9 L/yr - ₹15.9 L/yr
35% more than the average Informatica ETL Developer Salary in India
View more details

Cognizant Informatica ETL Developer Reviews and Ratings

based on 12 reviews

4.1/5

Rating in categories

3.7

Skill development

3.7

Work-life balance

3.2

Salary

4.4

Job security

4.4

Company culture

3.2

Promotions

4.1

Work satisfaction

Explore 12 Reviews and Ratings
Associate
72.2k salaries
unlock blur

₹5.2 L/yr - ₹16 L/yr

Programmer Analyst
55.6k salaries
unlock blur

₹2.4 L/yr - ₹9.4 L/yr

Senior Associate
49.5k salaries
unlock blur

₹8.9 L/yr - ₹28 L/yr

Senior Processing Executive
29k salaries
unlock blur

₹1.8 L/yr - ₹9 L/yr

Technical Lead
17.6k salaries
unlock blur

₹5.9 L/yr - ₹25 L/yr

Explore more salaries
Compare Cognizant with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

Accenture

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview