Tech Interview Questions

Practice 9,555+ 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

Analyze User Engagement Metrics for Video-Calling App

Calls +--------+-----------+------------+---------+----------+ | caller | recipient | ds | call_id | duration | +--------+-----------+--------...

Data Manipulation (SQL/Python)
69
0
195 people solved
Jul 12, 2025
Amazon logo
Amazon
Medium
Business Intelligence Engineer

Identify Frequent Actor-Director Collaborations in Film Database

FILMOGRAPHY +-------+---------+------------+ | actor | dir | date | +-------+---------+------------+ | Tom | Nolan | 2020-01-01 | | Tom ...

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

Clean and Analyze User Transactions with Python Functions

transactions +---------+---------------------+---------+ | user_id | trans_ts | amount | +---------+---------------------+---------+ | 11 ...

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

Calculate Regional Revenue and Identify Top Customers

Customers | customer_id | name | region | |-------------|-------|--------| | 1 | Alice | East | | 2 | Bob | West | | 3 ...

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

Decode and Explain Ambiguity in Compression Strings

Scenario Compression library that encodes an array as count-value pairs where value is one digit but count may be many digits. Question Implement deco...

Coding & Algorithms
14
0
38 people solved
Jul 12, 2025
Meta logo
Meta
Medium
Data Scientist

Analyze Recent User Engagement in Video Calls

calls +-----------+-----------+---------------------+---------+---------+ | caller_id | callee_id | call_start_timestamp| country | call_id | +-------...

Data Manipulation (SQL/Python)
83
0
259 people solved
Jul 12, 2025
Pinterest logo
Pinterest
Medium
Data Scientist

Design Efficient Multi-Level Access Control System

Scenario Multi-level access control lists (country → city) must be queried quickly. Question Design and implement a permission system where each geogr...

Coding & Algorithms
7
0
6 people solved
Jul 12, 2025
PayPal logo
PayPal
Medium
Data Scientist

Describe Leading Without Authority in Data Management

Behavioral Interview: Leading Without Authority in Data Management You will be assessed on cultural fit and how you operate in ambiguous, messy data e...

Behavioral & Leadership
30
0
75 people solved
Jul 12, 2025
Amazon logo
Amazon
Medium
Business Intelligence Engineer

Analyze Top Book Sales and Unique Customer Purchases

BOOK_TRANSACTION +---------------+------------+-------------+------+----------+ | MARKETPLACE_ID| TXN_DAY | CUSTOMER_ID | ASIN | QUANTITY | +------...

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

Implement Python Function for Statistical Test P-Values

Scenario You need a utility that calculates p-values for one-sided and two-sided statistical tests. Question Write a Python function compute_p_value(s...

Coding & Algorithms
14
0
47 people solved
Jul 12, 2025
Fannie Mae logo
Fannie Mae
Medium
Data Scientist

Understand SQL Aggregations and Joins: Key Differences Explained

Employees +----+--------+--------+---------+ | id | name | salary | dept_id | +----+--------+--------+---------+ | 1 | Alice | 70000 | 1 | ...

Data Manipulation (SQL/Python)
101
0
378 people solved
Jul 12, 2025
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
Pinterest logo
Pinterest
Medium
Data Scientist

Develop Auto-Complete System for Dish Suggestions

Scenario Search-as-you-type needs dish suggestions with popularity scores. Question Build an auto-complete system using the given (string, score) tupl...

Coding & Algorithms
5
0
25 people solved
Jul 12, 2025
Meta logo
Meta
Medium
Data Scientist

Identify Top 10 Users by Average Call Duration

video_calls | call_id | user_id | start_time | end_time | |---------|---------|----------------------|----------------------| | ...

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

Identify Top Discounts and Monitor Code Submissions

Products +------------+----------+-------+----------+ | product_id | category | price | discount | +------------+----------+-------+----------+ | 101 ...

Data Manipulation (SQL/Python)
69
0
269 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
Meta logo
Meta
Medium
Data Scientist

Determine Product Buyer Count and Interaction Percentage

interactions +-----------+----------+------------+----+------------+ | seller_id | buyer_id | product_id | li | create_date| +-----------+----------+-...

Data Manipulation (SQL/Python)
13
0
34 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