Amazon

Amazon

E-commerce and cloud computing giant with AWS, the world's leading cloud platform.

5 Rounds ~28 Days Very Hard
Start Mock Interview

The Interview Loop

Recruiter Screen (30 min)

Standard fit check, behavioral questions, and resume overview.

Technical Loop (3-4 Rounds)

Deep dive into domain knowledge, coding, and system design.

Interview Question Bank

Data Analyst • Coding • medium

What is a pivot table in SQL? How would you implement it without native PIVOT support?

#Pivot #Data Transformation
Practice
Data Analyst • Coding • hard

What is a funnel query? Write one for a 3-step user onboarding flow.

#Funnel Analysis
Practice
Data Analyst • Coding • medium

Explain window functions. Write a query using LAG() to compute day-over-day change.

#Window Functions
Practice
Data Analyst • Coding • hard

How would you detect anomalies in a daily revenue time series using SQL?

#Anomaly Detection #SQL
Practice
Data Analyst • Coding • hard

Write a SQL query to calculate the rolling 28-day average session duration per user.

#Rolling Average #Sessions
Practice
Data Analyst • Coding • hard

Write a SQL query to find customers who made purchases in both January and February but not March.

#Set Operations
Practice
Data Analyst • Coding • hard

How would you build a cohort analysis for user retention in SQL?

#Cohort Analysis #Retention
Practice
Data Analyst • Coding • medium

Write a SQL query to calculate month-over-month revenue growth.

#Revenue #Growth Analytics
Practice
Data Analyst • Technical • medium

How do you handle timezone conversions in SQL analytics?

#Timezones #Analytics
Practice
Data Analyst • Technical • easy

Explain the difference between a HAVING clause and a WHERE clause.

#SQL Basics
Practice
Data Engineer • Coding • hard

Write a SQL query to identify 'loyal' customers who have made at least one purchase in 3 consecutive months.

#Self Joins #Window Functions #Gaps and Islands
Practice
Data Engineer • Coding • medium

Write a SQL query to calculate the Year-over-Year (YoY) growth rate of total revenue for each product sub-category.

#Date Functions #CTEs #Math Operations
Practice
Data Engineer • Coding • medium

Write a SQL query to find the second highest salary per department.

#Window Functions #SQL
Practice
Data Engineer • Coding • medium

Write a SQL query to compute a 7-day rolling average of daily sales.

#Window Functions #Analytics
Practice
Data Engineer • Coding • medium

Write a SQL query to find the rolling 7-day average of daily sales per product category, given an 'orders' table with order_id, product_id, category_id, order_date, and order_amount.

#Window Functions #Time Series #Aggregations
Practice
Data Engineer • Technical • medium

Explain the difference between OLAP and OLTP systems. When would you use each?

#OLAP #OLTP #Databases
Practice
Data Engineer • Technical • hard

How would you optimize a SQL query that is running slowly on a 1 billion row table?

#Query Optimization #Indexing
Practice
Data Engineer • Technical • medium

Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER().

#Window Functions #SQL
Practice
Data Engineer • Technical • medium

What is a materialized view? How does it differ from a regular view?

#Materialized Views #Performance
Practice
Data Engineer • Technical • medium

What are CTEs (Common Table Expressions) and how do they differ from subqueries?

#CTEs #SQL
Practice
Data Scientist • Coding • medium

Write a query to identify duplicate records and deduplicate them.

#Deduplication #Data Quality
Practice
Data Scientist • Coding • hard

How would you write a funnel analysis query in SQL?

#Funnel #Analytics
Practice
Data Scientist • Coding • hard

Write a SQL query to calculate 30-day user retention.

#Retention #Analytics
Practice
Data Scientist • Coding • medium

Write a SQL query to find the top 3 best-selling products in each category for the last 30 days, considering only orders that were successfully delivered.

#Window Functions #Filtering #Joins
Practice
Data Scientist • Coding • hard

Write a SQL query to calculate the month-over-month retention rate of Amazon Prime members.

#Self Joins #Date Functions #Cohort Analysis
Practice
Data Scientist • Technical • easy

Explain the difference between INNER JOIN, LEFT JOIN, and CROSS JOIN.

#Joins #SQL
Practice

Difficulty Radar

Based on recent AI-sourced data.

Meet Your Interviewers

The "Standard" Interviewer

Senior Engineer

Focuses on core competencies, system constraints, and clear communication.

Simulate

Unwritten Rules

Think Out Loud

Always explain your thought process before writing code or drawing architecture.

Practice Now