I applied through an employee referral. I interviewed at Amazon (New York, NY) in Oct 2016
Interview
The first round is phone interview where the interviewer asked behavioural questions and then two SQL queries related to joins, date formats on two tables. Prepare mySQL queries well and the questions on glassdoor. The interviewer was really nice and helpful throughout in the process. Big data and analytics questions like how will you handle the data if multiplied may be asked.
Interview questions [1]
Question 1
SQL query to calculate orders for last week when the date when it was ordered is given.
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