Tech Interview Questions

Practice 9,031+ interview questions from top companies including Google, Meta, Amazon, and more. Filter by company, role, and category.

Popular Interview Questions

Machine Learning Engineer + Data Scientist + Software Engineer Interview Questions

Practice the exact questions companies are asking right now.

9.0k Questions 486 Companies08.11.2026
Showing 20 results
Role
Meta logo
Meta
Medium
Data Scientist

Compute video-call SQL metrics with edge cases

Use 'today' = 2025-09-01. Assume UTC timestamps. Write SQL to answer both parts below and call out how your queries handle edge cases (duplicates, fai...

Data Manipulation (SQL/Python)
29
1
242 people solved
Oct 13, 2025
Meta logo
Meta
Medium
Data Scientist

Compute unconnected 60s posts and reactions averages

Given these tables and sample data, write SQL that answers both tasks below. Use today = 2025-09-01 and interpret "last/past 7 days" as the inclusive ...

Data Manipulation (SQL/Python)
1
0
11 people solved
Oct 13, 2025
Meta logo
Meta
Medium
Data Scientist

Write SQL for visibility, calls, and cohort activity

You have the following schema and toy data. Assume "today" = 2025-09-01. users(user_id INT, signup_date DATE) Sample: user_id | signup_date -------...

Data Manipulation (SQL/Python)
1
0
8 people solved
Oct 13, 2025
Meta logo
Meta
Hard
Data Scientist Locked

Choose KPIs for short-video recommendations

This question evaluates a data scientist's ability to define precise product metrics, set guardrails, design and power A/B tests, and apply weighted d...

Analytics & Experimentation
3
0
25 people solved
Oct 13, 2025
Meta logo
Meta
Medium
Data Scientist

Write SQL for retention, conversion, and churn

Assume today is 2025-09-01 (use the user's local day boundaries based on users.tz). Given the following schema and sample data, write SQL to: (a) Comp...

Data Manipulation (SQL/Python)
12
0
127 people solved
Oct 13, 2025
Medium
Data Scientist

Write SQL to analyze response accuracy and speed

You are given response-level data for an online assessment with sections verbal/design/analytics and verbal subtypes grammar/vocab/tense/other. Using ...

Data Manipulation (SQL/Python)
1
0
33 people solved
Oct 13, 2025
Coinbase logo
Coinbase
Medium
Data Scientist

Write SQL and Python for funnels/retention

Given the following schema and small samples, answer Parts A–C. Assume timestamps are UTC and "today" is 2025-09-01. Schema: users(id INT, country STR...

Data Manipulation (SQL/Python)
1
0
6 people solved
Oct 13, 2025
Instacart logo
Instacart
Medium
Data Scientist Locked

Diagnose 4% weekly revenue drop using history

This question evaluates time-series forecasting, anomaly detection, decomposition, and attribution skills within analytics and experimentation, focusi...

Analytics & Experimentation
4
0
41 people solved
Oct 13, 2025
Roblox logo
Roblox
Medium
Data Scientist

Match requests and accepts into friendships in SQL

Given two event tables, write a single SQL query (PostgreSQL) to output unique undirected friendships with the earliest valid friendship_date. Schema ...

Data Manipulation (SQL/Python)
0
0
8 people solved
Oct 13, 2025
CVS Health logo
CVS Health
Medium
Data Scientist

Create and query an e-commerce schema

PostgreSQL only. 1) Create these tables with appropriate types and constraints (choose minimal correct types): products(product_id PK, name NOT NULL, ...

Data Manipulation (SQL/Python)
4
0
66 people solved
Oct 13, 2025
Capital One logo
Capital One
Medium
Data Scientist

Write SQL to find top net-revenue products

Using the sample schema and data below, write a single SQL query that returns, for the last 7 days relative to today (use today = 2025-09-01, so the w...

Data Manipulation (SQL/Python)
5
0
68 people solved
Oct 13, 2025
Dropbox logo
Dropbox
Medium
Data Scientist Locked

Design enterprise file recommendations under ACLs

This question evaluates a Data Scientist's ability to design production-grade machine learning and recommender systems for enterprise file suggestions...

Machine Learning
1
0
28 people solved
Oct 13, 2025
Capital One logo
Capital One
Medium
Data Scientist

Audit flight data quality from metadata

You’re given an airline on‑time dataset and a one‑page “Metadata” slide that claims: flight_date (string, local time), dep_time/arr_time (HHMM local),...

Data Manipulation (SQL/Python)
0
0
6 people solved
Oct 13, 2025
Uber logo
Uber
Hard
Data Scientist Locked

Design station experiment with interference and rush-hour spillovers

This question evaluates a data scientist's competency in experimental design and causal inference under interference and non-stationarity, covering sk...

Analytics & Experimentation
12
0
98 people solved
Oct 13, 2025
Uber logo
Uber
Hard
Data Scientist Locked

Differentiate Type I vs II errors under costs

This question evaluates understanding of hypothesis testing (Type I/II errors), cost-sensitive decision theory, sample size calculation for proportion...

Statistics & Math
12
0
91 people solved
Oct 13, 2025
Uber logo
Uber
Medium
Data Scientist

Write SQL for active counts and YTD top driver

Given the following schema and sample data, write SQL to: (a) return the total count of active riders and active drivers on the platform; (b) return t...

Data Manipulation (SQL/Python)
1
0
11 people solved
Oct 13, 2025
Google logo
Google
Medium
Data Scientist

Implement anagram check and stable deduplication

Part A — Anagram checker: Write a function is_anagram(a: str, b: str, locale: str = 'en') -> bool that returns True iff a and b are anagrams under the...

Coding & Algorithms
4
0
49 people solved
Oct 13, 2025
Meta logo
Meta
Hard
Data Scientist Locked

Design and analyze end-to-end A/B test

This question evaluates experimentation design and analysis competencies for A/B testing, including metric selection, statistical interpretation, inte...

Analytics & Experimentation
3
0
27 people solved
Oct 13, 2025
DoorDash logo
DoorDash
Medium
Data Scientist

Model schema and query new-market readiness

Assume today is 2025-09-01. You are given (or can propose) a minimal schema to assess new-market readiness and early performance. Use the schema below...

Data Manipulation (SQL/Python)
1
0
12 people solved
Oct 13, 2025
CVS Health logo
CVS Health
Medium
Data Scientist

Compute age-band spend and YoY in Georgia

Using ANSI SQL only, answer the three parts below on the following schema and samples. Assume dates are YYYY-MM-DD, paid_amt can be negative (adjustme...

Data Manipulation (SQL/Python)
0
0
7 people solved
Oct 13, 2025