At Zomato, data is the core engine that powers every delivery, search, and restaurant partnership. As a Business Analyst, you do not just generate dashboards; you own the insights that optimize a highly dynamic, real-time marketplace. Your work directly impacts millions of customers, hundreds of thousands of delivery partners, and restaurant ecosystems across the country.

You will step into a highly collaborative environment where you translate complex data into actionable operations. Whether you are optimizing order batching algorithms to reduce delivery times, designing search personalization strategies, or modeling restaurant commission structures, your analysis will shape the future of food delivery and quick commerce.

This role requires a unique blend of technical execution and strategic business thinking. Zomato values raw problem-solving capability, structural clarity, and a bias for action. If you enjoy navigating ambiguity, parsing massive datasets, and seeing the immediate real-world impact of your recommendations, this position offers an unmatched platform for growth.

The following questions are representative of the patterns and themes you will encounter during the Zomato hiring process. These are drawn from real interview experiences to help you understand the depth and style of evaluation rather than to serve as a list for rote memorization.

SQL & Database Querying

This category tests your ability to retrieve, manipulate, and analyze data from relational databases, which is a fundamental daily requirement for any analyst at Zomato.

• Write a query using window functions to find the top three most-ordered food items for each city on a monthly basis.
• Given a table of delivery partner logs, write a self-join query to calculate the average idle time between deliveries for each partner.

To succeed in the Zomato interview process, you must prepare to demonstrate a balance of technical execution and business strategy. Your interviewers are not just checking if you can write code; they want to see how you think and how you communicate your findings.

Ensure your preparation covers the following core evaluation criteria:

Technical & Analytical Rigor – You must demonstrate a strong command of relational databases and data manipulation. This includes writing complex, optimized SQL queries on the fly and using statistical methods to validate your business hypotheses.

Structured Problem-Solving – When presented with ambiguous business cases or guesstimates, you should not guess a final number. Interviewers evaluate your ability to break a massive, complex problem down into logical, manageable components using structured frameworks.

Product & Business Acumen – You need to understand how Zomato works as a business. This means being familiar with key marketplace dynamics, such as supply-demand balancing, delivery economics, customer retention strategies, and competitor positioning.

Cultural Alignment & Communication – Zomato operates at an incredibly fast pace. You should demonstrate a high degree of ownership, adaptability, comfort with constructive feedback, and the ability to articulate complex analytical findings to non-technical stakeholders clearly.

The Zomato interview process is designed to evaluate both your technical execution and your real-world business application. It typically moves quickly, often wrapping up multiple rounds within a short timeframe, especially during campus hiring drives or structured referral pipelines.

The process begins with an initial screening phase. This usually consists of a resume shortlisting round, which may sometimes be accompanied by a brief video introduction or video essay. This video round is highly conversational and creative, allowing you to introduce yourself and showcase your communication skills and personality.

Following the initial screen, you will face a rigorous Online Assessment (OA). This test is heavily focused on quantitative aptitude, logical reasoning, advanced probability, and SQL proficiency. Candidates who clear the online assessment are then invited to a series of technical and business interviews. These rounds focus on live SQL coding, business case studies, product metrics, and behavioral fit.

This visual timeline represents the standard path a candidate takes through the Zomato selection process. While the exact duration can vary based on the hiring channel, most candidates complete these stages sequentially over a few weeks. Dedicated preparation for each stage will help you maintain momentum and perform consistently.

Advanced SQL & Data Querying

SQL is the most heavily tested technical skill in the Zomato interview process. You must be prepared to write clean, syntactically correct queries under time pressure while explaining your logic out loud to your interviewer.

Be ready to go over:

• Multi-table Joins – Understanding how to combine datasets using inner, left, right, full outer, and self-joins, particularly when handling null values.
• Window Functions – Utilizing RANK(), DENSE_RANK(), ROW_NUMBER(), LEAD(), and LAG() to analyze sequential user behavior and order trends.
• Aggregations & Grouping – Implementing complex group-by operations, filtering aggregated data with HAVING, and calculating running totals.
• Advanced concepts (less common) – Common Table Expressions (CTEs), subqueries, index optimization, and identifying syntax bugs in pre-written queries.

Example questions or scenarios:

• "Write a query to find the second-highest order value placed by a customer in each city without using the LIMIT clause."
• "Given a table of order timestamps, write a query to calculate the average time difference between consecutive orders for every unique customer."
• "How would you optimize a query that is running slowly because it joins a massive transaction table with a smaller restaurant metadata table?"

Product Case Studies & Guesstimates

At Zomato, business analysts are expected to solve real-world operational puzzles. These rounds evaluate your ability to apply structured frameworks to open-ended business problems.

Be ready to go over:

• Order Batching & Dispatch – Balancing delivery partner utilization, customer wait times, and food quality during peak hours.
• Market Sizing – Estimating demand, order volumes, or revenue potential for new product launches or geographic regions.
• Unit Economics – Understanding how delivery fees, commissions, discounts, and partner payouts interact to determine transaction profitability.
• Advanced concepts (less common) – Geofencing optimization, driver routing efficiency, and dynamic surge pricing models.

Example questions or scenarios:

• "How would you structure a case study to determine whether Zomato should lower its delivery radius in a specific neighborhood to improve delivery times?"
• "Estimate the total daily revenue generated by Zomato Gold memberships in a major metropolitan city."
• "A restaurant partner wants to increase its average order value. What data points would you analyze, and what strategies would you propose?"

Root Cause Analysis (RCA) & Product Sense

When metrics fluctuate, a Business Analyst must quickly identify the underlying cause. This area tests your diagnostic skills, metric definition, and product intuition.

Be ready to go over:

• Metric Deconstruction – Breaking down high-level business metrics (like Gross Order Value) into actionable input metrics (like search-to-cart conversion, active users, and average order value).
• Hypothesis Testing – Formulating and systematically testing potential reasons for a metric change using historical data.
• Search & Discovery Optimization – Analyzing how users interact with the app search, filters, and restaurant recommendation carousels.

Example questions or scenarios:

• "If the customer conversion rate on the restaurant menu page drops by 8% over a weekend, how would you investigate the cause?"
• "What metrics would you design to measure the success and user engagement of a new 'Healthy Food' filter on the home screen?"
• "How would you determine if a decline in repeat orders is caused by poor delivery experiences or restaurant quality issues?"