I applied online. The process took 2 weeks. I interviewed at Amazon (Seattle, WA) in Apr 2012
Interview
I was originally contacted via e-mail by a recruiter and told that the hiring manager wanted to speak with me. I had a 1hr conversation with the hiring manager that involved just a couple of SQL questions and then behavioral questions. A few days later the recruiter told me I would be moving to the next round and scheduled a 2nd interview 13 days later. The 2nd interview was a technical SQL interview that lasted 30 minutes.
Interview questions [3]
Question 1
You have a table called Order with Cust_ID, Order_Date, Order_ID, Tran_Amt. Select the top 100 customers with high spend over a year long period.
What is the difference between DELETE and TRUNCATE?
What is the difference between UNION and UNION ALL?
What is the difference between a WHERE statement and a HAVING clause?
You have been asked to send an e-mail campaign to customers that have made a purchase on Amazon.com in the past but not recently. Tell me how you would go about the process. Now tell me the structure of the query you would use.
I applied online. The process took 1 week. I interviewed at Amazon (Seattle, WA) in July 2025
Interview
Had with an hiring manager for about an Hour.The followup questions are toughHad with an hiring manager for about an Hour.The followup questions are tough. He asked me very deep info
Interview questions [1]
Question 1
Questions related to my project.But they observe very deep detail
This was the recruiter video call. They will ask to share a bit about your background. Then ask you questions to get a sense of your knowledge in SQL and some of the projects you've worked on.
Interview questions [1]
Question 1
Tell me about the data analytic projects that you work on currently. Also whether you have any programming skills such as PYthon.
Se basaba en lo siguiente la entrevista
Pregunta de leaderhsip de Amazon
Una pregunta de SQL y otra de Python
Se hace como en un notepad y no se compila