Amazon Data Analyst Interview Guide

The process was pretty straightforward overall, but it started with an online assessment that set the tone. The OA had SQL questions, some multiple-choice questions, and one DSA problem. The SQL part was the main focus, and the coding question was more about basic Python syntax than anything deep. A few weeks later, I moved on to a live round that was one LeetCode medium question plus about 15 minutes of behavioral questions. The coding problem I got was Max Consecutive Ones III, so it was definitely manageable if you were comfortable with sliding window style problems.

The technical interviews themselves were mostly SQL-heavy. I was asked things like the order of execution of SQL commands such as select, from, where, and group by, and I also had to explain the differences between the three types of joins. Other questions stayed at a basic to medium level around joins, group by, NULL values, window functions, and general SQL theory. There were also some resume-based questions and a few questions about projects I had worked on, plus basic Python knowledge with pandas and numpy. One part that stood out was the work-style assessment, where they asked me to sort activities for a workday based on priority, importance, duration, and what someone had just told me to do. The personality-style section was more about picking traits on a spectrum. Overall it felt easy to moderate, with the main challenge being staying sharp on SQL fundamentals rather than solving anything tricky. I didn’t get the offer in the end, so I’d say the best prep is to drill SQL order of execution, joins, group by, NULL handling, and a few common window function patterns, then make sure you can talk through your projects clearly.