I applied online. The process took 2 months. I interviewed at Amazon (Seattle, WA) in Oct 2025
Interview
Interview for L6 Role. First round was Hackerrank OA, pass/fail evaluation. It was 2 SQL coding questions with window functions like RANK/AVG and then 20 SQL multiple choice questions like 'which of the following has valid syntax'. Second Round was Phone Screen for 1hr, 1 leet code medium question on anagrams (25 min), bias and variance, mini-system design questions, 'how to design LLM', 'how to design a DB'. Final Loop was 5 interviews focusing on: 1) A/B testing and traditional ML modeling questions (regularization, bias/variance, overfitting etc) 2) Hiring manager conversation, mostly behavioral and resume deep dive 3) Science Application -- basically 3 Case Study problems somewhat hard on NLP/LLM since it was mentioned in the role 4) Bar Raiser Behavioral, make sure you know your big accomplishments and can answer 'what did you learn' 5) Data Manipulation Coding Interview -- all pandas they wouldn't let me use SQL. Do not waste your time hammering in leet codes for this one, practice common pandas functions for data science
Interview questions [1]
Question 1
Can you write an anomaly detection tool in pandas? How do you do rolling average in pandas?
There are three rounds in total. The process begins with a coding round, followed by the main interview loop, where you will meet the team and discuss technical skills, experience, and fit.
First round is fun, second round, which is also the final round involved 5 sessions, with different focus. For some sessions, not be able to present my story completely, time was tight, and interviewers were rushing.
Thrilled to have accepted the offer — the process was tougher than I expected. The first round was primarily technical, where I tackled an A/B testing design question that required detailed metrics and sample size calculations. Later, I faced a SQL query challenge focused on tracking customer purchases over consecutive months. Funny enough, I had spent quite some time on PracHub digging into similar case studies, which really helped me approach these problems confidently. The final round included behavioral questions, and I felt well-prepared overall.