L1 Technical + L2 Managerial
🔹 L1 – Technical Round
1. Tell me about yourself and your ETL Testing experience.
2. Why are you looking for a job change?
3. Do you have any offers in hand?
4. Explain your recent project and end-to-end ETL flow.
5. Explain the different layers involved in your ETL architecture.
6. What transformations and business rules did you validate?
7. How do you perform source-to-target data validation?
8. What SQL queries do you use for data comparison?
9. How do you validate SCD Type 2?
10. Write a SQL query for SCD Type 2 validation.
11. What data quality checks do you perform?
12. How do you identify missing, duplicate, and incorrect records?
13. Write SQL to find the 3rd-highest salary per department.
14. Write SQL to identify customers whose July purchases exceed ₹2,000.
15. What is your SQL proficiency level?
🔹 L2 – Managerial
16. Agile or Waterfall? What was your sprint duration?
17. How would you handle receiving a build just before sprint closure?
18. What is RTM?
19. What are the key QA deliverables/artifacts?
20. What is prepared during the Test Design phase?
21. What deliverable follows Test Execution?
22. Are you serving notice? What is your LWD?
23. Are you comfortable with a 4-day hybrid work model?
24. When can you join?
25. Do you have any questions for us?
Hope this helps fellow QA & ETL Testing professionals preparing for KPMG interviews. 🚀
