Top 26
Prep plan
Updated weekly · Last refresh Oct 17

Zomato Data Analyst Interview Questions

The questions to prepare for a Zomato Data Analyst interview. Questions from real interview reports rank first. Updated daily.

26questions
~5htotal time
Track your progressSign up free to work through all 26 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 11 questions · ~118 min
Write a Query for Repeated RowsMedium
Practice

Find repeated Zomato order items using GROUP BY, HAVING, a CTE, and STRING_AGG.

sqldata integrityZomato
Handling NULLs in JoinsMedium

Explain how NULL values affect JOIN results, when LEFT JOIN is safer, and how to handle NULLs correctly in PostgreSQL.

sqldata integritynull valuesZomato
RANK vs DENSE_RANK in LeaderboardsEasy

Explain how RANK() and DENSE_RANK() handle ties differently in ordered SQL results such as leaderboards.

Window FunctionsRankingData WranglingZomato
More SQL & Data Manipulation questions with a free account
2
Metrics5 questions · ~54 min
Investigate Zomato Revenue DropMedium

Diagnose why Zomato revenue fell month over month and identify the key drivers to fix.

root causeKPIdiagnostic processZomato
Delivery Partner Ecosystem Health MetricsMedium

Define the right KPIs to track Zomato delivery partner ecosystem health and spot early signs of supply or quality issues.

Metricsoperational healthKPI selectionZomato
Lifetime Value for Zomato UsersMedium

Tests knowledge of LTV modeling and practical assumptions for subscription-like and repeat purchase behavior.

lifetime valueZomato
More Metrics questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership8 questions · ~86 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~22 min
Estimate Orders in GurgaonMedium

Design an experiment-style estimate for Gurgaon Friday evening orders, including metric definition, MDE, sample size, and guardrails.

MDEEstimationPeekingZomato
A/B Test for Subscription RetentionHard

Design an A/B test for a new Zomato subscription tier, with retention as the primary metric and guardrails.

experiment designMDEuser retentionZomato
The finish line: interview-readyComplete all 26 questions to finish this plan.