How to select specific data from tables, How to eliminate duplicates, questions from string handling, delete and update scenario
Etl Tester Interview Questions
192 etl tester interview questions shared by candidates
What was your role and responsibility in your project?
Informatica
Case vs decode Scd 1 scd 2 How to test old loaded data in DW which is not present in source Join condition on null, empty and 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.
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
In first round: Joins, rank
few ETL concepts and SQL queries
Joins Partition Sql queries Agile
SQL queries testing basics unix aptitude
Viewing 81 - 90 interview questions