I applied online. The process took 1 week. I interviewed at Amazon in Jan 2015
Interview
Applied online and HR emailed within a couple of days to set up initial phone interview. It went well and scheduled a phone interview with hiring manager.
Hiring manager called on time and we jumped directly into SQL coding. First couple of SQL questions were easy and then came a bummer. I probably took a lot of time answering it and still don't know if the answer was correct.
Then there were Oracle specific questions which I didn't know since my most work is in Teradata. The total call lasted around 40 minutes and in next 2-3 days I was informed that I am not moving forward.
Interview process was very fast, I really like to work with Amazon one day.
Interview questions [1]
Question 1
(1) Oracle Partition/ Oracle Indexing
(2) Types of joins
(3) Difference between delete and truncate
(4) Find customer who ordered this year and last year
(5) Other SQL Coding questions
Interview focused on analytical thinking and case studies. Main focus was on the leadership principles. First interview was a phone interview that covered a few basic questions and SQL coding. The loop had 4 rounds.
Interview questions [1]
Question 1
What is the difference between inner and left join?
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
Top companies for "Compensation and Benefits" near you
