Free tool · no sign-up · 3 interview rounds
Generate AI-powered Zomato interview questions for all 3 rounds. Process: Online Coding → Technical × 2 → Cultural Fit.
From our curated bank of 10 Zomato-specific questions. The generator produces fresh AI-tailored questions each run.
What does Zomato's data platform look like and what kind of data roles do they hire for?
Tip: Zomato hires Data Analysts, Data Engineers, and ML Engineers. Their data platform processes order data, restaurant ratings, search clicks, and delivery telemetry. Roles require SQL proficiency, Python, and familiarity with Spark or Kafka. Analytics interviews include case studies on restaurant churn or user cohort analysis.
Write a SQL query to find restaurants with a rating drop of more than 0.5 compared to the previous month.
Tip: Use LAG() window function: LAG(avg_rating, 1) OVER (PARTITION BY restaurant_id ORDER BY month). Filter where current_month_rating - lag_rating < -0.5. Zomato analytics rounds are SQL-heavy — window functions appear in almost every interview.
How would you design Zomato's restaurant discovery and ranking algorithm?
Tip: Ranking signals: distance, rating (Bayesian average, not raw), delivery time, cuisine preference (personalised), restaurant freshness (new listings), sponsored listings. Serving: pre-compute scores per geo-cell per user-segment, refresh every 30 min. Real-time: adjust for current wait time and weather.
Explain the difference between OLTP and OLAP databases. Which does Zomato need for real-time orders vs analytics?
Tip: OLTP (Online Transaction Processing): many small reads/writes, row-oriented, MySQL/Postgres — for live order state. OLAP (Online Analytical Processing): large aggregations, column-oriented, Redshift/BigQuery/ClickHouse — for analytics. Zomato runs both: OLTP for operations, OLAP warehouse for business intelligence.
Write a Python function to calculate the rolling 7-day average for a time series of daily orders.
Tip: Use pandas: df["orders"].rolling(7).mean(). From scratch: sliding window with a deque, sum the last 7 values, divide by min(window_size, i+1). Zomato DA interviews test pandas fluency — also know resample() for time-based aggregation.
Practise questions for each stage to maximise your preparation.
Upload your resume and get scored on technical depth, communication, structure, confidence, and relevance — the same criteria Zomato panels use.