Informatica ETL Developer Interview Experience - India
Process
The technical round focused mainly on core Informatica concepts, including mapping design, transformation logic, parameterization, and performance tuning techniques.
I was asked to:
- Explain different SCD types.
- Implement lookup and joiner transformations in real-time scenarios.
- Troubleshoot mapping errors.
SQL-related questions included writing complex queries, using window functions, joins, and handling duplicate records. They also tested my understanding of optimization techniques.
Questions
Explain SCD Type 2.
Find duplicates.
Was this helpful?
Interview Statistics
The following metrics were computed from 15 interview experiences for the Capgemini Informatica ETL Developer role in India.
Success Rate
Capgemini's interview process for their Informatica ETL Developer roles in India is on the easier side as most engineers get an offer after going through it.
Experience Rating
Candidates reported having very good feelings for Capgemini's Informatica ETL Developer interview process in India.
Capgemini Work Experiences
- 3.0A good environment to workInformatica ETL Developer • Current EmployeeBangalore Rural, Karnataka, IndiaFebruary 4, 2025Pros: Very flexible work hours, it helps maintain a healthy work-life balance.Cons: Promotion opportunities are limited. One major drawback is that when people are on the bench, RMG people treat them as undervalued.
- 4.0Around 3.11+ years of experience as an ETL Developer on Informatica PowerCenter 10.x. Can join immediatelyInformatica ETL Developer • Current EmployeeFebruary 3, 2023Pros: The working environment is very good and very friendly. Work pressure is less compared to other companies.Cons: There is only one issue: salary is less as compared to other IT firms.
- 3.0Good Team, Lots Of WorkInformatica ETL Developer • Current EmployeeJanuary 18, 2023Pros: Less salary for freshers and more work.Cons: Helping nature of the employees
Capgemini Interview Questions
