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 Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 36.9k Reviews

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???
View all 27 questions

Infosys ETL Tester Interview Experiences

11 interviews found

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 13 Oct 2021

Interview Questionnaire 

5 Questions

  • Q1. Data warehouse and database
  • Q2. Basics of ETL testing
  • Q3. SQL quries like find out duplicates,highest salary, group by,order by etc
  • Ans. 

    Answering SQL queries related to finding duplicates, highest salary, grouping and ordering data.

    • To find duplicates, use the GROUP BY clause with HAVING COUNT(*) > 1

    • To find highest salary, use the MAX() function with the appropriate column

    • To group data, use the GROUP BY clause with the appropriate column(s)

    • To order data, use the ORDER BY clause with the appropriate column(s)

  • Answered by AI
  • Q4. Difference Between union and union all,having and where, rank and dense rank(),minus and intersection
  • Ans. 

    Explaining the differences between union and union all, having and where, rank and dense rank(), minus and intersection.

    • Union combines the result sets of two or more SELECT statements, while Union All returns all rows including duplicates.

    • Having is used to filter the results of an aggregate function in a GROUP BY clause, while Where is used to filter rows before grouping.

    • Rank assigns a unique rank to each row within a ...

  • Answered by AI
  • Q5. How do you get data integrity between source and destination, how you perform loading technique.
  • Ans. 

    Data integrity is ensured through ETL testing and loading techniques.

    • Perform ETL testing to ensure data accuracy and completeness.

    • Use data profiling to identify data quality issues.

    • Perform data mapping to ensure correct data transfer.

    • Use checksums to verify data integrity.

    • Perform data validation to ensure data consistency.

    • Use error handling and logging to track and resolve issues.

    • Use incremental loading to improve perf

  • Answered by AI

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

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 18 Aug 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Technical 

(10 Questions)

  • Q1. Write an SQL query to fetch 5th ,10th,15th .. records from a table?
  • Ans. 

    Use OFFSET and FETCH in SQL to retrieve specific records from a table.

    • Use OFFSET to skip the first n-1 records

    • Use FETCH to limit the number of records to be retrieved

    • Example: SELECT * FROM table_name OFFSET 4 ROWS FETCH NEXT 5 ROWS ONLY

  • Answered by AI
  • Q2. What are constraints?
  • Ans. 

    Constraints are rules or conditions that must be followed in order to ensure data integrity and accuracy.

    • Constraints define the limits or restrictions on data values in a database table

    • Examples of constraints include primary key, foreign key, unique key, and check constraints

    • Constraints help maintain data quality and consistency in a database

  • Answered by AI
  • Q3. What is Low Priority , Medium Priority & High priority defects?
  • Ans. 

    Low, Medium, and High priority defects are categorized based on their impact on the system and urgency of fixing.

    • Low priority defects are minor issues that do not significantly impact the system's functionality.

    • Medium priority defects are issues that have a noticeable impact on the system but are not critical.

    • High priority defects are critical issues that severely impact the system's functionality and need immediate at...

  • Answered by AI
  • Q4. White box , Black Box ,regression , Retesting?
  • Q5. Joins ? with example
  • Ans. 

    Joins are used to combine rows from two or more tables based on a related column between them.

    • Joins are used in SQL to retrieve data from multiple tables based on a related column.

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

  • Answered by AI
  • Q6. Window function queries?
  • Q7. Domain name from an email ?
  • Ans. 

    A domain name from an email refers to the part after the @ symbol in an email address.

    • The domain name is typically the name of the organization or service provider associated with the email address.

    • For example, in the email address example@gmail.com, 'gmail.com' is the domain name.

  • Answered by AI
  • Q8. Rank dense_rank() ,row_numebr with example?
  • Ans. 

    dense_rank() assigns a unique rank to each distinct row, row_number() assigns a unique sequential integer to each row.

    • dense_rank() is used to assign a unique rank to each distinct row based on the specified order.

    • row_number() is used to assign a unique sequential integer to each row in the result set.

    • Example: dense_rank() - SELECT dense_rank() OVER (ORDER BY salary) AS rank FROM employees;

    • Example: row_number() - SELECT...

  • Answered by AI
  • Q9. SCD Types , Star Schema Vs SnowFlake Schema
  • Ans. 

    SCD types refer to slowly changing dimensions in data warehousing. Star schema is denormalized while snowflake schema is normalized.

    • SCD types refer to how dimensions change over time in a data warehouse

    • Type 1: Overwrite existing data with new data

    • Type 2: Keep track of historical data with new records

    • Type 3: Keep track of some historical data with limited history

    • Star schema is denormalized with a central fact table conn...

  • Answered by AI
  • Q10. Group by clause and how it work with a query
  • Ans. 

    Group by clause is used in SQL to group rows that have the same values into summary rows.

    • Group by clause is used with aggregate functions like SUM, COUNT, AVG, etc.

    • It is used to group rows based on one or more columns specified in the query.

    • Group by clause must be used after the WHERE clause and before the ORDER BY clause.

    • Example: SELECT department, COUNT(*) FROM employees GROUP BY department;

  • Answered by AI
Round 2 - HR 

(4 Questions)

  • Q1. Salary expectations
  • Q2. Where do you see yourself in 5 years
  • Q3. Reason for job switch?
  • Ans. 

    Seeking new challenges and growth opportunities in a different environment.

    • Desire for career advancement

    • Interest in learning new technologies

    • Seeking a more challenging role

    • Company restructuring or downsizing

    • Relocation to a different city

  • Answered by AI
  • Q4. Strengths & weakness ?
  • Ans. 

    My strengths include attention to detail and problem-solving skills. My weakness is sometimes being too critical of my own work.

    • Strength: Attention to detail - I always ensure that all aspects of the testing process are thoroughly checked.

    • Strength: Problem-solving skills - I am able to quickly identify and resolve issues that arise during testing.

    • Weakness: Being too critical of my own work - I sometimes spend too much

  • Answered by AI

Skills evaluated in this interview

ETL Tester Interview Questions Asked at Other Companies

asked in Cognizant
Q1. If we have 200 staging tables, 40 dimensions tables and 20 facts ... read more
asked in Cognizant
Q2. 2.Difference between Union and union all,drop and Truncate,star s ... read more
Q3. What is the difference between Test Plan and Test strategy
asked in Cognizant
Q4. Which type of Validation you will do at Landing and staging area.
asked in Infosys
Q5. How do you get data integrity between source and destination, how ... read more

ETL Tester Interview Questions & Answers

user image Rohan Verma

posted on 23 Jun 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(6 Questions)

  • Q1. Self Introduction and About current Project
  • Q2. What is SCD Type 2
  • Ans. 

    SCD Type 2 stands for Slowly Changing Dimension Type 2, which is a data warehousing concept used to track historical changes in data.

    • SCD Type 2 maintains historical data by creating new records for changes and preserving old records

    • It includes additional columns like start date, end date, and version number to track changes

    • Example: If a customer changes their address, a new record is created with the updated address wh...

  • Answered by AI
  • Q3. Test Plan and Test Strategy
  • Q4. Query to find duplicates
  • Ans. 

    Query to find duplicates in a database table

    • Use GROUP BY and HAVING clause to identify duplicate records

    • Select columns to check for duplicates

    • Use COUNT() function to count occurrences of each unique value

  • Answered by AI
  • Q5. Query to fetch nth highest salary
  • Ans. 

    Use SQL query with ORDER BY and LIMIT to fetch nth highest salary

    • Use ORDER BY salary DESC to sort salaries in descending order

    • Use LIMIT n-1,1 to fetch the nth highest salary

    • Replace n with the desired position of the salary

  • Answered by AI
  • Q6. Query to fetch 3
  • Ans. 

    Use SQL query to fetch the number 3 from a database table.

    • Use SELECT statement with WHERE clause to filter for the number 3

    • Example: SELECT * FROM table_name WHERE column_name = 3

  • Answered by AI

Skills evaluated in this interview

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 17 May 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Recruitment Consulltant and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. Types of SCD and its types
  • Ans. 

    Slowly Changing Dimensions (SCD) are used in data warehousing to track changes to data over time. Types include Type 1, Type 2, and Type 3.

    • Type 1 SCD: Overwrites old data with new data, losing historical information.

    • Type 2 SCD: Creates a new record for each change, preserving historical data.

    • Type 3 SCD: Tracks changes by adding columns to the existing record, allowing for limited historical analysis.

  • Answered by AI
  • Q2. How to find duplicates in SQL?
  • Ans. 

    Use the GROUP BY clause with COUNT() function to find duplicates in SQL.

    • Use GROUP BY clause with COUNT() function to group the records by the columns you want to check for duplicates

    • Filter the results by using HAVING clause to only show records with count greater than 1

    • Example: SELECT column1, column2, COUNT(*) FROM table_name GROUP BY column1, column2 HAVING COUNT(*) > 1;

  • Answered by AI
  • Q3. Test Case vs Test Scenario
  • Ans. 

    Test Case is a detailed set of conditions and steps to be followed to validate a particular functionality, while Test Scenario is a high-level description of the functionality to be tested.

    • Test Case is detailed and specific, while Test Scenario is high-level and general.

    • Test Case includes steps, expected results, and test data, while Test Scenario is more of an overview.

    • Test Case is used for detailed testing, while Tes...

  • Answered by AI
  • Q4. Define bug life cycle
  • Ans. 

    Bug life cycle is the process of a bug from identification to resolution in software testing.

    • Bug is identified by tester

    • Bug is reported in bug tracking tool

    • Bug is assigned to developer

    • Developer fixes the bug

    • Bug is retested by tester

    • Bug is closed if fixed or reopened if not

  • Answered by AI

Skills evaluated in this interview

Infosys interview questions for designations

 ETL Developer

 (4)

 Informatica ETL Developer

 (1)

 Senior ETL Developer

 (1)

 Software Tester

 (20)

 Performance Tester

 (5)

 Manual Tester

 (4)

 Automation Tester

 (3)

 QA Tester

 (2)

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 16 Aug 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. EXPLAIN INNER JOIN
  • Ans. 

    Inner join combines rows from two tables based on a related column between them.

    • Inner join returns only the rows that have matching values in both tables.

    • It is the most common type of join used in SQL.

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

  • Answered by AI

Skills evaluated in this interview

Get interview-ready with Top Infosys Interview Questions

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 9 Sep 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Define Views, types of views
  • Ans. 

    Views in ETL testing are virtual tables that display data from one or more tables based on a query.

    • Views are created using SELECT query on one or more tables.

    • They do not store data physically, but display data from underlying tables.

    • Views can be used to simplify complex queries, restrict access to certain columns, or provide a different perspective on the data.

    • Types of views include Simple Views, Complex Views, Materia

  • Answered by AI
  • Q2. Query to get 3rd highest salary
  • Ans. 

    Use SQL query with ORDER BY and LIMIT to get 3rd highest salary.

    • Use SELECT statement with ORDER BY salary DESC to sort salaries in descending order

    • Use LIMIT 1,1 to skip the first two highest salaries and get the third highest salary

  • Answered by AI

Skills evaluated in this interview

ETL Tester Jobs at Infosys

View all

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 27 Feb 2023

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jan 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(4 Questions)

  • Q1. Difference between Star schema and snowflake schema.
  • Ans. 

    Star schema has a single fact table and denormalized dimension tables, while snowflake schema has normalized dimension tables.

    • Star schema is simpler and easier to understand, but can lead to data redundancy.

    • Snowflake schema is more complex but saves storage space and allows for more flexibility in querying.

    • Star schema is better suited for smaller datasets, while snowflake schema is better for larger datasets.

    • Example of...

  • Answered by AI
  • Q2. Difference between white box and black box testing.
  • Ans. 

    White box testing is testing the internal structure of the application while black box testing is testing the functionality without knowledge of the internal structure.

    • White box testing is also known as clear box testing or structural testing.

    • It requires knowledge of the internal workings of the application.

    • Examples include unit testing and integration testing.

    • Black box testing is also known as functional testing.

    • It do...

  • Answered by AI
  • Q3. Explain defect life cycle.
  • Ans. 

    Defect life cycle is the process of identifying, reporting, prioritizing, fixing, and verifying defects in software.

    • Defect is identified by testers during testing

    • Defect is reported to development team

    • Development team prioritizes and fixes the defect

    • Fixed defect is verified by testers

    • If defect is not fixed, it goes back to development team

    • If defect is fixed, it is closed

  • Answered by AI
  • Q4. SQL query to find second highest salary.
  • Ans. 

    SQL query to find second highest salary.

    • Use ORDER BY clause in descending order to sort the salaries

    • Use LIMIT 1,1 to select the second highest salary

    • Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared, confident and positive.
Listen question carefully and reply properly.

Skills evaluated in this interview

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 28 Oct 2022

I applied via Recruitment Consulltant and was interviewed in Sep 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(2 Questions)

  • Q1. What is fact table,dimenssion table,star schema,snowflake schema???
  • Ans. 

    Fact table, dimension table, star schema, and snowflake schema are concepts in data warehousing.

    • Fact table contains the measures or metrics of the data warehouse.

    • Dimension table contains the attributes or dimensions of the data warehouse.

    • Star schema is a type of schema where a fact table is connected to multiple dimension tables.

    • Snowflake schema is a type of schema where dimension tables are normalized into multiple re...

  • Answered by AI
  • Q2. What is mapping design????
  • Ans. 

    Mapping design is the process of creating a mapping between source and target data structures.

    • It involves identifying the source and target data structures

    • Defining the transformation rules to convert the source data to target data

    • Creating a mapping document to document the mapping rules

    • Examples include ETL mapping design for data integration projects

  • Answered by AI

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

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 10 Oct 2021

I applied via Recruitment Consultant and was interviewed in Sep 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Related subject

Interview Preparation Tips

Interview preparation tips for other job seekers - Ready to attend the interview

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 11 Oct 2020

Interview Questionnaire 

4 Questions

  • Q1. Data warehouse concepts
  • Q2. Agile methodologies
  • Q3. Test plan and startegies
  • Q4. SQL basic queries

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 14 Jun 2022

I applied via Naukri.com and was interviewed before Jun 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Normal SQL questions like find 3rd highest salary, joins, analytical functions, Unix commands

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident it's fine if you don't answer for all the questions

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 -

  1. How do you get data integrity between source and destination, how you perform l...read more
  2. Difference Between union and union all,having and where, rank and dense rank(),...read more
  3. what is fact table,dimenssion table,star schema,snowflake schema...read more

Tell us how to improve this page.

Infosys ETL Tester Interview Process

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

TCS ETL Tester Interview Questions
3.7
 • 4 Interviews
View all
Infosys ETL Tester Salary
based on 160 salaries
₹2.7 L/yr - ₹12.9 L/yr
15% more than the average ETL Tester Salary in India
View more details

Infosys ETL Tester Reviews and Ratings

based on 13 reviews

4.4/5

Rating in categories

4.4

Skill development

4.5

Work-Life balance

3.9

Salary & Benefits

3.7

Job Security

4.5

Company culture

3.5

Promotions/Appraisal

4.0

Work Satisfaction

Explore 13 Reviews and Ratings
ETL Tester(PAN INDIA)

Hyderabad / Secunderabad,

Pune

+1

2-7 Yrs

₹ 2.9-15 LPA

ETL Tester-

Hyderabad / Secunderabad,

Pune

+1

4-9 Yrs

Not Disclosed

Explore more jobs
Technology Analyst
56.3k salaries
unlock blur

₹3 L/yr - ₹11 L/yr

Senior Systems Engineer
49.4k salaries
unlock blur

₹2.8 L/yr - ₹9.2 L/yr

System Engineer
38.9k salaries
unlock blur

₹2.5 L/yr - ₹5.5 L/yr

Technical Lead
30.7k salaries
unlock blur

₹5.2 L/yr - ₹19.5 L/yr

Senior Associate Consultant
27.1k salaries
unlock blur

₹6.2 L/yr - ₹17 L/yr

Explore more salaries
Compare Infosys with

TCS

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.8
Compare

Accenture

3.9
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
write
Share an Interview