Amazon data interview guide
Operational and retail metrics — orders, sellers, delivery and top-N reports.
typical interview loop
- 1.Recruiter screen
- 2.Online assessment or phone screen with SQL
- 3.Loop: SQL, Python, Leadership Principles behavioral
- › Tie every answer back to a Leadership Principle.
- › Ranking and top-N per group come up constantly.
most-tested topics
JOIN
2
HAVING
2
functions
2
math
2
Window functions
1
LAG
1
Based on 7 reconstructed Amazon-style questions.
practice path
1 free · 6 Pro- 1Monthly revenue growthsqlHard
- 2Products above average pricesqlEasy
- 3Products with verified reviewssqlMedium
- 4Units sold per categorysqlEasy
- 5Verified-only ratingssqlMedium
- 6Weighted product ratingpythonMedium
- 7Weighted review scorepythonMedium
Unlock all 7 Amazon questions with Pro.
upgrade