Tech Interview Questions

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

Popular Interview Questions

Interview Questions

Practice the exact questions companies are asking right now.

9.6k Questions 505 Companies08.05.2026
Showing 20 results
Role
Meta logo
Meta
Medium
Data Scientist

Calculate Response Rate and Compare User Survey Ratings

USERS user_id | signup_date 10 | 2024-03-20 11 | 2024-04-01 12 | 2024-04-05 ​ SURVEYS survey_id | user_id | sent_at 1 | 10 ...

Data Manipulation (SQL/Python)
197
2
691 people solved
Jul 12, 2025
Amazon logo
Amazon
Medium
Data Scientist

Identify Date with Highest Total kWh Consumption Using Pandas

meter_readings +----------+------------+---------------+---------+ | meter_id | timestamp | kwh_consumed | city | +----------+------------+------...

Data Manipulation (SQL/Python)
63
0
5 people solved
Jul 12, 2025
Meta logo
Meta
Medium
Data Scientist

Expected meetings in Room 1 after random assignment

Expected Meetings in Room 1 Conditional on Being Non-empty There are N rooms and k meetings. Each meeting independently chooses a room uniformly at ra...

Analytics & Experimentation
12
0
32 people solved
Jul 12, 2025
Meta logo
Meta
Hard
Data Scientist

Determine Demand for WhatsApp Group Video-Calls

Determine Demand for WhatsApp Group Video Calls WhatsApp is considering launching group video calls. Assume the feature does not currently exist, but ...

Analytics & Experimentation
70
0
200 people solved
Jul 12, 2025
Amazon logo
Amazon
Medium
Data Scientist

Calculate 7-Day Rolling Average for Energy Consumption

Scenario Hiring manager wants a quick coding exercise to verify programming fluency. Question Write a Python function that takes a list of daily energ...

Coding & Algorithms
39
0
87 people solved
Jul 12, 2025
TikTok logo
TikTok
Medium
Data Scientist

Analyze and Clean European Ecommerce Sales Data

sales +----------+-------------+------------+---------+---------+----------------+ | order_id | customer_id | order_date | country | revenue | product...

Data Manipulation (SQL/Python)
51
0
94 people solved
Jul 12, 2025
Roblox logo
Roblox
Medium
Data Scientist

Analyze Recent Orders Dataset with Python/pandas

orders | order_id | user_id | price | created_at | |----------|---------|-------|------------| | 1 | 101 | 20.5 | 2024-01-01 | | 2 ...

Data Manipulation (SQL/Python)
39
0
6 people solved
Jul 12, 2025
Roblox logo
Roblox
Medium
Data Scientist

Generate Friendship List with Acceptance Dates Using Pandas

friend_events | requester_id | accepter_id | request_date | accept_date | |--------------|-------------|--------------|-------------| | 1 |...

Data Manipulation (SQL/Python)
56
0
5 people solved
Jul 12, 2025
Uber logo
Uber
Medium
Data Scientist

Analyze User Purchase Behavior in Online Marketplace Data

user_events +----------+------------+---------------------+-------------+ | user_id | event_type | event_timestamp | product_id | +----------+--...

Data Manipulation (SQL/Python)
63
1
5 people solved
Jul 12, 2025
Pinterest logo
Pinterest
Medium
Data Scientist

Clean and Aggregate Transactions for Finance Dashboard

transactions id | user_id | amount | timestamp | category 1 | 1001 | 19.99 | 2023-01-01 09:00:00 | grocery 2 | 1001 | 5.50 | 2023...

Data Manipulation (SQL/Python)
77
0
2 people solved
Jul 12, 2025
Coinbase logo
Coinbase
Medium
Data Scientist

Calculate Adoption and Transaction Rates, Identify Cross-Region Sales

user_txn +---------+-------------+------------+---------------+------------------+---------------------+ | user_id | user_region | adopted_at | transa...

Data Manipulation (SQL/Python)
65
0
288 people solved
Jul 12, 2025
Capital One logo
Capital One
Medium
Data Scientist

Explain Python Virtual Environment Setup and Function Analysis

Scenario Technical screen where candidate and interviewer jointly walk through Python code snippets used in a data-science repository. Question Show h...

Coding & Algorithms
57
0
9 people solved
Jul 12, 2025
Amazon logo
Amazon
Medium
Data Scientist

Consolidate and Rank Global Salaries in USD

employees_us +---------+----------+--------+---------+ | emp_id | name | salary | country | +---------+----------+--------+---------+ | 1 |...

Data Manipulation (SQL/Python)
49
0
8 people solved
Jul 12, 2025
Snapchat logo
Snapchat
Medium
Data Scientist

Monitor Friend-Request System for Quality and Abuse

Friendship +--------------+-------------+---------------------+---------------------+ | requester_id | approver_id | request_ts | approval_ts...

Data Manipulation (SQL/Python)
111
1
350 people solved
Jul 12, 2025
Citadel logo
Citadel
Medium
Data Scientist

Implement Infinite Fibonacci Generator Using Lazy Evaluation

Scenario Testing understanding of Python lazy evaluation and generators. Question Explain what lazy evaluation means in Python and implement a generat...

Coding & Algorithms
20
0
41 people solved
Jul 12, 2025
Meta logo
Meta
Medium
Data Scientist

Design SQL Query for Shop Visibility and User Activity Metrics

SHOP_VISIBILITY +----------+---------+------------+------------+-------------+--------------+ | user_id | shop_id | event_date | is_visible | signup_...

Data Manipulation (SQL/Python)
78
0
180 people solved
Jul 12, 2025
Amazon logo
Amazon
Medium
Data Scientist

Explore Subscription Patterns and Status Transitions with SQL/Pandas

subscriptions +-----------------+---------+-------------+ | subscription_id | status | status_date | +-----------------+---------+-------------+ | 10...

Data Manipulation (SQL/Python)
67
0
7 people solved
Jul 12, 2025
Amazon logo
Amazon
Medium
Data Scientist

Identify Top Spenders and Segment Customers Using Python

orders +----------+---------+------------+----------+--------------+-------------------+ | order_id | cust_id | order_date | product | order_amount |...

Data Manipulation (SQL/Python)
76
0
10 people solved
Jul 12, 2025
Meta logo
Meta
Medium
Data Scientist

Calculate Weekly CTR and Campaign-Specific CTR in SQL

AdEvents ad_id | campaign_id | event | view_id | event_date 1 | 10 | impression | 123 | 2023-11-07 1 | 10 | cli...

Data Manipulation (SQL/Python)
66
2
244 people solved
Jul 12, 2025
Meta logo
Meta
Hard
Data Scientist

Impact of parents joining Facebook on teen engagement

Parental Presence and Teen Engagement on Facebook Facebook's teen audience overlaps increasingly with parents, who may friend their children, comment ...

Analytics & Experimentation
66
1
133 people solved
Jul 12, 2025