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.5k Reviews

Filter interviews by

Infosys ETL Tester Interview Questions and Answers for Freshers

Updated 14 Jun 2022

Infosys ETL Tester Interview Experiences for Freshers

1 interview found

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

Interview questions from similar companies

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

I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

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

    Snowflake schema is a normalized form of star schema with additional dimension tables.

    • Snowflake schema is a data modeling technique used in data warehousing.

    • In snowflake schema, dimensions are normalized into multiple related tables.

    • Snowflake schema reduces redundancy and improves data integrity.

    • Star schema is a denormalized form of snowflake schema with a single dimension table.

    • In star schema, dimensions are not norma...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay clam and tell me the truth.
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 - HR 

(8 Questions)

  • Q1. What are your salary expectations?
  • Q2. What is your family background?
  • Q3. Share details of your previous job.
  • Q4. Why should we hire you?
  • Q5. Why are you looking for a change?
  • Q6. Where do you see yourself in 5 years?
  • Q7. What are your strengths and weaknesses?
  • Q8. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Well prepare dear students and show good attitude and maners
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed in May 2024.

Round 1 - Technical 

(10 Questions)

  • Q1. Basics of Selenium(Windowhandles,Screenshot,Actions class,Selector Class,) with syntax
  • Q2. Asked to write Automation Framework architecture
  • Q3. What are the different gherkin words
  • Ans. 

    Gherkin words are keywords used in Gherkin syntax for writing test scenarios in Behavior Driven Development (BDD).

    • Feature

    • Scenario

    • Given

    • When

    • Then

    • And

    • But

  • Answered by AI
  • Q4. What we will use in plugin
  • Ans. 

    Plugins are used to extend the functionality of a software application.

    • Plugins are additional software components that can be added to an existing application to provide new features or functionalities.

    • They can be used to customize the behavior of the application without modifying its core code.

    • Examples of plugins include browser extensions, WordPress plugins, and Adobe Photoshop filters.

  • Answered by AI
  • Q5. How to run runner class
  • Ans. 

    To run a runner class, you can use a test runner tool like JUnit or TestNG in your automation testing framework.

    • Use a test runner tool like JUnit or TestNG to execute the runner class

    • Add the @RunWith annotation in JUnit or specify the runner class in TestNG XML file

    • Make sure the runner class includes the necessary setup and teardown methods for test execution

  • Answered by AI
  • Q6. Java oops, strings , exception handling
  • Q7. How to run parallel mode in testng,groups,priority
  • Ans. 

    TestNG allows running tests in parallel mode using groups and priorities.

    • Use 'parallel' attribute in testng.xml file to specify parallel mode (e.g. )

    • Use 'groups' attribute in testng.xml file to group tests that should run in parallel (e.g. )

    • Use 'priority' attribute in testng.xml file to specify the order in which tests should run (e.g.

  • Answered by AI
  • Q8. Write Merge Sort Programme
  • Ans. 

    Merge Sort is a divide and conquer algorithm that divides the input array into two halves, sorts them, and then merges them back together.

    • Divide the array into two halves recursively

    • Sort each half using Merge Sort recursively

    • Merge the sorted halves back together

  • Answered by AI
  • Q9. Write Reverse a string programme
  • Ans. 

    Program to reverse a string using array of characters

    • Create an array of characters from the input string

    • Iterate through the array in reverse order and append each character to a new string

    • Return the reversed string

  • Answered by AI
  • Q10. Write syntax of data driven testing (XSSF Workbook) Syntax
  • Ans. 

    Data driven testing syntax using XSSF Workbook

    • Create XSSFWorkbook object

    • Get the sheet from the workbook

    • Iterate through rows and columns to fetch test data

    • Use test data in your test cases

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Selenium basics ( window handles , screenshot,reports, file upload and download, Add extension, Headless mode)

Interview Preparation Tips

Interview preparation tips for other job seekers - I would say it is easy to crack Service based Companies. Just prepare all the concepts of Selenium, Java,TestNG,Maven,GitHub and basic 20 Programmes.

For Selenium and BDD(Cucumber)Learn Rahul Shetty Udemy course
For Java search and learn top 200 interview questions.
Basic programmes like ( Duplicate characters,reverse string,unique characters, string anagram, Bubble sort , merge sort, quick sort and some more) .

How I switched from my current company.
Do’s
Uninstall social media apps.
Stop watching movies.
Stop eating Junk food.
Study at least 1-2 hours daily.
Listen motivational songs.
Make connections on LinkedIn.
Make single page resume by creating on overleaf website.

How to apply to companies.
Don’t apply directly on company website(Big mistake)
Send resumes to hr directly(u will get their mails on some posts on LinkedIn)
Ask referral on LinkedIn.
Update Naukri daily 9am and put notice period to 30 or 15days.

Skills evaluated in this interview

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

I applied via Job Portal

Round 1 - Aptitude Test 

Reasoning,numerical ,ratios

Round 2 - Coding Test 

Basic coding questions

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Oct 2023. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Team will test and decide whether the candidate is technically strong or weak
  • Q2. Why you want to quit the job
  • Q3. How technically your strong in Performance testing
  • Ans. 

    I have strong technical skills in performance testing through hands-on experience with various tools and technologies.

    • Proficient in using performance testing tools such as JMeter, LoadRunner, and Gatling

    • Experience in designing and executing performance test scenarios to identify bottlenecks and optimize system performance

    • Knowledge of performance monitoring tools like New Relic and AppDynamics

    • Ability to analyze test res...

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. Salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Team will test whether the candidate is technically strong or weak .

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Jan 2024.

Round 1 - Technical 

(1 Question)

  • Q1. OOPS Concept Interface Inheritance Method Overloading Hashmap, Hashtable Agile methodology Bug cycle Defect management tool Different types of Xpath How to generate report in selenium
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Selected Selected
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 

(3 Questions)

  • Q1. Coding palindrome number
  • Ans. 

    Coding a function to check if a number is a palindrome

    • Create a function that takes in a number as input

    • Convert the number to a string to easily check for palindrome

    • Reverse the string and compare it with the original string to check for palindrome

    • Return true if the number is a palindrome, false otherwise

  • Answered by AI
  • Q2. Am strong number and put output
  • Q3. Find the xpath of an site
  • Ans. 

    To find the xpath of a site, inspect the element in the browser and use developer tools.

    • Inspect the element on the website using browser developer tools

    • Right click on the element and select 'Inspect' to view the HTML code

    • Locate the element in the HTML code and right click to copy the xpath

    • Use the copied xpath in your automation scripts for testing

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Tell me something about yourself?
  • Q2. Tell about your last working job?

Interview Preparation Tips

Interview preparation tips for other job seekers - Do your best

Skills evaluated in this interview

QA Tester Interview Questions & Answers

TCS user image Anonymous

posted on 11 Oct 2022

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about yoursef
  • Q2. What you like to do while not

Interview Preparation Tips

Interview preparation tips for other job seekers - clear your basics be calm and answervb properly do not hesitate or mur mur in between low salary high attrition rate
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

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

    Snowflake schema is a normalized form of star schema with additional dimension tables.

    • Snowflake schema is a data modeling technique used in data warehousing.

    • In snowflake schema, dimensions are normalized into multiple related tables.

    • Snowflake schema reduces redundancy and improves data integrity.

    • Star schema is a denormalized form of snowflake schema with a single dimension table.

    • In star schema, dimensions are not norma...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay clam and tell me the truth.

Infosys Interview FAQs

How many rounds are there in Infosys ETL Tester interview for freshers?
Infosys interview process for freshers usually has 1 rounds. The most common rounds in the Infosys interview process for freshers are Technical.
How to prepare for Infosys ETL Tester interview for freshers?
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 for freshers?

Some of the top questions asked at the Infosys ETL Tester interview for freshers -

  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. SQL quries like find out duplicates,highest salary, group by,order by ...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Infosys interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small 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 156 salaries
₹2.9 L/yr - ₹12.8 L/yr
17% 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
Technology Analyst
56.5k salaries
unlock blur

₹3 L/yr - ₹11 L/yr

Senior Systems Engineer
49.2k salaries
unlock blur

₹2.8 L/yr - ₹8 L/yr

System Engineer
38.7k salaries
unlock blur

₹2.5 L/yr - ₹5.5 L/yr

Technical Lead
30.6k salaries
unlock blur

₹5.2 L/yr - ₹19.4 L/yr

Senior Associate Consultant
26.9k salaries
unlock blur

₹6.2 L/yr - ₹16.8 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