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 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 • 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 • 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

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