Contacted by the HR who then scheduled a phone interview with the team. There was a 30 minutes interview with a member of the team, SQL queries had to be written on the online interface.
The role called for a person with a atleast 3 years experience!
Process is simple,First round is written test with simple sql queries .if that is done and all answers correct then second round will be also a written test with complex Sqls.candidate should be strong in sql.
I applied through a recruiter. I interviewed at Amazon in Jan 2017
Interview
The interview was well coordinated by a recruiter. Recruiter informed priorly what expected in the interview. Interview started with my current experience and then BI questions. Then interviewer started asking Data warehouse questions. I haven't informed to expect DW questions. So, i failed to answer to the full extent. Then asked some SQL coding. Interview was quite cool except DWH questions
Interview questions [1]
Question 1
Asked real-time BI questions and 3 SQL queried and basics of DWH