Amazon Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Retrieve First Active and Last Inactive Dates per User
Given a table activity that tracks user activities, write a SQL query to retrieve the first active date and last inactive date for each user. Table Sc...
Select Top Customers Using Transaction Data Filters
transactions +----+---------+------------+--------+ | id | user_id | order_date | amount | +----+---------+------------+--------+ | 1 | 101 | 202...
Generate Synthetic Clickstream Data with Python Function
Scenario The analytics team needs to generate synthetic click-stream records to test a new reporting pipeline before real traffic arrives. Question Wr...
Evaluate actions in Amazon simulation
Amazon Work Simulation: Purpose, Modules, and Design Decisions Context and Assumptions The Work Simulation is a timed, scenario-based assessment used ...
Identify Top Spenders and Segment Customers Using Python
orders +----------+---------+------------+----------+--------------+-------------------+ | order_id | cust_id | order_date | product | order_amount |...
Analyze User Engagement with SQL Queries
events +----------+---------+---------------------+ | event_id | user_id | event_time | +----------+---------+---------------------+ | 1 ...
Evaluate Cost, Time, Security, Flexibility for Training Options
Scenario Your company is rolling out an organization-wide employee training program. The platform must track completions, integrate with SSO/HRIS, and...
Evaluate Soft Skills Through Behavioral Interview Questions
Behavioral and Leadership (Data Scientist Onsite) Context You are interviewing for a Data Scientist role in an onsite Behavioral & Leadership round. P...
Choose Between JOIN, BLEND, and RELATIONSHIP in Tableau
Tableau Data Modeling, Filters, and Visual Design Scenario You are preparing a Tableau dashboard for marketing managers. The dashboard must support fa...
Understand SQL: DELETE vs TRUNCATE, VIEW vs TABLE, CROSS JOIN
employees +----+--------+---------+ | id | name | dept_id | +----+--------+---------+ | 1 | Alice | 10 | | 2 | Bob | 20 | | 3 | Car...
Design Incremental Load Process for Large Relational Table
orders_daily_load +------------+-----------+-------------+--------+ | load_date | order_id | customer_id | amount | +------------+-----------+------...
Calculate Weekly, Monthly Watch Hours for Paid Users
video_view_logs +---------+----------+----------------+------------+------------+ | user_id | video_id | watched_seconds| watch_date | device_type| +-...
Optimize Email Strategy for New Prime Video Series Launch
Scenario Designing, deploying, and evaluating ranking models and marketing emails for Prime Video. Question How would you approach sending marketing e...
Explore Subscription Patterns and Status Transitions with SQL/Pandas
subscriptions +-----------------+---------+-------------+ | subscription_id | status | status_date | +-----------------+---------+-------------+ | 10...
Compute minimum passes to collect numbers
Question You are given an array shelf of n distinct integers that is a permutation of 1…n. Starting with target = 1, you repeatedly scan shelf from le...
Identify Date with Highest Total kWh Consumption Using Pandas
meter_readings +----------+------------+---------------+---------+ | meter_id | timestamp | kwh_consumed | city | +----------+------------+------...
Analyze Monthly Prime vs Non-Prime Sales and Price Buckets
sales +-----------+------------+----------+-------+ | order_id | order_date | is_prime | price | +-----------+------------+----------+-------+ | 1001...
Create Country-Level Spend Report Using Pandas
users +---------+---------+ | user_id | country | +---------+---------+ | 1 | US | | 2 | CA | | 3 | US | +---------+-...
Identify SQL Joins and Correct Query Errors
Winner +----+-------+ | ID | Name | +----+-------+ | 1 | Alice | | 2 | Bob | | 3 | Carol | +----+-------+ Loser +----+-------+ | ID | Name | ...
Design an ML Model for Interview Recommendation Pipeline
Scenario You are designing and deploying an ML model that mirrors a real-world recommendation pipeline serving a large product catalog with strict lat...