I applied online. The process took 4 days. I interviewed at Amazon (Barcelona) in Jul 2022
Interview
Data Engineer for Global Services division mainly for the products warehouse services. DE was expected to work with a team of few engineers to migrate from legacy software (microsoft mysql) to AWS. There were no devops or backend engineers so DEs where expected to create the entire pipeline from creating an EM2 VM all the way to storing data in redshift for BI teams. No agile methodologies where in place, tasks came in ad-hoc.
Interview questions [1]
Question 1
Did first interview directly with a DE working in the team. He asked me questions about my background, then some scripted questions like "how many years have you worked with SQL". Then he asked some easy data modeling questions like "what is a primary key, and how it differs from a unique key". Then we went to a quick LC type live coding. Was asked 1 SQL medium and 1 python easy. SQL medium required 2 subqueries and a window function. Python question was how to reverse a string. Finally, he left me some 15 mins to ask some questions.
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