I applied online. The process took 4 weeks. I interviewed at Amazon (Seattle, WA) in Dec 2023
Interview
2 45-minute interview with a Sr. Data Engineer and Data Engineer. SQL questions on Joins, group by and Date functions, and then Amazon Leadership principles. Overall it was not bad but the amazon leadership principles really got me bad
Interview questions [1]
Question 1
array = [1, 4, 7, 9,11, 15, 13]. Write a function to return missing integers. 2 tables in SQL and use LEFT JOIN
I applied online. The process took 4 weeks. I interviewed at Amazon in Nov 2023
Interview
fairly basic technical interview, questions solely on python and sql. So on python they asked me about file management, use of pandas and numpy while about sql the types of joins, and a few queries just with sum or count
I applied through an employee referral. The process took 2 weeks. I interviewed at Amazon (New York, NY) in Nov 2023
Interview
Two 1 hour long interviews. SQL and Python questions. Lots of conceptual questions and Leadership principles. Mainly conceptual questions with only a few technical questions. Overall wasn't too bad. Easy for someone with data engineer experience.
Interview questions [1]
Question 1
Left outer join, inner join, right outter join, full join