Premium Employer
i
This company page is being actively managed by
Infosys Team. If you also belong to the team, you
can get access from
here
Infosys
Compare
Filter interviews by
Infosys ETL Tester Interview Questions, Process, and Tips
Updated
9 Sep 2024
Top Infosys ETL Tester Interview Questions and Answers
- Q1. How do you get data integrity between source and destination, how you perform loading technique.
- Q2. Difference Between union and union all,having and where, rank and dense rank(),minus and intersection
- Q3. what is fact table,dimenssion table,star schema,snowflake schema???
11 Infosys ETL Tester Interview Experiences
44 questions found
Sort by:
Popular
Anonymous
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
Rohan Verma
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (6 Questions)
- Q1. Self Introduction and About current Project Add Answer
- Q2. What is SCD Type 2 View Answers (1)
- Q3. Test Plan and Test Strategy Add Answer
- Q4. Query to find duplicates View Answers (1)
- Q5. Query to fetch nth highest salary View Answers (1)
- Q6. Query to fetch 3 View Answers (1)
Skills evaluated in this interview
Get interview-ready with top interview questions
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
-
I applied via Recruitment Consulltant and was interviewed in Apr 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. Types of SCD and its types View Answers (1)
- Q2. How to find duplicates in SQL? View Answers (1)
- Q3. Test Case vs Test Scenario View Answers (1)
- Q4. Define bug life cycle View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. EXPLAIN INNER JOIN View Answers (1)
Skills evaluated in this interview
Infosys interview questions for designations
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Referral and was interviewed in Mar 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Define Views, types of views View Answers (1)
- Q2. Query to get 3rd highest salary View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Hard
Duration
4-6 weeks
Result
Selected
I applied via Naukri.com and was interviewed in Jan 2023.
2 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 (4 Questions)
- Q1. Difference between Star schema and snowflake schema. View Answers (1)
- Q2. Difference between white box and black box testing. View Answers (1)
- Q3. Explain defect life cycle. View Answers (1)
- Q4. SQL query to find second highest salary. View Answers (2)
Interview Preparation Tips
Interview preparation tips for other job seekers - Be prepared, confident and positive.
Listen question carefully and reply properly.
Listen question carefully and reply properly.
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in Sep 2022.
2 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2
Technical Round (2 Questions)
- Q1. What is fact table,dimenssion table,star schema,snowflake schema??? View Answers (1)
- Q2. What is mapping design???? View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - when evar you have an interview with infosys first ask there qualification and role how useless people are there where taking interviews now a days RIP infosys requirement team.....
Skills evaluated in this interview
3 Interview Rounds
Interview Questions
- Q1. Data warehouse and database
View Answers (1)
- Q2. Basics of ETL testing
Add Answer
- Q3. SQL quries like find out duplicates,highest salary, group by,order by etc
View Answers (1)
- Q4. Difference Between union and union all,having and where, rank and dense rank(),minus and intersection
View Answers (1)
- Q5. How do you get data integrity between source and destination, how you perform loading technique.
View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Do not give more explanation to the question give point to point answer,give more real time examples.
Skills evaluated in this interview
I applied via Recruitment Consultant and was interviewed in Sep 2021.
Interview Questions
- Q1. Related subject
Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Ready to attend the interview
1 Interview Round
Interview Questions
- Q1. Data warehouse concepts
Add Answer
- Q2. Agile methodologies
Add Answer
- Q3. Test plan and startegies
Add Answer
- Q4. SQL basic queries
Add Answer
What people are saying about Infosys
View All
majesticravioli
works at
Infosys
Search feature of AmbitionBox
Is there no option to search for words that were mentioned in any of the posts in different communities in AmbitionBox? I can do the same in fishbowl but not sure if it is possible here
Got a question about Infosys?
Ask anonymously on communities.
Infosys Interview FAQs
How many rounds are there in Infosys ETL Tester interview?
Infosys interview process usually has 1-2 rounds. The most common rounds in the Infosys interview process are Technical, Resume Shortlist and HR.
How to prepare for Infosys 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 Infosys. The most common topics and skills that interviewers at Infosys expect are ETL Testing, DWH Testing, SQL, ETL and SQL Scripting.
What are the top questions asked in Infosys ETL Tester interview?
Some of the top questions asked at the Infosys ETL Tester interview -
Tell us how to improve this page.
Infosys Interviews By Designations
- Infosys System Engineer Interview Questions
- Infosys Software Engineer Interview Questions
- Infosys Technology Analyst Interview Questions
- Infosys Senior Systems Engineer Interview Questions
- Infosys Associate Consultant Interview Questions
- Infosys Software Developer Interview Questions
- Infosys Business Analyst Interview Questions
- Infosys Senior Associate Consultant 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
Interview Process at Infosys ETL Tester
based on 5 interviews in last 1 year
1 Interview rounds
- Technical Round
View more
People are getting interviews through
based on 7 Infosys interviews
Job Portal
Recruitment Consultant
Referral
43%
14%
14%
29% candidates got the interview through other sources.
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Join Infosys Creating the next opportunity for people, businesses & communities
ETL Tester Interview Questions from Similar Companies
Fast track your campus placements
17%
more
than the average ETL Tester Salary in India
View more details
Infosys ETL Tester Reviews and Ratings
based on 13 reviews
Rating in categories
|
Technology Analyst
56.3k
salaries
|  ₹3 L/yr - ₹11 L/yr |
|
Senior Systems Engineer
49.2k
salaries
| ₹2.8 L/yr - ₹8 L/yr |
|
System Engineer
38.7k
salaries
| ₹2.5 L/yr - ₹5.4 L/yr |
|
Technical Lead
30.7k
salaries
| ₹5.2 L/yr - ₹19.5 L/yr |
|
Senior Associate Consultant
26.9k
salaries
| ₹6.2 L/yr - ₹17.1 L/yr |
Explore more salaries
Compare Infosys with
TCS
Compare
Wipro
Compare
Cognizant
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 >
- Infosys Interview Questions >
- Infosys ETL Tester Interview Questions
Share an Interview