AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Accenture
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Accenture ETL Developer Interview Questions and Answers for Experienced
Accenture ETL Developer Interview Experiences for Experienced
2 interviews found
Anonymous
Selected
I appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. Tell me about yourself
- Q2. Tell me about your projects
(2 Questions)
- Q1. Informatica powercenter architecture, scd1, scd2 etc
- Q2. Lookups and where to use them
- Ans.
Lookups are used to retrieve related data from another table based on a common key.
Lookups are used in ETL processes to enrich data by adding additional information from a reference table.
They are commonly used to replace codes with corresponding descriptions, such as replacing product IDs with product names.
Lookups can be performed using SQL joins or lookup transformations in ETL tools like Informatica or Talend.
Skills evaluated in this interview
Interview questions from similar companies
I applied via LinkedIn and was interviewed in Aug 2022. There was 1 interview round.
(2 Questions)
- Q1. Question on logic SCD types
- Q2. Dynamic lookup along with lookup
Interview Preparation Tips
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 Referral and was interviewed in Jul 2024. There was 1 interview round.
(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.
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Aug 2022. There were 3 interview rounds.
(1 Question)
- Q1. Self introduction
(1 Question)
- Q1. Package discussion
I applied via Naukri.com and was interviewed in Dec 2023. There was 1 interview round.
(1 Question)
- Q1. Explain the difference between ETL and ELT?
- Ans.
ETL is Extract, Transform, Load where data is extracted, transformed, and loaded into a data warehouse. ELT is Extract, Load, Transform where data is extracted, loaded into a data warehouse, and then transformed.
ETL involves extracting data from source systems, transforming it according to business rules, and loading it into a data warehouse.
ELT involves extracting data from source systems, loading it into a data wareh...
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 appeared for an interview in Jun 2024.
(2 Questions)
- Q1. Rank and dense rank
- Q2. Scenario based etl question
I applied via Naukri.com and was interviewed in Mar 2022. There was 1 interview round.
(1 Question)
- Q1. Oracle DWH concept Informatica
Interview Preparation Tips
get a job you don't try
Accenture Interview FAQs
Tell us how to improve this page.
Accenture Interviews By Designations
- Accenture Associate Software Engineer Interview Questions
- Accenture Application Developer Interview Questions
- Accenture Application Development Analyst Interview Questions
- Accenture Software Developer Interview Questions
- Accenture Software Engineer Interview Questions
- Accenture Analyst Interview Questions
- Accenture Application Development Associate Interview Questions
- Accenture Senior Analyst 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
- Datastage Developer Interview Questions
- SQL Server Developer Interview Questions
- ETL Lead Interview Questions
- Software Developer Interview Questions
- Show more
Accenture ETL Developer Interview Process for Experienced
based on 2 interviews
Interview experience
ETL Developer Interview Questions from Similar Companies
Fast track your campus placements
Accenture ETL Developer Reviews and Ratings
based on 20 reviews
Rating in categories
|
Application Development Analyst
39k
salaries
|  ₹3 L/yr - ₹12 L/yr |
|
Application Development - Senior Analyst
27.4k
salaries
| ₹7 L/yr - ₹20.2 L/yr |
|
Team Lead
24.9k
salaries
| ₹7.2 L/yr - ₹25.7 L/yr |
|
Senior Software Engineer
18.2k
salaries
| ₹6 L/yr - ₹20 L/yr |
|
Senior Analyst
17.9k
salaries
| ₹5.5 L/yr - ₹21.3 L/yr |
TCS
Cognizant
Capgemini
Infosys
- Home >
- Interviews >
- Accenture Interview Questions >
- Accenture ETL Developer Interview Questions for Experienced
