Tech Interview Questions

Practice 9,031+ interview questions from top companies including Google, Meta, Amazon, and more. Filter by company, role, and category.

Popular Interview Questions

Machine Learning Engineer + Data Scientist + Software Engineer Interview Questions

Practice the exact questions companies are asking right now.

9.0k Questions 480 Companies08.05.2026
Showing 20 results
Role
Amazon logo
Amazon
Medium
Data Scientist

Analyze Top 10 Items' Revenue Contribution by Category

sales +----------+------------+---------+---------+------------+ | order_id | category | item_id | revenue | order_date | +----------+------------+-...

Data Manipulation (SQL/Python)
62
0
197 people solved
Aug 4, 2025
Amazon logo
Amazon
Medium
Data Scientist

Understand SQL: DELETE vs TRUNCATE, VIEW vs TABLE, CROSS JOIN

employees +----+--------+---------+ | id | name | dept_id | +----+--------+---------+ | 1 | Alice | 10 | | 2 | Bob | 20 | | 3 | Car...

Data Manipulation (SQL/Python)
77
0
139 people solved
Aug 4, 2025
Amazon logo
Amazon
Medium
Data Scientist

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

Data Manipulation (SQL/Python)
187
9
356 people solved
Aug 4, 2025
Amazon logo
Amazon
Medium
Data Scientist

Calculate Weekly, Monthly Hours Watched by Premium Users

watch_events +-----------+----------+----------------+-----------------------+----------------+ | user_id | video_id | watched_minutes| watched_at ...

Data Manipulation (SQL/Python)
0
0
4 people solved
Aug 4, 2025
Meta logo
Meta
Medium
Data Scientist

Analyze Ad CTR and Convert Transactions to USD

AdsImpressions +-----------+---------+------------+--------+-----------+ | user_id | ad_id | impressions| clicks | event_dt | +-----------+------...

Data Manipulation (SQL/Python)
126
0
500 people solved
Aug 4, 2025
Amazon logo
Amazon
Medium
Data Scientist

Select Top Customers Using Transaction Data Filters

transactions +----+---------+------------+--------+ | id | user_id | order_date | amount | +----+---------+------------+--------+ | 1 | 101 | 202...

Data Manipulation (SQL/Python)
249
1
746 people solved
Aug 4, 2025
Amazon logo
Amazon
Medium
Data Scientist

Analyze Monthly Prime vs Non-Prime Sales and Price Buckets

sales +-----------+------------+----------+-------+ | order_id | order_date | is_prime | price | +-----------+------------+----------+-------+ | 1001...

Data Manipulation (SQL/Python)
82
0
256 people solved
Aug 4, 2025
Amazon logo
Amazon
Medium
Data Scientist

Identify Key Metrics for Monitoring Shipment Defects

shipment +-------------+----------+------------+---------+---------+ | shipment_id | order_id | ship_date | carrier | status | +-------------+------...

Data Manipulation (SQL/Python)
0
0
7 people solved
Aug 4, 2025
TikTok logo
TikTok
Medium
Data Scientist

Analyze Posting Behavior by Cohort and Date

creator_post +------------+---------+------+ | post_date | user_id | post | +------------+---------+------+ | 2023-01-01 | 111 | 1 | | 2023-01...

Data Manipulation (SQL/Python)
0
0
4 people solved
Aug 4, 2025
Shopify logo
Shopify
Medium
Data Scientist

Analyze Pirate Theme Usage Growth Over Time

themes +----+--------------+-----------+ | id | name | is_pirate | +----+--------------+-----------+ | 1 | Pirate Red | true | | 2 | ...

Data Manipulation (SQL/Python)
1
0
4 people solved
Aug 4, 2025
Amazon logo
Amazon
Medium
Data Scientist

Resolve Team Conflicts and Deliver Beyond Project Scope

Resolve Team Conflicts and Deliver Beyond Project Scope Behavioral Case: Team-Based Data Science Collaboration, Scope, and Customer Interaction Instru...

Behavioral & Leadership
2
0
36 people solved
Aug 4, 2025
CloudTrucks logo
CloudTrucks
Medium
Data Scientist

Determine North-Star Metric for CloudTrucks Driver Platform

Determine North-Star Metric for CloudTrucks Driver Platform Product Analytics Case: North-Star Metric and Booking Funnel (Driver Platform) Context You...

Analytics & Experimentation
1
0
17 people solved
Aug 4, 2025
Capital One logo
Capital One
Medium
Data Scientist

Compute Customer Spend and Engineer Features for 2023

transactions +-----------+-------------+--------+------------+--------------+ | tran_id | customer_id | amount | tran_date | merchant_cat | +------...

Data Manipulation (SQL/Python)
117
0
539 people solved
Aug 4, 2025
Robinhood logo
Robinhood
Medium
Data Scientist

List Transactions During Active 'Gold' Membership Period

customer_profile +-------------+----------------+--------------------+-------------------+ | customer_id | membership_type| membership_start_date| mem...

Data Manipulation (SQL/Python)
70
0
188 people solved
Aug 4, 2025
Meta logo
Meta
Medium
Data Scientist

Calculate Shop Visibility Ranking in Search Results

shop_impressions +------------+---------+----------+--------+ | date | shop_id | position | clicks | +------------+---------+----------+--------...

Data Manipulation (SQL/Python)
1
0
6 people solved
Aug 4, 2025
Meta logo
Meta
Medium
Data Scientist

Identify 3-Person Call Cycles in Video-Calling App

Calls callerid | recipientid | ds | call_id | duration 1001 | 2001 | 2023-02-20| 555 | 180 2001 | 3001 | 2023-02-20| ...

Data Manipulation (SQL/Python)
0
0
5 people solved
Aug 4, 2025
Adobe logo
Adobe
Easy
Data Scientist

Describe Your Background and Alignment with This Role

Describe Your Background and Alignment with This Role Behavioral: Background Fit + Delivering Under Tight Timelines (STAR) Context You are in an onsit...

Behavioral & Leadership
8
0
59 people solved
Aug 4, 2025
Pinterest logo
Pinterest
Medium
Data Scientist

Calculate 95% Bootstrap Confidence Interval for Order Values

Scenario An e-commerce firm wants a 95% confidence interval for the average order value but only has a single historical sample of order amounts. Ques...

Coding & Algorithms
27
0
45 people solved
Aug 4, 2025
Shopify logo
Shopify
Medium
Data Scientist

Identify Pirate Themes Using Similarity Score Algorithm

Scenario Engineering wants an automated way to spot custom themes that are probably just pirate themes in disguise. Question Write Python that takes t...

Coding & Algorithms
68
0
101 people solved
Aug 4, 2025
Pinterest logo
Pinterest
Medium
Data Scientist

Find available reservation time slots

Problem You are building an API to show which time slots are available for booking at a restaurant. You are given: - The restaurant’s opening hours (p...

Coding & Algorithms
12
0
101 people solved
Aug 2, 2025