What is informatica power center
Etl Engineer Interview Questions
1,581 etl engineer interview questions shared by candidates
Explain the query optimization techniques
About ETL processes, tools
Joins Partition Sql queries Agile
Experience and technology related questions
How to check duplicate
It's only single round of interview and it went for 21 minutes out of 30 minutes. It was easy one.Interviewer asked me about my roles and responsibilities in the current project.Also she asked me the project overview.After that she asked some SQL questions on analytical functions,Agile methodology and also test management tools.So interview was easy and I got selected.
1. Scd type 2 mapping
DB architecture and schema understanding
second round: cross join scenario, browser compatibility testing vs cross browser testing, how to check data of 5000 rows between db and a website(no download/export option), tell me about some etl errors, 3-4 scenario based questions on writing test cases, what to do when we cannot reproduce bugs, regression vs sanity testing
Viewing 691 - 700 interview questions