Informatica
Etl Tester Interview Questions
192 etl tester interview questions shared by candidates
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.
Joins Partition Sql queries Agile
How to check duplicate
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
In first round: Joins, rank
few ETL concepts and SQL queries
SQL queries testing basics unix aptitude
Dimension table Fact table Full load n incremental load Query to find duplicates
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 81 - 90 interview questions