Zomato Data Analyst Interview Questions
The questions to prepare for a Zomato Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Find repeated Zomato order items using GROUP BY, HAVING, a CTE, and STRING_AGG.
ZomatoExplain how NULL values affect JOIN results, when LEFT JOIN is safer, and how to handle NULLs correctly in PostgreSQL.
ZomatoExplain how RANK() and DENSE_RANK() handle ties differently in ordered SQL results such as leaderboards.
ZomatoCalculate city-level Zomato order retention cohorts using three-table joins, CTEs, and window functions.
ZomatoUse CTEs, aggregations, and window functions to compare gender pay and find each department's second-highest salary.
MeeshoTests ability to define operational and quality metrics that reflect ecosystem performance.
ZomatoTests knowledge of LTV modeling and practical assumptions for subscription-like and repeat purchase behavior.
ZomatoTests understanding of unit economics drivers and how they translate into measurable metrics.
ZomatoTests estimation skills and ability to build reasonable assumptions for business-scale metrics.
ZomatoTests experimental design choices, metrics, and guardrails for retention impact measurement.
ZomatoSign up to see every question
Create a free account to unlock this list and practice real interview questions.