Beyond, Inc. ETL Developer interview questions

1. How did you come know about the position? 2. Why did you leave your current job and why are you interested in this position? 3. Tell me about yourself 4. Describe your professional experience, explain your roles and responsibilities in the previous/current job. 5. How would you rate yourself in SQL out of 10? 6. Describe SCD Type 2 and Type 3 dimensions with examples. 7. What is CDC (Change Data Capture)? Can you explain with examples? 8. Explain about conformed, degenerate and junk dimensions with examples 9. Explain Fact less fact table, Transaction fact table and Accumulated snapshot fact table with examples 10. What is Ralph Kimball’s Data Warehouse approach? 11. Explain Snow Flake schema and Star schema with examples? Which one of the both schemas are normalized and de-normalized? Which schema design would you prefer in a real time environment? 12. Is Star schema preferred or Snow flake schema preferred? Explain and support your answer. 13. With what type of Schema have your worked previously? 14. Are you aware of Analytic functions in PL/SQL? List out different analytic functions and explain why are they used in real time? 15. What is RowNumber function in PL/SQL? 16. What are Rank and Dense Rank functions in PL/SQL? Explain the difference between them?