I applied online. The process took 2 months. I interviewed at Amazon (New York, NY) in Oct 2022
Interview
back to back 45min *2 The first is about database modeling ends with 2 BQ The second is about SQL optimization, correction and python leetcode easy problem ends with 2 BQ
I applied online. I interviewed at Amazon in Dec 2020
Interview
3 SQL questions and then 1 behavioral interview. I got 2/3 SQL questions wrong and didn't know the behavioral but they were nice and still have me the internship offer.
I applied online. The process took 1 week. I interviewed at Amazon (Clarksville, TN) in Nov 2021
Interview
Before my interview, I came to glassdoor to learn from other peoples experiences. To be honest, All the questions I was asked had already been talked about on glassdoor. I had two sections, 45mins each. Each section was a technical and behavioral.
Interview questions [1]
Question 1
Difference between Star schema and snowflake.
Query Tuning.
SQL coding.
Behavioral questions(LP).
What is the most complex data pipeline you have built.