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

Design "Restaurants You May Know" Recommendation Algorithm

Design "Restaurants You May Know" Recommendation Algorithm A food-delivery app wants to launch a personalized home-page module called "Restaurants You...

Analytics & Experimentation
36
0
126 people solved
Jul 12, 2025
Meta logo
Meta
Medium
Data Scientist

Calculate Weekly Thread Engagement with Reactions in SQL

messages +------------+--------+----------+--------------+---------------------+ | message_id | sender | receiver | has_reaction | timestamp ...

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

Analyze Conversation Engagement and Reaction Usage Effectively

messages +-----------+--------+----------+--------------+---------------------+ | messageid | sender | receiver | has_reaction | timestamp |...

Data Manipulation (SQL/Python)
173
3
404 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
Pinterest logo
Pinterest
Medium
Data Scientist

Implement Function to Return First n Prime Numbers

Scenario Quick algorithm screen to gauge Python fluency. Question Implement a Python function that returns the first n prime numbers. Hints An optimiz...

Coding & Algorithms
10
0
38 people solved
Jul 12, 2025
Capital One logo
Capital One
Medium
Data Scientist

Determine Country with Most 'Sunny' Days

Weather +------------+------------+---------+ | country | date | weather | +------------+------------+---------+ | Spain | 2023-07-01 | ...

Data Manipulation (SQL/Python)
54
0
174 people solved
Jul 12, 2025
OneMain Financial logo
OneMain Financial
Medium
Data Scientist

Count, Return, Find, and Select in SQL Queries

orders +----------+--------------+------------+--------+ | order_id | customer_id | order_date | amount | +----------+--------------+------------+---...

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

Determine Most Frequent Product Color in Carts

Scenario Online store wants to know which color of product appears most frequently in customers’ carts. Question Implement a function getMaxColor(colo...

Coding & Algorithms
30
0
100 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
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
Amazon logo
Amazon
Medium
Business Intelligence Engineer

Identify Top-Buying Customers Daily with SQL Query

PRIME +-------------+------------+----------+ | Customer_ID | Start_Date | End_Date | +-------------+------------+----------+ | 1 | 2025-01-...

Data Manipulation (SQL/Python)
16
0
28 people solved
Jul 12, 2025