Technical round Questions: Live examples ppl have faced at amazon – Writing SQLs and more Complex SQLs, Designing Data Marts. Loads of DW and SQL Questions, with work experience anyone would be able to crack them. Atleast 5 each round. Questions to understand your exposure to DW designs. You can expect 5 Questions each round. Challenges faced (Would be asked by everyone). This is tricky one and I explaining only one scenario to all 7 ppl (was a negative point against me). I felt 1 Scenario in 10 years of work experience would raise doubts about my experience. Design a database for specific scenario (would be asked by everyone). We need to white board the example and use all your knowledge. This one is really really important.
