I applied online. The process took 2 weeks. I interviewed at Amazon (Ottawa, ON) in Dec 2020
Interview
Got to 2nd round, first round was take-home test very SQL based and very meticulous. Questions required a strong understanding of SQL and underlying processes regarding JOINS, analytic queries, processing order etc. Second round was technical call with Senior Engineer surrounding SQL, python (numpy, pandas etc.) and PySpark.
Interview questions [1]
Question 1
Based on a specific SQL error why do you think this error has occurred? How would you investigate? What would you do to fix it?
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
