Add office photos
Filter interviews by
Exl India ETL Tester Interview Questions and Answers
Updated
21 Mar 2024
1 interview found
Sort by:
Popular
Anonymous
Interview experience
Poor
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Recruitment Consulltant and was interviewed in Feb 2024.
1 Interview Round
1
One-on-one Round (2 Questions)
- Q1. Rank,dense_rank,union,union all, Add Answer
- Q2. Scd1,scd2,scd3,analytical function,window key Add Answer
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
Lavanya Shankar
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Append a item in tuple Add Answer
- Q2. How to validate response body in api in restapi Add Answer
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
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via LinkedIn and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. What is deferred bug View Answers (1)
- Q2. Query to get 4th highest row based on a column View Answers (1)
Interview experience
Average
Difficulty level
Easy
Duration
2-4 weeks
Result
-
I applied via Naukri.com and was interviewed in Mar 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. Explain inner join with an example View Answers (1)
- Q2. Explain cross join with an example View Answers (1)
- Q3. Provided Employee Table and asked to do a self join Add Answer
- Q4. Explain different types of data validation and checks performed in ETL testing View Answers (1)
Skills evaluated in this interview
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (4 Questions)
- Q1. What are scd types View Answers (1)
- Q2. How you identify duplicates and how to find latest duplicate View Answers (1)
- Q3. What is the difference between star schema and snowflake schme View Answers (1)
- Q4. What are the test articrafts View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Etl tools and technologies Add Answer
- Q2. Types of scd dimensions View Answers (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 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.
Exl India Interview FAQs
How many rounds are there in Exl India ETL Tester interview?
Exl India interview process usually has 1 rounds. The most common rounds in the Exl India interview process are One-on-one Round.
Tell us how to improve this page.
Exl India Interviews By Designations
- Exl India Business Analyst Interview Questions
- Exl India Executive Interview Questions
- Exl India Consultant Interview Questions
- Exl India Data Scientist Interview Questions
- Exl India Senior Executive Interview Questions
- Exl India Analyst Interview Questions
- Exl India Data Analyst Interview Questions
- Exl India Assistant Manager 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
ETL Tester Interview Questions from Similar Companies
Fast track your campus placements
|
Senior Executive
1.1k
salaries
|  ₹1.7 L/yr - ₹8.5 L/yr |
|
Assistant Manager
900
salaries
| ₹3.4 L/yr - ₹14.4 L/yr |
|
Executive
626
salaries
| ₹1 L/yr - ₹6 L/yr |
|
Senior Associate
543
salaries
| ₹1.4 L/yr - ₹8.2 L/yr |
|
Associate
401
salaries
| ₹1.2 L/yr - ₹5.3 L/yr |
Explore more salaries
Compare Exl India with
Genpact
Compare
WNS
Compare
TCS
Compare
Infosys
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 >
- Exl India Interview Questions >
- Exl India ETL Tester Interview Questions
Share an Interview