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
Amazon logo
Amazon
Medium
Data Scientist

Design Incremental Load Process for Large Relational Table

orders_daily_load +------------+-----------+-------------+--------+ | load_date | order_id | customer_id | amount | +------------+-----------+------...

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

Analyze Hashtag Follow Behavior with SQL Queries

following_behavior +------------+---------+-----------+---------------+ | date | user_id | hashtag_id| hashtag_source| +------------+---------+-...

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

Automate Python Virtual Environment Setup on Linux Terminal

Scenario Shell script that automates Python virtual-environment setup on a Linux terminal during a tech interview Question Walk through the script lin...

Coding & Algorithms
104
0
321 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
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

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
Meta logo
Meta
Medium
Data Scientist

Calculate French User Engagement and U.S. Call Duration

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

Data Manipulation (SQL/Python)
79
0
377 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
Google logo
Google
Medium
Data Scientist

Remove Duplicates While Preserving Order in List

Scenario A data pipeline receives an unordered list of IDs containing duplicates; downstream components require a duplicate-free list while preserving...

Coding & Algorithms
15
1
54 people solved
Jul 12, 2025
Amazon logo
Amazon
Medium
Business Intelligence Engineer

Find Top Three Books by City in Recent Months

BOOK_SALES +------+--------+------------+------------+ | city | asin | sale_date | units_sold | +------+--------+------------+------------+ | NYC ...

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

Determine Facebook's Restaurant Recommendation Viability Using Data

Determine Facebook's Restaurant Recommendation Viability Using Data Facebook may launch a restaurant-recommendation product that helps people discover...

Analytics & Experimentation
6
0
28 people solved
Jul 12, 2025
TikTok logo
TikTok
Medium
Data Scientist

Compute Averages of Unique Numbers in Dictionary Lists

Scenario Python tech screen: given a dictionary mapping keys to numeric lists, e.g., {'a':[1,2,1],'b':[1,2,3]}, compute the average of each list after...

Coding & Algorithms
24
0
46 people solved
Jul 12, 2025
TikTok logo
TikTok
Medium
Data Scientist

Compute 7-Day Rolling Average of Unique Post Viewers

POST_VIEWS +---------+------------+---------+ | user_id | view_date | post_id | | 101 | 2023-08-01 | 10 | | 102 | 2023-08-01 | 11 |...

Data Manipulation (SQL/Python)
91
0
440 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
Hard
Data Scientist

Evaluate Factors Before Replacing Recommendation Model

Evaluate Factors Before Replacing a Recommendation Model A large ads platform has built a new recommendation or ranking model and plans to deprecate t...

Machine Learning
62
0
273 people solved
Jul 12, 2025
Yahoo logo
Yahoo
Medium
Data Scientist

Solve Data Structure Challenges with Python Algorithms

Scenario You are given coding challenges in Python to manipulate simple data structures. Question Remove duplicates from a list of integers while pres...

Coding & Algorithms
54
0
102 people solved
Jul 12, 2025