Google Data Manipulation (SQL/Python) Interview Questions

Google Data Manipulation (SQL/Python) interview questions are a common hurdle across Google roles that work with product metrics, experimentation, and large datasets. What’s distinctive about Google interviews is the expectation that candidates can combine crisp SQL for set-based aggregation with pragmatic Python for row-level transformations or complex calculations. Interviewers evaluate correctness and clarity of thought, ability to reason about edge cases and NULLs, query performance intuition (joins, indexing, CTEs), and practical tradeoffs when moving work between SQL and Python. You should also expect live whiteboard or take-home exercises that mimic real data problems rather than abstract puzzles. Effective interview preparation focuses on deliberate practice: write and optimize queries on realistic schemas, translate SQL outputs into concise Python data-frame transformations, and time-box solutions while explaining assumptions. Practice explaining why you chose a window function versus a GROUP BY, or when to push calculations into SQL for performance. Prepare short narratives about past data work that highlight debugging, validation, and measurable impact. Ahead of the interview, review common pitfalls such as off-by-one time windows, incorrect NULL handling, and misinterpreted JOIN semantics so your solutions are both correct and production-minded.

17 Questions 1 Company05.18.2026
Showing 17 results
Role
Google logo
Google
Hard
Data Scientist Locked

Compute Company Suggestion Funnels

This question evaluates a candidate's ability to perform event-level funnel analysis including distinct aggregation, joins to a dimension table, time-...

Data Manipulation (SQL/Python)
3
0
20 people solved
May 18, 2026
Google logo
Google
Medium
Machine Learning Engineer

Implement a robust Python generator

Given a list of integers, write a Python generator that yields the integers from the list while handling edge cases such as None values, empty input, ...

Data Manipulation (SQL/Python)
9
0
96 people solved
Sep 6, 2025
Google logo
Google
Medium
Data Scientist

Calculate User Deviation from Team Average Messages

usage_stats +---------+---------+---------------+------------+ | user_id | team_id | messages_sent | date | +---------+---------+---------------...

Data Manipulation (SQL/Python)
100
0
284 people solved
Aug 4, 2025
Google logo
Google
Medium
Data Scientist

Find most co‑purchased product pairs in SQL

Given the schema and sample data below, write ANSI-SQL to return the top 5 unordered product pairs most frequently purchased together across distinct ...

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

Design a scalable video platform database

Design the relational database for a YouTube-like video company. Deliverables: 1) list the core tables with key columns, types, and constraints (users...

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

Compute violation rate and flag precision in SQL

You are analyzing a Trust & Safety product in BigQuery. Assume 'today' is 2025-09-01 (UTC). Define precise metrics and write SQL to compute them, bein...

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

Design Scalable Database and Analyze E-commerce Data

transactions +-----------+----------+------------+------------+ | user_id | order_id | product_id | order_time | +-----------+----------+-----------...

Data Manipulation (SQL/Python)
68
0
253 people solved
Jul 12, 2025
Google logo
Google
Medium
Data Scientist

Generate binomial matrix and column-normalize

Using Python with NumPy, generate a 100×100 matrix of Binomial(n = 10, p = 0.3) draws with a fixed random seed, then normalize each column so it sums ...

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

Analyze video flags and reviews with SQL

You are designing SQL queries for YouTube Trust & Safety. Use the schema and sample data below. Unless stated otherwise, treat a flag as reviewed if t...

Data Manipulation (SQL/Python)
28
2
244 people solved
Oct 13, 2025
Google logo
Google
Medium
Data Scientist

Write SQL/Python for messy event data

Using the schema and sample data below, write: (1) a single SQL query to compute daily metrics for the local date 2025-09-01 in America/Los_Angeles, a...

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

Add a conditional column in Python

Using pandas, add a derived column to a table based on multiple conditions with strict precedence and missing-value handling. Given the sample DataFra...

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

Compute monthly CRR with merges and gaps

You are given PostgreSQL tables user_profile(user_id, signup_ts, country, is_employee, is_test), user_events(user_id, event_ts, event_type, revenue, p...

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

Deduplicate events and rank products with SQL

You are given two tables. Schema: - events(event_id INT PRIMARY KEY, user_id INT, product_id INT, event_time TIMESTAMP, idempotency_key TEXT, amount_c...

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

Implement R dplyr simulation and left join

Using R and dplyr, run a simulation and a join. Data: prices item_id | price_usd 1 | 10.00 2 | 20.00 3 | 30.00 4 | 40.00 catalog item_id | category 1 ...

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

Calculate Top Countries' Gmail Usage and MoM Change

emails +----+---------+-----------+-----------+------------+ | id | user_id | country | provider | send_date | +----+---------+-----------+-------...

Data Manipulation (SQL/Python)
0
0
4 people solved
Aug 4, 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
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

Frequently Asked Questions

How difficult are Google Data Manipulation (SQL/Python) interview questions?
Questions in this area typically range from straightforward data-cleaning and basic joins to challenging, time‑constrained problems that combine SQL logic with Python data wrangling. Expect medium‑to‑hard difficulty depending on role and level: entry data roles focus on correct, efficient queries and Pandas usage, while senior roles probe query optimization, window functions, and scaling considerations under ambiguity. Interviewers evaluate correctness, clarity, edge‑case handling, and explanation of tradeoffs, not just a working query or script.
Where in Google’s interview process does Data Manipulation (SQL/Python) typically appear and for which roles?
Data manipulation tasks appear across screening stages: recruiter screens may confirm languages, take‑home or online coding screens include SQL pads or Python notebooks, and onsite or virtual technical interviews present paired programming or whiteboard query problems. This topic is central for Data Analyst, Product/Marketing Analytics, Data Scientist, and Analytics Engineer interviews, and also shows up as a focused module in some backend or ML infrastructure interviews when evaluating data pipelines. Prepare for both short timed snippets and longer, open‑ended questions that require translating a business question into code.
How should I structure my preparation timeline for Google Data Manipulation (SQL/Python) questions?
A compact effective timeline is four to six weeks: begin with fundamentals in week one to two (SQL joins, aggregations, basic Pandas operations), spend weeks three and four on intermediate topics (window functions, CTEs, groupby/merge edge cases, performance basics), and use the final one to two weeks for timed practice, past interview‑style prompts, and mock interviews. Mix active coding with short reviews of query plans and common pitfalls, then simulate interview conditions. Adjust pacing by experience level: novices need more fundamentals, experienced candidates should focus on optimization and explanation.
What key subtopics should I master within Data Manipulation (SQL/Python) for Google interviews?
Master SQL joins and set operations, aggregations, window functions, CTEs, filtering distinctions (WHERE vs HAVING), NULL semantics, and basic performance concepts like indexes and query plans. For Python, focus on Pandas: dataframe joins, groupby/agg patterns, vectorized operations, memory and dtype handling, datetime manipulation, and testing for missing or duplicate data. Also practice translating business questions into the minimal, correct data retrieval step and combining SQL to fetch raw slices with Python for advanced analytics when required.
What standout tips and common pitfalls should I watch for when answering these questions?
Start by clarifying the schema and assumptions, then outline your approach before coding. Use clear, maintainable queries (CTEs help) and explain edge cases, NULL handling, and complexity or performance tradeoffs. In Python, prefer vectorized operations and avoid in‑place chained assignments; always validate results on small examples. Common pitfalls include ignoring NULLs or duplicates, failing to justify GROUP BY logic, not considering index impacts, and delivering code without explaining testing or assumptions. Verbally communicate what you would change for larger datasets or production pipelines.

Explore more Google Data Manipulation (SQL/Python) interview questions

Real questions from candidate reports, grouped by role, topic and company.

By role
Other categories at Google
Data Manipulation (SQL/Python) questions at other companies
Browse all