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
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Cognizant ETL Tester Interview Questions, Process, and Tips
Updated
7 Feb 2024
Top Cognizant ETL Tester Interview Questions and Answers
- Q1. If we have 200 staging tables, 40 dimensions tables and 20 facts table, How will you compare it with target systems
- Q2. 2.Difference between Union and union all,drop and Truncate,star schema and snowflake schema,Dimension table and fact table.
- Q3. Which type of Validation you will do at Landing and staging area.
7 Cognizant ETL Tester Interview Experiences
29 questions found
Sort by:
Popular
Anonymous
Interview experience
Excellent
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Referral and was interviewed in Nov 2022.
4 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2
Technical Round (5 Questions)
- Q1. If we have 200 staging tables, 40 dimensions tables and 20 facts table, How will you compare it with target systems View Answers (3)
- Q2. Types of test data creation View Answers (1)
- Q3. SQL-Find a last day of the previous month View Answers (2)
- Q4. SQL-Display horizontal ORACLE into Vertical ORACLE (Pivot function) View Answers (1)
- Q5. SQL- Fetch last 5 records from the table View Answers (4)
3
Technical Round (2 Questions)
- Q1. How will you handle stressful situation Add Answer
- Q2. What will you do after production bug leakage View Answers (1)
4
HR Round (1 Question)
- Q1. General tell abt your self Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare well before the interview
Be confident
Stay cool
Be confident
Stay cool
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
No response
I applied via Naukri.com and was interviewed in Jan 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Difference between snowflake schema and star schema View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Stay clam and tell me the truth.
Get interview-ready with top interview questions
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Aug 2023.
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. What are the types of scd View Answers (2)
2
Technical Round (1 Question)
- Q1. Incremental load validations Add Answer
What people are saying about Cognizant
View All
hardoggy
currently not working
Which to choose between Cognizant and TCS?
I am a recent CSE graduate and got two offers,
Cognizant Engineer Trainee - 4 LPA (1 year probation period)
TCS Ninja role - 3.36 LPA
Which is better to join as a fresher?
Got a question about Cognizant?
Ask anonymously on communities.
Interview experience
Good
Difficulty level
Moderate
Duration
4-6 weeks
Result
Selected
I was interviewed before Feb 2023.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Basic sql
Dw concepts
Scenario based questions Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Basic sql queries
Etl connectors
Do concepts
Etl connectors
Do concepts
Cognizant interview questions for designations
Interview Questions
- Q1. 1.Difference between unique key and primary key.
View Answers (2)
- Q2. 2.Difference between Union and union all,drop and Truncate,star schema and snowflake schema,Dimension table and fact table.
View Answers (2)
- Q3. Which type of Validation you will do at Landing and staging area.
View Answers (2)
- Q4. 1.Find last 5 records. 2. find unique records.
View Answers (6)
- Q5. What is self Join,types of joins.what is CDC and how we will use it in ETL testing
View Answers (1)
- Q6. Type of scd.
View Answers (1)
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Dec 2020.
3 Interview Rounds
Interview Questions
- Q1. Explain ETL architecture?
View Answers (3)
- Q2. What is fact?
View Answers (2)
- Q3. What is fact table?
View Answers (1)
- Q4. What are dimensions? And their types
View Answers (2)
- Q5. Explain SCD types
View Answers (1)
- Q6. Explain schema you used in your project
View Answers (2)
- Q7. What are the prerequisites for etl testing?
View Answers (1)
- Q8. What is data mart?
View Answers (3)
- Q9. What is data repository?
View Answers (2)
- Q10. How do you identify latest record in SCD
View Answers (2)
Interview Preparation Tips
Interview preparation tips for other job seekers - Be confident and real.
If you don't know any answer be straight to interviewer.
If you don't know any answer be straight to interviewer.
Skills evaluated in this interview
ETL Tester Jobs at Cognizant
I applied via Naukri.com and was interviewed before Jun 2021.
1 Interview Round
1
Technical Round (1 Question)
- Q1. About previous project Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be confident, and be prepared what you have good potential to give... be honest
Interview questions from similar companies
Interview experience
Excellent
Difficulty level
Moderate
Duration
-
Result
Not Selected
I applied via Recruitment Consulltant and was interviewed in Sep 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. What is the Difference Between Drop and Truncate Command ? View Answers (1)
- Q2. What are the Validations you Perform in your Project ? View Answers (1)
- Q3. What is Star Schema and Snow flake schema ? View Answers (1)
- Q4. What is Fact and Dimension Tables View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Be Clear on Basics in First Round then go more Deeper in SQL Part for ETL Testers in Round 2
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
No response
I applied via Naukri.com and was interviewed in Aug 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. Explain project architecture? View Answers (1)
- Q2. Explain challenges you faced in etl testing? View Answers (1)
- Q3. What are roles and responsibilities? View Answers (1)
- Q4. How to find duplicate values in python? View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - ETL Concepts, Datawarehouse concepts and Python also must required
Skills evaluated in this interview
Interview experience
Average
Difficulty level
-
Duration
-
Result
Selected
I applied via Naukri.com and was interviewed in Jul 2024.
2 Interview Rounds
1
Technical Round (10 Questions)
- Q1. Write an SQL query to fetch 5th ,10th,15th .. records from a table? View Answers (1)
- Q2. What are constraints? View Answers (1)
- Q3. What is Low Priority , Medium Priority & High priority defects? View Answers (1)
- Q4. White box , Black Box ,regression , Retesting? View Answers (1)
- Q5. Joins ? with example View Answers (1)
- Q6. Window function queries? Add Answer
- Q7. Domain name from an email ? View Answers (1)
- Q8. Rank dense_rank() ,row_numebr with example? View Answers (1)
- Q9. SCD Types , Star Schema Vs SnowFlake Schema View Answers (1)
- Q10. Group by clause and how it work with a query View Answers (1)
2
HR Round (4 Questions)
- Q1. Salary expectations Add Answer
- Q2. Where do you see yourself in 5 years Add Answer
- Q3. Reason for job switch? View Answers (1)
- Q4. Strengths & weakness ? View Answers (1)
Skills evaluated in this interview
Cognizant Interview FAQs
How many rounds are there in Cognizant ETL Tester interview?
Cognizant interview process usually has 2 rounds. The most common rounds in the Cognizant interview process are Technical, Resume Shortlist and HR.
How to prepare for Cognizant ETL Tester interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Cognizant. The most common topics and skills that interviewers at Cognizant expect are ETL Testing, Database Testing, SQL, Unix and Hadoop.
What are the top questions asked in Cognizant ETL Tester interview?
Some of the top questions asked at the Cognizant ETL Tester interview -
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
- Software Tester Interview Questions
- Manual Tester Interview Questions
- QA Tester Interview Questions
- Automation Tester Interview Questions
- ETL Test Engineer Interview Questions
- Senior Software Tester Interview Questions
- Selenium Automation Tester Interview Questions
- Game Tester Interview Questions
- Show more
People are getting interviews through
based on 5 Cognizant interviews
Job Portal
Referral
80%
20%
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
ETL Tester Interview Questions from Similar Companies
Fast track your campus placements
23%
more
than the average ETL Tester Salary in India
View more details
Cognizant ETL Tester Reviews and Ratings
based on 36 reviews
Rating in categories
|
Associate
72.8k
salaries
|  ₹5.1 L/yr - ₹16 L/yr |
|
Programmer Analyst
54.1k
salaries
| ₹2.4 L/yr - ₹9.7 L/yr |
|
Senior Associate
48.2k
salaries
| ₹8.9 L/yr - ₹27 L/yr |
|
Senior Processing Executive
28.4k
salaries
| ₹1.8 L/yr - ₹9 L/yr |
|
Technical Lead
17.5k
salaries
| ₹5.9 L/yr - ₹24 L/yr |
Explore more salaries
Compare Cognizant with
TCS
Compare
Infosys
Compare
Wipro
Compare
Accenture
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Cognizant Interview Questions >
- Cognizant ETL Tester Interview Questions
Share an Interview