Amazon Data Scientist 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...
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...
Calculate Weekly, Monthly Watch Hours for Paid Users
video_view_logs +---------+----------+----------------+------------+------------+ | user_id | video_id | watched_seconds| watch_date | device_type| +-...
Design Incremental Load Process for Large Relational Table
orders_daily_load +------------+-----------+-------------+--------+ | load_date | order_id | customer_id | amount | +------------+-----------+------...
Explore Subscription Patterns and Status Transitions with SQL/Pandas
subscriptions +-----------------+---------+-------------+ | subscription_id | status | status_date | +-----------------+---------+-------------+ | 10...
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...
Identify Date with Highest Total kWh Consumption Using Pandas
meter_readings +----------+------------+---------------+---------+ | meter_id | timestamp | kwh_consumed | city | +----------+------------+------...
Create Country-Level Spend Report Using Pandas
users +---------+---------+ | user_id | country | +---------+---------+ | 1 | US | | 2 | CA | | 3 | US | +---------+-...
Analyze Monthly Prime vs Non-Prime Sales and Price Buckets
sales +-----------+------------+----------+-------+ | order_id | order_date | is_prime | price | +-----------+------------+----------+-------+ | 1001...
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...
Assess Candidate's Alignment with Amazon Leadership Principles
Behavioral Interview: Assess Alignment with Amazon Leadership Principles (Data Scientist, Technical Phone Screen) Scenario You are interviewing for a ...
Design A/B Test for New Amazon Recommendation Module
A/B Test Design: Home Page Recommendation Module Scenario Amazon plans to introduce a new product recommendation module on the home page and wants to ...