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
Affirm logo
Affirm
Medium
Software Engineer

Implement and debug event filtering in Python

You are given a list of event dictionaries with keys: id (str), type (str), ts (int, seconds since epoch), payload (dict). Implement filter_events(eve...

Data Manipulation (SQL/Python)
1
0
5 people solved
Jul 15, 2025
TikTok logo
TikTok
Medium
Data Engineer

Debug a Hive insert query

Given a Hive table schema and an incoming table plus an INSERT/SELECT statement meant to inject data, identify why the query fails and provide step-by...

Data Manipulation (SQL/Python)
0
0
5 people solved
Jul 15, 2025
Pinterest logo
Pinterest
Medium
Data Scientist

Maximize Non-Overlapping Task Scheduling Efficiency

Scenario Job scheduler on a single machine wants to maximise throughput. Question Given tasks with [start, end) times, return the maximum number of no...

Coding & Algorithms
13
0
8 people solved
Jul 12, 2025
Pinterest logo
Pinterest
Medium
Data Scientist

Implement LRUCache with O(1) Operations and Thread Safety

Scenario High-traffic API needs constant-time eviction cache. Question Implement an LRUCache supporting get(key) and put(key,val) in O( 1). Describe ...

Coding & Algorithms
16
0
62 people solved
Jul 12, 2025
Google logo
Google
Medium
Data Scientist

Implement Sampling and Minimize Loss in Numerical Coding

Scenario Numerical coding challenges on sampling and loss minimization. Question a) Implement functions to sample from truncated normal distributions ...

Coding & Algorithms
24
0
91 people solved
Jul 12, 2025
Amazon logo
Amazon
Medium
Business Intelligence Engineer

Identify Unique Unordered City Pairs in Flight Log

FLIGHTS +----------------+---------------+ | departure_city | arrival_city | +----------------+---------------+ | NYC | LAX | | ...

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

Optimize Job Routing in Parallel Machine Scheduling

Scenario In the Production Factory game, jobs with varying processing times arrive and must be routed through two parallel machines to minimize total ...

Coding & Algorithms
23
0
44 people solved
Jul 12, 2025
Amazon logo
Amazon
Medium
Business Intelligence Engineer

Count Customers Buying Both 'Kindle' and 'Alexa'

ITEMS +---------+-----------+ | ITEM_ID | ITEM_NAME | +---------+-----------+ | 101 | Kindle | | 202 | Alexa | | 303 | Fire TV | ...

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

How to Design a Proportional Randomized Sampler?

Scenario Randomized promotion engine must pick an item proportional to its score, but scores have no upper bound. Question Design a sampler pick() tha...

Coding & Algorithms
21
0
52 people solved
Jul 12, 2025
Pinterest logo
Pinterest
Medium
Data Scientist

Implement DelayQueue with Idempotent Task Execution

Scenario Message broker offers DelayQueue where tasks execute at future timestamps, ensuring idempotency on duplicate IDs. Question Implement a delay ...

Coding & Algorithms
28
0
68 people solved
Jul 12, 2025
Pinterest logo
Pinterest
Medium
Data Scientist

Implement Binary Search for Policy Violation Logs

violations +--------+---------+---------------+ | pin_id | type | violation_date| +--------+---------+---------------+ | 0 | spam | 2022-01...

Data Manipulation (SQL/Python)
57
0
5 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
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
Amazon logo
Amazon
Medium
Business Intelligence Engineer

Identify Customers Purchasing Every Product in Catalog

X_PURCHASES +-------------+---------+ | customer_id | pro_key | +-------------+---------+ | 1 | A | | 1 | B | | 2 ...

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

Design Algorithm to Minimize Payments in Expense-Sharing App

Scenario Expense-sharing app needs to settle debts among friends after a trip. Question Given a list of transactions (payer, payee, amount), design an...

Coding & Algorithms
28
0
94 people solved
Jul 12, 2025
Google logo
Google
Medium
Data Scientist

Analyze User Flags and Review Outcomes for Moderation Prioritization

UserFlags +---------------+--------------+----------+---------+ | User_FirstName| User_LastName| Video_ID | Flag_ID | +---------------+--------------+...

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

Calculate Weekly, Monthly Watch Hours for Paid Users

video_view_logs +---------+----------+----------------+------------+------------+ | user_id | video_id | watched_seconds| watch_date | device_type| +-...

Data Manipulation (SQL/Python)
87
0
211 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
Amazon logo
Amazon
Medium
Business Intelligence Engineer

Calculate Rolling 7-Day Sum of Answers by Device

ANSWERS +------------+--------+---------+ | date | device | answers | +------------+--------+---------+ | 2019-01-01 | echo | 10 | | 2019...

Data Manipulation (SQL/Python)
11
0
41 people solved
Jul 12, 2025