ETL TESTING CONCEPTS
1. Explain about your project?
2. Explain about your project architecture?
3. Explain about your roles and responsibilities?
4. How many tables you are maintaining in your project, for how many tables you did testing?
5. What all are the challenges you faced while doing ETL testing in your project?
6. Tell me different scenarios which you validated in your project?
7. How you will validate data for Incremental and Initial load data?
8. Which techniques you followed while doing ETL testing?
9. Tell me different test cases for new table?
10. How you will validate data for Enhancement work?
11. How to validate data in target table if source table is present in different database?
12. How to validate data for Flat file to Table?
13. How much amount data maintain in your project Warehouse?
14. Tell me about your client details and explain their business?
15. How to find out duplicate records in a table?
16. Why we need to perform Source minus Target and Target Minus Source?
17. Explain any complex query which you have written while doing testing?
18. What is Entry Criteria and Exit Criteria for your project?
19. What all are your responsibilities in you project?
20. How can you execute more number of test cases with one day span of time, on what basis you will pick test case?
21. What all are different tools you used in your project?
22. What is data completeness check, what kind of checks you perform in this?
23. Defect life cycle?
24. What are different ETL testing techniques?
25. What all are different defects which you have raised in your project?
26. Explain any one of the defect which you have raised recently?
27. Tell me about yourself?
28. Tell me about your professional experience?
29. What all are input and output documents in your project?
30. What all are the tools you have used in your project?
31. How to validate data from text file to table?
32. Explain about architecture of your project?