Follow Pooja Jain & Ankita Gulati for more on Data Engineering
Google
Data Engineer
Interview
Experience
YOE - 5+
Ankita Gulati
Pooja Jain
Follow Pooja Jain & Ankita Gulati for more on Data Engineering
ROUND - 1
Coding
You have a machine with 4 buttons - 1st
button can increase the time by 60
minutes, 2nd button can increase the time
by 15 minutes, 3rd button can increase the
time by 5 minutes and 4th button can
increase the time by 1 minute.
As a input you will be given input
timestamp in the format HH:MM and
current timestamp will be displayed on
the machine,
Calculate the minimum number of key
presses required to get input time HH:MM
from current timestamp
Follow Pooja Jain & Ankita Gulati for more on Data Engineering
ROUND - 2
Coding
You will be given input timestamps in
the format HH:MM where 0<=H<=9,
0<=M<=9.
Write a code to find next minimum
timestamp value which can be
generated using same digits of
HH:MM
Follow-up: What is the time and space
complexity of your solution, and how
would you optimize it for edge cases
Follow Pooja Jain & Ankita Gulati for more on Data Engineering
ROUND - 3
Technical
Apache Spark related questions -
Fundamentals, OOM scenarios in
Spark and how to fix them, how to
optimize an Spark application,
Optimized joins in Spark
Solve SQL queries for the employee &
manager dataset
Coding question to find the frequency
of each character given in a string
Follow Pooja Jain & Ankita Gulati for more on Data Engineering
ROUND - 4
Application
Design & Domain
Knowledge
Design an Uber kind of application and
it’s Data Warehouse
Expectations:
Discuss microservices, data
ingestion pipelines, scalability,
reliability, and data
synchronization.
Lay out star or snowflake schemas
for the data warehouse with facts
(rides, payments) and dimensions
(users, drivers, time, location).
Explain ETL flows, real-time vs.
batch analytics, and table
partitioning strategies.
Follow Pooja Jain & Ankita Gulati for more on Data Engineering
ROUND - 5
System
Integration
Knowledge
Project deep dive discussion based
on my resume
Design real time data ingestion
pipeline which will consume data
from IoT device and after
processing data will be ingested in
the realtime in BigQuery
Follow Pooja Jain & Ankita Gulati for more on Data Engineering
ROUND - 6
Googliness
Behavioural and team fitment kind of
questions
Questions around Google’s leadership
principles
Assume you are working for a startup, the
CTO has left the company and now you
have been given that responsibility. What
kind of changes will you bring as per
Employee and Employer?
Let’s say you and your team member are
working on a project, your teammate was
assigned to come up with a design. You
have to review his design and provide your
inputs, somehow your teammate is very
rigid about his architecture design and not
listening to any feedback. Then how would
you handle this situation and discuss these
things with your manager?
Follow Pooja Jain & Ankita Gulati for more on Data Engineering
ROUND - 7
Hiring Manager
Discussion around my past experience
and projects, some resume based
questions
My experience of working on challenging
projects and how did I deal with those
challenges
Follow Pooja Jain & Ankita Gulati for more on Data Engineering
All the best for your upcoming
interviews!
2025
THANK
YOU
Stay tuned for more
data engineering
experiences
Ankita Gulati
Pooja Jain
