AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Infosys
Compare
Filter interviews by
Infosys ETL Developer Interview Questions, Process, and Tips
Top Infosys ETL Developer Interview Questions and Answers
- Q1. How to delete files older than 30 days?
- Q2. Query to find duplicates in table
- Q3. What is loads in informatica
Infosys ETL Developer Interview Experiences
5 interviews found
Anonymous
(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
- 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;
Skills evaluated in this interview
(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...
(1 Question)
- Q1. Basics,ETL Process and performance tuning
(1 Question)
- Q1. Past experience
Skills evaluated in this interview
(2 Questions)
- Q1. Self introduction
- Q2. Scenario based questions
Interview Preparation Tips
I applied via Company Website and was interviewed before Jan 2024. There was 1 interview round.
(1 Question)
- Q1. How to delete files older than 30 days?
Infosys interview questions for designations
(2 Questions)
- Q1. About project worked on
- Q2. Skill set questions based on what you are worked on
(1 Question)
- Q1. Compansation Discussion
Interview Preparation Tips
What people are saying about Infosys
Interview questions from similar companies
Selected
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
(4 Questions)
- Q1. Lookup ,router,joiner
- Q2. Different types of caches
- Q3. Scd1 and scd2 implementation
- Q4. Fact and dimensions tables and different data modelling
(1 Question)
- Q1. Salary discuss and location discussion
ETL Developer Interview Questions & Answers
Tech Mahindra
RAMAVATHULA CHANDRA NAIK
posted on 4 Feb 2025
(2 Questions)
- Q1. They were asking very logical and technical questions on interview time
- Q2. They were test our skills and time punctuation
(1 Question)
- Q1. They were discussed with some technical questions and based on knowledge
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Explainyour job role
- Ans.
ETL Developers are responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into a data warehouse.
Designing ETL processes to extract data from multiple sources
Transforming data to meet business requirements
Loading data into a data warehouse or other target systems
Developing and maintaining ETL jobs using tools like Informatica, Talend, or SSIS
- Q2. Explain implementation of SCD 1 in IICS
- Ans.
SCD Type 1 in IICS involves overwriting existing data with new data without maintaining historical changes.
In IICS, use the Mapping Designer to create a mapping that loads data from source to target.
Use a Lookup transformation to check if the record already exists in the target table.
If the record exists, update the existing record with new data using an Update Strategy transformation.
If the record does not exist, inse...
Skills evaluated in this interview
(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
- Q2. What is SCD type2
I was interviewed in Jun 2024.
(2 Questions)
- Q1. Rank and dense rank
- Q2. Scenario based etl question
Infosys Interview FAQs
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 Associate Consultant Interview Questions
- Infosys Senior Systems Engineer 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
- Informatica ETL Developer Interview Questions
- Senior ETL Developer Interview Questions
- Database Developer Interview Questions
- Informatica Developer Interview Questions
- SQL Server Developer Interview Questions
- ETL Lead Interview Questions
- Datastage Developer Interview Questions
- Software Developer Interview Questions
- Show more
Infosys ETL Developer Interview Process
based on 4 interviews
1 Interview rounds
- Technical Round
ETL Developer Interview Questions from Similar Companies
Fast track your campus placements
Infosys ETL Developer Reviews and Ratings
based on 13 reviews
Rating in categories
|
Technology Analyst
55.9k
salaries
|  ₹3 L/yr - ₹11 L/yr |
|
Senior Systems Engineer
50.5k
salaries
| ₹2.8 L/yr - ₹8 L/yr |
|
System Engineer
39.5k
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
|
Technical Lead
30.7k
salaries
| ₹5.2 L/yr - ₹19.5 L/yr |
|
Senior Associate Consultant
27.8k
salaries
| ₹6.2 L/yr - ₹16.8 L/yr |
TCS
Wipro
Cognizant
Accenture
- Home >
- Interviews >
- Infosys Interview Questions >
- Infosys ETL Developer Interview Questions
