I applied through an employee referral. The process took 2 weeks. I interviewed at Amazon in Oct 2016
Interview
I requested my friend to refer me and got email confirmation from HR team, I was asked to provide 3-4 timeslots for the interview and given accordingly. I was contacted by a technical team member and interviewed for an hour.
Interview questions [1]
Question 1
Write sql to provide output for a given a scenario, e.g various approach to write sqls, PIVOT, WITH , JOIN Subqueries, Analytical functions etc.