I applied online. I interviewed at Amazon (Seattle, WA) in Oct 2020
Interview
Phone screening with live coding session. Organized through an automated appointment system. No situational or personal questions. They just wanted to know if I was a robot who could code. If so, I think I'd get the job. But I'm human, so...
Interview questions [1]
Question 1
A few advanced SQL questions I've never encountered on the job.
I applied through an employee referral. The process took 2 weeks. I interviewed at Amazon (Bengaluru) in Dec 2018
Interview
SQL test along with analytics case studies.
There were total of 4 rounds, first-round being the technical round and later followed with analytics and HR round. One should be good with SQL advanced functions and know basic of statistics.
They will send you an excel assessment and you have times to prepare. After around 3 days, there is an interview online that you record yourself with a software(they will send you the link). You have 30 secs for preparing and 1 min to answer 5 questions. You also have to do the assessment, recording using the same software.
Interview questions [1]
Question 1
Strengths and weaknesses?
What is your unique value?