Leading technology company specializing in search, cloud, and AI.
4 Rounds
~21 Days
Very Hard
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
Data Analyst
•
Behavioral
•
medium
Tell me about an analysis that changed a major business decision.
#Business Impact
#Influence
Data Analyst
•
Behavioral
•
medium
How do you handle a situation where a stakeholder challenges your analysis?
#Stakeholders
#Confidence
Data Analyst
•
Behavioral
•
medium
Describe a time you found an insight that was counterintuitive.
#Curiosity
Data Analyst
•
Behavioral
•
hard
Tell me about a time you had incomplete data but still needed to deliver analysis.
#Ambiguity
Data Analyst
•
Behavioral
•
medium
How do you prioritize analytical requests when multiple teams need you?
#Time Management
Data Analyst
•
Behavioral
•
medium
Describe a dashboard you built that was widely adopted. What made it successful?
#Visualization
Data Analyst
•
Behavioral
•
medium
Tell me about a time you discovered data quality issues mid-analysis. What did you do?
#Problem Solving
Data Analyst
•
Behavioral
•
easy
How do you ensure your analyses are reproducible?
#Reproducibility
Data Analyst
•
Coding
•
medium
Write a SQL query to calculate month-over-month revenue growth.
#Revenue
#Growth Analytics
Data Analyst
•
Coding
•
hard
How would you build a cohort analysis for user retention in SQL?
#Cohort Analysis
#Retention
Data Analyst
•
Coding
•
hard
Write a SQL query to find customers who made purchases in both January and February but not March.
#Set Operations
Data Analyst
•
Coding
•
hard
What is a funnel query? Write one for a 3-step user onboarding flow.
#Funnel Analysis
Data Analyst
•
Coding
•
medium
Explain window functions. Write a query using LAG() to compute day-over-day change.
#Window Functions
Data Analyst
•
Coding
•
hard
How would you detect anomalies in a daily revenue time series using SQL?
#Anomaly Detection
#SQL
Data Analyst
•
Coding
•
hard
Write a SQL query to calculate the rolling 28-day average session duration per user.
#Rolling Average
#Sessions
Data Analyst
•
Coding
•
medium
What is a pivot table in SQL? How would you implement it without native PIVOT support?
#Pivot
#Data Transformation
Data Analyst
•
Coding
•
medium
How would you use pandas to compute a 7-day rolling average of sessions?
#Pandas
#Time Series
Data Analyst
•
Coding
•
easy
Explain how groupby and agg work in pandas with an example.
#Pandas
#GroupBy
Data Analyst
•
Coding
•
medium
How would you merge two large DataFrames efficiently in pandas?
#Pandas
#Merging
Data Analyst
•
Coding
•
medium
Describe how to detect and handle outliers in a dataset using Python.
#Outliers
#Data Cleaning
Data Analyst
•
Coding
•
easy
Write Python code to load a CSV, clean missing values, and compute summary statistics.
#Data Cleaning
#Pandas
Data Analyst
•
Technical
•
easy
Explain the difference between a HAVING clause and a WHERE clause.
#SQL Basics
Data Analyst
•
Technical
•
medium
How do you handle timezone conversions in SQL analytics?
#Timezones
#Analytics
Data Analyst
•
Technical
•
hard
Daily Active Users dropped 15% yesterday. Walk me through how you'd investigate.
#Root Cause Analysis
#Metrics
Data Analyst
•
Technical
•
medium
What is customer lifetime value (LTV)? How would you calculate it?
#LTV
#Retention
Data Analyst
•
Technical
•
easy
Explain the difference between DAU, WAU, and MAU. Which is most useful and when?
#Engagement
#KPIs
Data Analyst
•
Technical
•
medium
How would you measure the success of a new feature launch?
#Feature Success
#Metrics
Data Analyst
•
Technical
•
easy
What is ARPU (Average Revenue Per User)? How do you segment ARPU analysis?
#ARPU
#Revenue
Data Analyst
•
Technical
•
hard
Explain the concept of attribution modeling. What are last-click vs multi-touch models?
#Marketing Analytics
Data Analyst
•
Technical
•
medium
How would you build a dashboard to monitor e-commerce funnel health?
#Visualization
#Funnel
Data Analyst
•
Technical
•
hard
What metrics would you use to measure the health of a marketplace?
#Marketplace
#Supply & Demand
Data Analyst
•
Technical
•
easy
What is net promoter score (NPS)? How do you analyse NPS trends?
#NPS
#Customer Satisfaction
Data Analyst
•
Technical
•
hard
How would you measure the impact of a pricing change on revenue?
#Pricing
#A/B Test
Data Analyst
•
Technical
•
hard
Explain how you'd set up an A/B test to validate a new checkout flow.
#A/B Testing
#Statistics
Data Analyst
•
Technical
•
hard
What sample size do you need for an A/B test? How do you calculate it?
#Sample Size
#Power
Data Analyst
•
Technical
•
hard
A/B test shows p=0.04, but the effect size is tiny. Would you ship?
#Practical Significance
#Decision Making
Data Analyst
•
Technical
•
medium
What is a novelty effect in experimentation? How do you account for it?
#Novelty Effect
#Bias
Data Analyst
•
Technical
•
hard
How do you handle multiple metrics in an A/B test (metric tradeoffs)?
#Multiple Metrics
#Tradeoffs
Data Analyst
•
Technical
•
medium
What makes a good data visualization? Walk me through your design principles.
#Design
#Communication
Data Analyst
•
Technical
•
medium
How would you explain statistical significance to a non-technical product manager?
#Storytelling
#Statistics
Data Analyst
•
Technical
•
easy
What tools do you use for dashboarding? Compare Tableau, Looker, and Metabase.
#Tableau
#Looker
Data Analyst
•
Technical
•
easy
How do you choose between a bar chart, line chart, and scatter plot?
#Charts
#Design
Data Analyst
•
Technical
•
medium
Describe your process for creating an executive-level analytics presentation.
#Executive Reporting
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.