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

Filter interviews by

Infosys ETL Developer Interview Questions, Process, and Tips

Updated 17 Jan 2025

Top Infosys ETL Developer Interview Questions and Answers

Infosys ETL Developer Interview Experiences

5 interviews found

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 23 Aug 2024

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is loads in informatica
  • Ans. 

    Loads in Informatica refer to the process of moving data from source to target in a data warehouse.

    • Loads involve extracting data from source systems

    • Transforming the data as needed

    • Loading the data into the target data warehouse or database

    • Loads can be full, incremental, or delta depending on the requirements

    • Example: Loading customer data from a CRM system into a data warehouse for analysis

  • Answered by AI
  • Q2. Query to find duplicates in table
  • Ans. 

    Use GROUP BY and HAVING clause to find duplicates in a table.

    • Use GROUP BY to group rows with same values together

    • Use HAVING COUNT(*) > 1 to filter out duplicates

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

  • Answered by AI

Skills evaluated in this interview

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 15 Apr 2024

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Performance tuning of ssis packages
  • Ans. 

    Performance tuning of SSIS packages involves optimizing data flow, memory usage, and parallelism.

    • Optimize data flow by using efficient data sources and destinations

    • Minimize memory usage by using appropriate buffer sizes and reducing unnecessary data transformations

    • Increase parallelism by using multiple threads and optimizing task execution order

    • Use performance monitoring tools like SSIS logging and performance counters...

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Basics,ETL Process and performance tuning
Round 3 - HR 

(1 Question)

  • Q1. Past experience

Skills evaluated in this interview

ETL Developer Interview Questions Asked at Other Companies

asked in Ciber
Q1. What are the content of APT_CONFIG_FILE? Can you brief on the rel ... read more
asked in ZS
Q2. What is the process flow of Slowly Changing Dimension Type 2 (SCD ... read more
asked in Ciber
Q3. What is RCP? In What scenario you have used this in your project?
Q4. What is trigger . Do Implementation of types of trigger?
asked in Ciber
Q5. What are the methods available in Aggregator stage?

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 11 Jul 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - One-on-one 

(2 Questions)

  • Q1. Self introduction
  • Q2. Scenario based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 17 Jan 2025

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed before Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. How to delete files older than 30 days?
  • Ans. 

    Use a script to find and delete files older than 30 days.

    • Use a script to identify files older than 30 days based on their creation or modification date

    • Utilize a command like find or PowerShell to search for files older than 30 days

    • Combine the script with a delete command to remove the identified files

  • Answered by AI

Infosys interview questions for designations

 Informatica ETL Developer

 (1)

 Senior ETL Developer

 (1)

 ETL Tester

 (12)

 ETL Testing Engineer

 (1)

 Developer

 (22)

 Software Developer

 (260)

 Java Developer

 (143)

 Salesforce Developer

 (34)

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 15 Jul 2022

Round 1 - Technical 

(2 Questions)

  • Q1. About project worked on
  • Q2. Skill set questions based on what you are worked on
Round 2 - HR 

(1 Question)

  • Q1. Compansation Discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident for what you have on the skillset. Go through the concepts before going to interview with multiple sites.

Interview questions from similar companies

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - One-on-one 

(1 Question)

  • Q1. Which version of talend you are using
  • Ans. 

    I am using Talend version 7.3.1 for ETL development.

    • I am currently using Talend version 7.3.1 for ETL development.

    • The specific version of Talend being used is 7.3.1.

    • Talend 7.3.1 offers various features and improvements for ETL processes.

  • Answered by AI

Skills evaluated in this interview

Interview Questionnaire 

4 Questions

  • Q1. Whats is mapping
  • Ans. 

    Mapping is the process of defining the relationship between source and target data in ETL.

    • Mapping involves identifying the source and target data structures.

    • It also involves defining the transformation rules to be applied to the source data.

    • Mappings can be simple or complex depending on the complexity of the data.

    • Mapping is a critical step in ETL as it determines the accuracy and completeness of the data in the target

  • Answered by AI
  • Q2. What is sesson
  • Ans. 

    Session refers to a period of time during which a user interacts with a computer system or application.

    • A session is created when a user logs into a system or application.

    • It is used to track user activity and maintain user-specific data.

    • Sessions can be terminated manually or automatically after a certain period of inactivity.

    • Session management is important for security purposes.

    • Examples of session management techniques

  • Answered by AI
  • Q3. Which role u did
  • Q4. Oracle sqi pl sqi
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Introduce yourself
  • Ans. 

    I am an experienced ETL Developer with a strong background in data integration and transformation.

    • Over 5 years of experience in ETL development

    • Proficient in using tools like Informatica, Talend, and SSIS

    • Strong SQL skills for data querying and manipulation

    • Experience in designing and implementing data warehouses

    • Familiar with data modeling and ETL best practices

  • Answered by AI
  • Q2. What is SCD type2
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Jan 2022. There were 4 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 - Assignment 

It's an assignment for apti, verbal

Round 3 - Technical 

(1 Question)

  • Q1. It's like an what are u mentioned in resume skills.
Round 4 - HR 

(1 Question)

  • Q1. Just like interaction with candidate like personal details.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepare on what u mentioned in resume skills and self confidence..
Round 1 - Technical 

(1 Question)

  • Q1. About the ETL Process
Round 2 - HR 

(1 Question)

  • Q1. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Good and be confident on what you want to convery.

Infosys Interview FAQs

How many rounds are there in Infosys ETL Developer interview?
Infosys interview process usually has 1-2 rounds. The most common rounds in the Infosys interview process are Technical, HR and One-on-one Round.
How to prepare for Infosys ETL Developer 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, ETL, Software Quality Assurance, Testing Tools and AWS Lambda.
What are the top questions asked in Infosys ETL Developer interview?

Some of the top questions asked at the Infosys ETL Developer interview -

  1. How to delete files older than 30 da...read more
  2. Query to find duplicates in ta...read more
  3. What is loads in informat...read more

Tell us how to improve this page.

Infosys ETL Developer Interview Process

based on 4 interviews

1 Interview rounds

  • Technical Round
View more
Join Infosys Creating the next opportunity for people, businesses & communities
Infosys ETL Developer Salary
based on 219 salaries
₹3 L/yr - ₹9.8 L/yr
18% less than the average ETL Developer Salary in India
View more details

Infosys ETL Developer Reviews and Ratings

based on 15 reviews

3.6/5

Rating in categories

4.0

Skill development

3.6

Work-life balance

2.4

Salary

4.2

Job security

3.7

Company culture

2.2

Promotions

3.3

Work satisfaction

Explore 15 Reviews and Ratings
Python ETL Developer

Pune,

Bangalore / Bengaluru

5-10 Yrs

Not Disclosed

Explore more jobs
Technology Analyst
55.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Systems Engineer
50.6k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

System Engineer
39.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Lead
30.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate Consultant
28k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Infosys with

TCS

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare

Accenture

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview