I applied online. The process took 1 day. I interviewed at Amazon (Seattle, WA) in Dec 2011
Interview
I was contacted by their internal recruiter 4 months after making an online application to schedule for a phone screening interviewing in the next 2 weeks. Two weeks later i had one detailed phone interview covering both technical and practical experience related question for slightly more than an hour. A similar phone interview was setup after about 3 weeks to speak with someone else from the hiring team.
After about 3 weeks on completing the phone screens, i was invited for an onsite interview, all expenses covered since i was not a local candidate. Onsite interview started at 10.30 and it took an entire day involving 1:1 boardroom one hr interview schedules with a member of the hiring team including over lunch hour. Interview was quite thorough asking detailed technical questions on skills of interest and scenario practical questions with each member of the hiring team, in total about 7 at the close of the day, no break in between.
From my observation, it seems its an organization with a start-up feel but growing very rapidly. The people i spoke are smart, fast paced and are out to get an all rounded best of the best. Dress is very casual with everyone almost wearing jeans. Very nice offices with homely break rooms with game rooms too and dog friendly buildings with onsite cafeteria system
Interview questions [1]
Question 1
Describe with a written code example the usage of an Oracle RANK OVER PARTITION BY analytic function
The interview process was smooth and conversational. The interviewer was calmly asking questions about my previous work experiences and listened patiently. He even gave me ample time to frame my answers.
Interview questions [1]
Question 1
1. Tell me about your previous work experience.
2. Asked few SQL questions
few rounds of interviews ranging between technical and conversational. Mostly in the form of " tell a story of time where ..." to show how you relate to amazon LPs
The first interview is a technical phone interview that assesses your skills in SQL and Python, specifically data analysis with python. The interviewer pastes the description of an SQL problem on the code editor and asks you to write your answer while describing your thought process. They give you hints when you're stuck.
Interview questions [1]
Question 1
Could you tell me the steps involved in the data analysis process?