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
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

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
Amazon logo
Amazon
Medium
Business Intelligence Engineer

Analyze Seller Compliance and Customer Purchase Patterns

SELLER_STATUS +-----------+------------+-----------+ | seller_id | date | status | +-----------+------------+-----------+ | 1 |2019-0...

Data Manipulation (SQL/Python)
5
0
18 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
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
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
PayPal logo
PayPal
Medium
Data Scientist

Describe Leading Without Authority in Data Management

Behavioral Interview: Leading Without Authority in Data Management You will be assessed on cultural fit and how you operate in ambiguous, messy data e...

Behavioral & Leadership
30
0
75 people solved
Jul 12, 2025
Amazon logo
Amazon
Medium
Business Intelligence Engineer

Identify Most Popular First-Watched Movie in Viewing History

MOVIE_VIEWS +------------+--------------------+------------+ | customer_id| title | date | +------------+--------------------+-----...

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

Determine Product Buyer Count and Interaction Percentage

interactions +-----------+----------+------------+----+------------+ | seller_id | buyer_id | product_id | li | create_date| +-----------+----------+-...

Data Manipulation (SQL/Python)
13
0
34 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
OneMain Financial logo
OneMain Financial
Medium
Data Scientist

Solve Python Challenges: Reverse String, Palindrome, Fibonacci, Unique List

Scenario Live coding round – four quick Python exercises Question Implement a function that reverses a string in-place. Write code that returns True i...

Coding & Algorithms
8
0
22 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

Identify Top 10 Users by Average Call Duration

video_calls | call_id | user_id | start_time | end_time | |---------|---------|----------------------|----------------------| | ...

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

Expected meetings in Room 1 after random assignment

Expected Meetings in Room 1 Conditional on Being Non-empty There are N rooms and k meetings. Each meeting independently chooses a room uniformly at ra...

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