Cracking the Zomato Data Analyst Interview
Zomato (headquartered in Gurugram) operates in a hyper-local, hyper-fast environment. As a Data Analyst here, you aren't just looking at generic sales data; you are analyzing real-time logistics (delivery partner routing), restaurant preparation times, and consumer craving patterns.
The Zomato Interview DNA
Zomato values speed, ownership, and deep consumer empathy. They want analysts who can look at a dataset and immediately identify the business problem (e.g., "Why are orders taking 5 minutes longer in Koramangala on Friday nights?").
Round 1: Online Assessment / Take-Home Assignment
You will usually be given a real-world dataset (e.g., anonymized order logs).
- The Task: Clean the data, find anomalies, and answer 3-4 specific business questions using SQL and Python.
- Focus: They check your coding efficiency and your ability to visualize the findings clearly.
Round 2: Technical Deep Dive (SQL)
This is a live coding round. Zomato databases are massive, so efficiency matters.
- Question: "Write a query to find the top 3 restaurants in each city that have the highest cancellation rate due to delayed food preparation."
- Focus: Window Functions (
ROW_NUMBER(),PARTITION BY), complexJOINs, and handlingNULLvalues (e.g., what if the cancellation reason is blank?).
Round 3: Business Analytics & Guesstimates
This round tests how you apply data to Zomato's specific business model.
- The Scenario: "Zomato Gold users are ordering 20% more frequently, but our overall margin has dropped by 2%. Walk me through your analysis."
- The Approach: Break down the unit economics. Are Gold users ordering low-margin items? Are delivery costs eating the margin because Gold users order from farther away?
- Guesstimate: "Estimate the number of Biryani orders placed on Zomato in Delhi on New Year's Eve."
Round 4: Product Analytics & A/B Testing
- Question: "We want to test a new feature that shows 'Trending Dishes' on the home screen. How would you design the A/B test and measure its success?"
- Focus: Define the primary metric (e.g., Conversion Rate) and guardrail metrics (e.g., App Load Time). Discuss statistical significance.
Round 5: Culture Fit & Founder Mentality
Zomato is known for its intense, fast-paced culture.
- "Tell me about a time you had to deliver a critical analysis under an impossible deadline."
- "What is one thing you think Swiggy does better than Zomato, and how would you fix it using data?"
Pro Tip: Understand the concept of "Unit Economics" in food delivery (Order Value - Discount - Delivery Cost - Restaurant Payout = Margin). If you can speak intelligently about unit economics during your interview, you will significantly impress the hiring manager.
