I applied online. The process took 4 weeks. I interviewed at Amazon in May 2014
Interview
Applied online in mid-March and got an email in about 3 weeks. It took them quite a while to setup a phone interview. A full 1 month after they first contacted me.
Interview questions [1]
Question 1
Not very difficult but I messed up a question regarding a complex SQL query. I used a union instead of an intersection.
I applied through a recruiter. The process took 1+ week. I interviewed at Amazon (Seattle, WA)
Interview
The interviews are generally long and go on for a day and if you think you did really well, dont expect the outcome to be positive. I had a total of 2 interviews over the phone which was completely technical with a bunch of SQL questions and scenarios. Then I was called for an In-Person interview with overall 8 people. About 4 interviews including the lunch interview was full of SQL questions with a lot of white-boarding. I was about to end the day on a high note but surprisingly it ended up with C# and Algorithm questions, which really baffled me (especially for a data engineer position). I was sure of getting the offer but I did not!!
Interview questions [1]
Question 1
A puzzle which had to be solved using an algorithm and also write code for the same