1. Normalizer transformation 2. How do you read from message queues in Informatica? 3. Scenarios for oracle SQL's and Informatica logic
Etl Developer Interview Questions
1,579 etl developer interview questions shared by candidates
what is a batch load
What is SCD and what are its type?
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
1st round is client round real time scenarios they asked and sql quations like stored procedures , indexing, joins and set operators and dwh concepts , etl process and roles and responsibilities and bug areporting
Describe about yourself and your roles and responsibilities
tool specific questions
1. Scenario based SQL query questions 2. Scenario based python and sql development questions. 3. Guesstimate questions.
Explain about tuning the packages
Viewing 801 - 810 interview questions