I applied through college or university. I interviewed at Amazon in Sep 2022
Interview
On-Campus opportunity
The first round was on online test it has mcqs on machine learning, eda, data warehousing, cloud computing, english, Aptitude questions logical reasoning questions after this there were 2 interview rounds, in the first interview round questions asked were on SQL and some questions based on their leadership principles such as give us an example where you showed ownership etc.
in the second round v basic sql questions and hr questions were asked
Interview questions [1]
Question 1
difference between where and having and an example where both are used
2 B2B 45 minute rounds, 1st asks some amazon LP questions, a bit tricky and niche use cases of the principles, and then some SQL questions. Same thing for second interview but no SQL. They try to use the LP questions to catch you lacking, since generic answers would go against other LP's so you gotta be careful with how you respond.
4 online assessments - 2 fit-based, one technical SQL, one technical Excel
the fit / decision making based assesments incluse more like less like questions and prioritization questions + delegating / focussing questions. The technical SQL interview relates to in depth SQL questions on how to optimize queries for shorter runtimes aswell as writing your own queries to achieve desired outcomes. Finally, there are 2, 45 minute interviews.
Interview questions [1]
Question 1
Tell me about a time you went above and beyond for a customer.
Primo screening del cv e poi test tecnico riguardo alle competenze richieste per il ruolo. In questo caso, il primo screening avviene basato sulle risposte al test attitudinale e al curriculum vitae