I applied online. The process took 4 weeks. I interviewed at Amazon
Interview
Round 1: (technical SQL 45 minutes)
Round 2: Phone screen: Behavioral based on Amazon’s LP (35 minutes 1 interview, follow STAR technique and restrict answers under 3 minutes)
Round 3: Exhaustive one (6 interviews, 45 minutes each with 15 minutes break after each round, follow STAR technique and restrict answers under 3 minutes)
Interview questions [1]
Question 1
Round 1: Phone screen: Live code: Asked about basic SQL questions, nothing behavioral (45 minutes, they guide you and keep explaining while writing queries)
1. Basic SQL questions, 2. Queries: basic related to Date, groupby , join
Round 2: Phone screen: Behavioral based on Amazon’s LP (35 minutes 1 interview, follow STAR technique and restrict answers under 3 minutes)
Round 3:
1 technical SQL interview: advanced SQL queries using CASE, sub queries, Joins, complex queries, a short case study, no behavioral
4 interviews based on Amazon's LP (easy and straight forward)
1 general interaction round with team member
I applied through an employee referral. The process took 1 week. I interviewed at Amazon in Jan 2020
Interview
I applied numerous times and got calls 4 times in 3 months. 3 rounds in total. 1st round was standard HR call. 2nd round was with hiring manager. Was asked to answer based on STAR process. Also got asked to type code in SQL using some online tool. Was asked to answer SQL questions orally as well.
Interview questions [1]
Question 1
Can you describe an instance when you failed to deliver a task?
I applied online. The process took 3 weeks. I interviewed at Amazon in Jan 2020
Interview
Applied online, then was invited to do an excel assessment, video interview and then got a video chat interview with hiring manager. Very professional. Overall the experience was very professional, however because of location I didn't get the position.