I applied online. The process took 5 weeks. I interviewed at Amazon
Interview
After a brief telephonic interview (simple SQL + 2 lps), I went to the onsite, which was 4 sessions of 60 minutes each.
The first one was only LPs with a technical manager.
The second one was with another DE, who asked me some LPs and then went to the technical part: providing a schema, I was asked to create a script from scratch for an ETL to provide certain data (I had to write a function for each step of the process). I wasn't expecting this question at all and did really bad here.
The third one was with the HM who asked some LPs.
The fourth one was with a sr.DE who asked me some LPs and a lot of technical stuff about databases. After that we went through some simple SQL and Python scripting but I didn't have enough time.
Interview questions [1]
Question 1
Should we apply normalization rules on a star schema?
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
