I applied online. The process took 4 weeks. I interviewed at Amazon (Vancouver, BC) in May 2025
Interview
Applied Online
1. 2 and a half hour OA focusing on SQL and Python (mostly SQL with pretty difficult questions)
2. Invited to a first round interview with a senior data engineer -> focused on a few LPs like Customer Obsession and was asked to code in SQL and Python, with questions going up in difficulty gradually. Was also asked data modelling
3. Final interview loop (total of 5 hours with 4 total interviews) - 3 focusing on designing data applications, data engineering terminology ex) OLAP vs. OLTP, when to use each, System Design such as design a system that processes a lot of user orders each day -> Follow up questions such as: The current system is performing slow, how would you test and improve the database?
Interview questions [1]
Question 1
ex) OLAP vs. OLTP, when to use each, System Design such as design a system that processes a lot of user orders each day -> Follow up questions such as: The current system is performing slow, how would you test and improve the database?
Very difficult process it took me a round 1 month to get back what’s the review for the interview so I think overall it’s bad experience and difficult interview process while it has lot of questions I wa able to answer
Standard three-round process consisting of an online assessment followed by a comprehensive interview loop, where candidates were evaluated across technical skills, problem solving ability, and overall fit for the role.
In my 5th semester, Amazon visited our campus to hire interns for multiple roles, and I was shortlisted for the Data Engineer role.
I cleared the online assessment and attended two technical interviews. The first round focused on coding, while the second round focused on SQL. I faced some challenges in the SQL round, and although I was not selected, the experience helped me identify areas for improvement, especially in advanced SQL concepts
Top companies for "Compensation and Benefits" near you
