I applied through an employee referral. The process took 4 months. I interviewed at Amazon in Mar 2021
Interview
The interview process is a type of its own. There were total 5 rounds of interview.
1st round was screening of basic SQL , data warehousing and data modelling questions.
2nd round was Coding based on my project experience and strong analytical functions in SQL .
3rd round was Coding + Behavioural round .This was also based on my project experience.
4th round was Behavioural Round.
and 5th (Final) round was Bar-Raiser (which was also a behavioural round based on your experience and skillset).
Each and every round was getting tougher and tougher and much more exciting questions.
To crack the interview , I would recommend to be yourself and try to explain as much as deep to make sure that you understand the minute details of the use case and have a good capability of understanding the situation. Try to answer the questions using STAR method (S - Situation , T - Task , A - Action and R - Result ).
Interview questions [1]
Question 1
Based on my experience in different projects and analytical functions in SQL
I applied online. I interviewed at Amazon in Jun 2021
Interview
The first round was pretty comfortable, had very good communication with the interviewer.
The first interview contains two leadership questions and sample technique SQL questions.
The second round was really disappointing, was interviewed by an Indian lady. Simple introduction then directly went into technical questions, which should be from leetcode (not sure), two python questions and one sql question. What was disappointing was that the interviewer was code in the whole process, speaking like she had a bad day, and even not open the video.. During the process I already knew I wouldn't pass.
Interview questions [1]
Question 1
Describe a situation that your colleague failed the job and what did you do?
I applied online. I interviewed at Amazon in Apr 2021
Interview
online assessment, email, phone call
mostly SQL query writing and leadership principles (16) .
behavior questions such as the most difficult project you work on in the past. Tell me about yourself.