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

Solve Aptitude Test: Logical, Numerical, Verbal Reasoning

Scenario Pre-employment aptitude screen assessing logical, numerical and verbal reasoning within a strict time limit Question You have 15 minutes to s...

Coding & Algorithms
96
0
288 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

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

Analyze User Engagement Metrics for Video-Calling App

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

Data Manipulation (SQL/Python)
69
0
195 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
Citadel logo
Citadel
Medium
Data Scientist

Implement Infinite Fibonacci Generator Using Lazy Evaluation

Scenario Testing understanding of Python lazy evaluation and generators. Question Explain what lazy evaluation means in Python and implement a generat...

Coding & Algorithms
20
0
41 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