1. Introduce yourself 2. Difference between smoke and sanity testing 3. Query to find the second highest salary 4. why are you changing your job 5. what is ETL Testing 6. what are the different sources in ETL 7. why do we need staging and ODS layers 8. what is the difference between fact and dimension 9. what will control-m job do
How to find duplicate data in sql? What is SCD type 2?
1st round is written so no interview questions
Q. Explain End-to-End Testing done in ETL Testing.
How to select specific data from tables, How to eliminate duplicates, questions from string handling, delete and update scenario
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
In first round: Joins, rank
few ETL concepts and SQL queries
Viewing 71 - 80 interview questions