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

Sample and Simulate Price Adjustments in R with dplyr

Products +----+-----------+-------+ | id | product | price | | 1 | phone | 500 | | 2 | tablet | 300 | | 3 | laptop | 1000 | | 4 |...

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

Estimate Successful Sign-ups from Super Bowl QR Code Ad

Estimate Successful Sign-ups from a Super Bowl QR Code Ad A cryptocurrency company airs a national Super Bowl commercial featuring a bouncing QR code....

Analytics & Experimentation
21
0
49 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
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
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
LinkedIn logo
LinkedIn
Medium
Data Scientist

Identify Top Contributors by Recent Post Count

posts +----+---------+---------------------+ | id | user_id | created_at | +----+---------+---------------------+ | 1 | 101 | 2023-09-01...

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

Analyze Recent Post Performance Using SQL Queries

INFO_STREAM_VIEWS +---------+-----------+--------------+----------+------------+ | post_id | viewer_id | relationship | duration | ds | +-----...

Data Manipulation (SQL/Python)
41
1
6 people solved
Jul 12, 2025
Meta logo
Meta
Easy
Data Scientist

Expected impressions per user under random assignment

Random Assignment of Ad Impressions Across Users In an A/B experiment, Y ad impressions are served uniformly at random across X distinct users. Each i...

Analytics & Experimentation
14
0
31 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

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

Evaluate Facebook's Restaurant Recommendations Feature Effectiveness

Experiment Design: Restaurant Recommendations in Facebook News Feed Facebook is considering restaurant recommendation units inside News Feed, such as ...

Analytics & Experimentation
12
0
36 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
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
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
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
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
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
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