Zomato Business Analyst Interview Exp

Zomato Business Analyst Interview Experience

Cracking the Zomato Business Analyst interview requires a mix of SQL mastery, product sense, and data-driven business thinking. Here’s a complete breakdown of how the interview rounds went

⸻

 Round 1: SQL + Data Analysis

Questions included:

• Find customers who ordered from the same restaurant more than 3 times in a month.

• Identify restaurants with increasing monthly revenue for the last 3 months.

• Write a query to find repeat customers whose average order value exceeds the city average.

• Calculate cancellation rate per city and identify top 3 cities with the worst rates.

• Find the restaurant with maximum new customers this quarter.

 

Bonus Challenge:

“If a restaurant’s orders suddenly dropped by 30%, how would you diagnose the issue using SQL and data analysis?”

⸻

 Round 2: Business Case Study

Prompt:
“Zomato Gold usage has fallen by 20% in the last quarter. How would you identify the reason and fix it?”

Key areas to focus on:

• Metrics: Renewal rate, ARPU, discount usage, and churn rate

• Strategies: A/B testing, customer segmentation, retention incentives

• Outcome: Clear linkage between business metrics and actionable insights

⸻

 

Round 3: Product & Metrics Round

• Define Zomato’s North Star Metric.

• What KPIs would you track for delivery partner efficiency?

• How would you measure the success of a new loyalty program?

• If average delivery time increases by 10%, what downstream metrics will get affected?

⸻

 

Round 4: Behavioral + Communication

• Describe a time when data contradicted your initial assumption.

• How do you simplify complex analyses for non-technical stakeholders?

• How do you deal with incomplete or inconsistent data during analysis?

⸻

 Round 5: Excel + Dashboarding

• Build a dashboard for daily orders, cancellations, and GMV trends.

• Show how delivery delays correlate with customer churn using Power BI or Tableau.

• Detect anomalies in datasets using pivot tables and calculated fields.

⸻

Key points

Strong fundamentals in SQL, structured thinking, and clear business reasoning made the difference.

⸻

 Preparation Focus:

. SQL (Joins, CTEs, Window Functions)
. Business metrics & case frameworks
. Visualization tools (Tableau, Power BI)
. Communication & storytelling with data