I applied through a recruiter. The process took 2 weeks. I interviewed at Amazon (Seattle, WA) in Sep 2019
Interview
Very quick and efficient. Recruiter reached out. Set up a telephonic interview after a quick call and approval from hiring manager. Was initially considered for a data engineer position then considered for a business intelligence after the call
Interview questions [3]
Question 1
If there is a project on which you have never worked before, how will you tell that the data you are using for this project is correct and will help you get the correct results?
SQL question - Table1
year| month| order_id| seller_id| book| quantity| prices
2008|June| 1|888|HP| 2| 2000
2008|June| 1|888|LoTR| 1| 1000
2009|July| 2|999|HP| 1| 1000
Q1. find avg quantity of books solder for every order_id every year?
Q2. find max units of books sold for every order_id
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
