Interview started with the question of tell about the project details and the work which you used to do in current project, the tools you use to complete the job. The total relevant exp. in ETL. Some questions asked in the interview are: 1. Junk Dimensions 2. Indexes 3. Degenerate keys 4. Diff between natural and Surrogate keys 5. Aggregate functions of SQL 6. Data types usage CLOB, BLOB etc 7. What is Data warehouse 8. Diff between DDL and DML commands. 9. Data Driven Testing 10. Performance tuning in Joins. 11. Conformed Dimensions 12. ACID property 13. Data Marts Definition 14. What are Aggregate tables 15. Explain Union, union all, minus, intersect 16. Benefits of De-normalization in DB 17. OLAP vs OLTP 18. Star vs Bus Schema 19. Cross Join usage 20. Define Refrential Integrity And many questions were asked on SQL queries based on the tables imagined.