Easy. Questions were mostly from sql - Basic to medium level Topics were Group By, joins, window functions etc. Basic python knowledge with libraries like pandas, numpy etc. They also ask about projects you have worked on.

The interview process includes a SQL test, an initial recruiter call, and a final five-round loop featuring technical questions and discussions focused on Amazon leadership principles with different team members.

Interviewed for Business Analyst role at Amazon and honestly the process felt exhausting and impersonal. The interviewers seemed far more focused on checking boxes against the 14 Leadership Principles than actually understanding the candidate or having a genuine conversation. Almost every question was another version of a STAR behavioral scenario, even when it barely related to the actual role. The process felt extremely rehearsed and rigid. There was little effort to make the candidate feel comfortable or valued, and it often felt like they had already decided the outcome before the interview even started. Technical and analytical depth barely mattered compared to how perfectly you could package stories into Amazon’s preferred format. If you don’t have polished STAR stories memorized for every possible situation, the process can feel unnecessarily difficult and draining. Overall, one of the most mentally exhausting interview experiences I’ve had.