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

Optimize Station Sequence for Maximum Car Output in Simulation

Scenario The Car-Building mini-game lets you sequence chassis, engine, and paint stations with limited buffers. Question Describe a strategy to maximi...

Coding & Algorithms
10
0
32 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
Atlassian logo
Atlassian
Medium
Data Scientist

Implement Real-Time Rate Limiting for Web Service Requests

Scenario A web service must throttle traffic from clients; you need to decide in real-time whether each incoming request should be served or rejected ...

Coding & Algorithms
18
0
57 people solved
Jul 12, 2025
Meta logo
Meta
Hard
Data Scientist

Analyze Free Shuttle Impact on Employee Participation Rates

Analyze Free Shuttle Impact on Employee Participation Rates You have panel data for more than 1,000 company sites over time. Some sites adopt free shu...

Analytics & Experimentation
104
0
247 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
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
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 Recent Post Views and Reactions for Social Media

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

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

Compute Shop Visibility Rate Using SQL and Python

shop_events | event_id | shop_id | user_id | event_type | event_time | | 1 | 101 | 1001 | view | 2023-07-01 10:05:00 | | ...

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

Calculate Weekly Event Sums from Daily Counts

EVENT_LOG +------------+------+ | event_date | cnt | +------------+------+ | 2025-05-01 | 17 | | 2025-05-02 | 12 | | 2025-05-08 | 30 | +-------...

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

Calculate Average Session Length and Compare App Performance

user_sessions +---------+------------+------------+---------------------+---------------------+ | user_id | session_id | app | session_start ...

Data Manipulation (SQL/Python)
125
0
324 people solved
Jul 12, 2025
Meta logo
Meta
Hard
Data Scientist

Analyze Data to Boost Group Post Comment Rates

Analytics Plan to Increase Group Post Comment Coverage A social shopping platform wants to increase the percentage of group posts that receive at leas...

Analytics & Experimentation
69
0
176 people solved
Jul 12, 2025