DELOITTE INTERVIEW Questions

1.Explain ETL Architecture used in your project


2. How to delete duplicate rows in a table

3. How to find third highest salary

4. Different types of indexes

5. Difference between partition by and group by

6. What is Test Plan? What are the contents in it?

7. Difference between Test strategy and test plan

8. How the sampling would be done for a table with 1million records

9. How the setting up of data had done, and how you identify which all data are needed to test?

10. What is boundary value analysis, and how it can be used in ETL testing

11. Explain about your one day in office

12. The incident which made you to frustrate a lot, and provided happiness at the end

13. What all risks identified in the project

14. What is smoke testing, whether it can be implemented in ETL testing, and how?

15. Why we need foundation tables, while the reporting is mapped to Semantic layer, and why we cannot design without foundation?

16. Why landing area is required, if it is the mirror of source and no transformations are applied between sources and landing?

17. Write test cases that can be used between landing and staging

18. In your project effort estimation is done on the basis of which method.