Google

Leading technology company specializing in search, cloud, and AI.

4 Rounds ~21 Days Very Hard

Start Mock Interview

The Interview Loop

Recruiter Screen (30 min)

Standard fit check, behavioral questions, and resume overview.

Technical Loop (3-4 Rounds)

Deep dive into domain knowledge, coding, and system design.

Interview Question Bank

All Roles Data Analyst 10 Data Engineer 10 Data Scientist 4 Product Manager 1 Software Engineer 1

All Topics SQL 10 Data Pipeline 5 Data Governance 3 Data Warehousing 3 Algorithms 3 Data Lake 3 BigQuery 3 System Design 3

Data Engineer • Coding • medium

Write a SQL query to find the second highest salary per department.

#Window Functions #SQL

Practice

Data Engineer • Coding • medium

Write a SQL query to compute a 7-day rolling average of daily sales.

#Window Functions #Analytics

Practice

Data Engineer • Coding • hard

Write a SQL query to find the longest streak of consecutive days a user has logged into Google Workspace. The input table has user_id and login_date.

#Window Functions #Gaps and Islands #CTEs

Practice

Data Engineer • Coding • medium

Write a SQL query to calculate the rolling 7-day average of daily video views per category on YouTube, ensuring days with zero views are still accounted for in the average.

#Window Functions #Aggregation #Rolling Averages

Practice

Data Engineer • Coding • medium

Write a SQL query to find the top 3 highest-grossing apps in each region, but only include regions that have at least 100 active apps.

#CTEs #Window Functions #Filtering

Practice

Data Engineer • Technical • medium

Explain the difference between OLAP and OLTP systems. When would you use each?

#OLAP #OLTP #Databases

Practice

Data Engineer • Technical • hard

How would you optimize a SQL query that is running slowly on a 1 billion row table?

#Query Optimization #Indexing

Practice

Data Engineer • Technical • medium

Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER().

#Window Functions #SQL

Practice

Data Engineer • Technical • medium

What is a materialized view? How does it differ from a regular view?

#Materialized Views #Performance

Practice

Data Engineer • Technical • medium

What are CTEs (Common Table Expressions) and how do they differ from subqueries?

#CTEs #SQL

Practice

Difficulty Radar

Based on recent AI-sourced data.

Meet Your Interviewers

The "Standard" Interviewer

Senior Engineer

Focuses on core competencies, system constraints, and clear communication.

Simulate

Unwritten Rules

Think Out Loud

Always explain your thought process before writing code or drawing architecture.

Practice Now