Skip to content

Zomato Business Analytics Interview Questions & Answers

Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.

About Zomato hiring for Business Analytics roles

Zomato is an Indian food delivery and restaurant discovery platform, operating under the listed parent Eternal Ltd alongside Blinkit quick commerce and District. Its tech and analytics teams work on delivery logistics, restaurant listings, ads and customer experience. It hires for software engineers, SDETs, product and business analysts, and data scientists.

For Business Analytics roles, this Zomato practice set focuses most on Case Studies and Guesstimates (10), Process Modelling and BPMN (5), Requirements and Agile (5), UAT and BA Documentation (5). It has 30 medium, 10 hard questions, so you can start easy and work up to the harder ones.

Company type
E-commerce & consumer tech
Headquarters
Gurugram, India
Main India offices
Gurugram

Zomato Business Analytics interview process

  1. Online assessment or assignment
  2. Technical or case round
  3. Hiring manager round
  4. Culture fit round

Typical pattern based on public candidate experiences. Rounds vary by role, team and year.

Solved for ZomatoStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
01

Explain Porter's Five Forces.

Save to ▾
Show answer
A model assessing industry attractiveness through supplier power, buyer power, threat of new entrants, threat of substitutes and rivalry among competitors.
02

Write a DAX measure for the product return rate that avoids divide-by-zero errors.

Save to ▾
Show answer
Return Rate % = VAR ReturnedQty = SUM ( Returns[Quantity] ) VAR SoldQty = SUM ( Sales[Quantity] ) RETURN DIVIDE ( ReturnedQty, SoldQty, 0 ) // DIVIDE returns the third argument (0) when SoldQty is zero or blank. // Format the measure as a percentage in the model.
03

Explain exclusive, parallel and inclusive gateways in BPMN.

Save to ▾
Show answer
An exclusive gateway (diamond with X) sends the flow down exactly one path based on a condition, for example approved or rejected. A parallel gateway (diamond with +) splits into all paths at once and, when joining, waits for every path to finish. An inclusive gateway (diamond with O) activates one or more paths whose conditions are true and joins only those that were activated. Choosing the wrong one causes deadlocks or duplicated work in automated processes.
04

Guesstimate: what is the annual revenue of one multiplex screen in a large Indian city?

Save to ▾
Show answer
Assume 5 shows a day and 200 seats with 30 percent average occupancy, giving 300 tickets a day. At an average ticket of 250 rupees, ticket revenue is 75,000 rupees a day. Food and beverage adds about 40 percent of ticket revenue, around 30,000, and screen ads maybe 5,000. That is about 1.1 lakh a day, or around 4 crore a year. Weekends and blockbuster releases push occupancy higher.
05

A bank's mobile app logins increased, but digital transactions fell. What could explain this?

Save to ▾
Show answer
Users are coming but not completing transactions, so look at the gap. Possible causes: a release that broke a payment flow, new security steps like extra OTPs adding friction, logins driven by balance checks or offers, or transactions shifting to another channel. Compare the funnel from login to transaction by app version and device, check failure and error rates, and review support complaints before recommending fixes.
06

Describe a time you explained a complex technical topic to a non-technical audience.

Save to ▾
Show answer
Situation: operations managers did not trust a new demand forecast that drove staffing. Task: explain it so they would use it. Action: I avoided model terms and showed how it used last year's same week, recent trend and festival calendar, with a chart of past forecasts against actuals. I compared the forecast range to a weather forecast. Result: managers started using it for rosters and gave feedback that improved it further.
07

Guesstimate: how many cars are sold in India every year?

Save to ▾
Show answer
Structure it: households × car-owning share ÷ replacement cycle + first-time buyers + commercial fleet. State each assumption clearly and sanity-check the final number.
08

What are acceptance criteria?

Save to ▾
Show answer
Clear, testable conditions a story must meet to be accepted, often written as Given-When-Then scenarios.
09

Tell me about a time you solved an ambiguous problem with limited data.

Save to ▾
Show answer
Situation: my manager asked why customer complaints were rising, but complaints were stored as free text with no categories. Task: give an answer within a week. Action: I sampled 300 complaints, created categories, tagged them manually and used keyword rules in Excel to classify the rest, then validated with the support lead. Result: late refunds were 40 percent of complaints, the refund process was fixed, and categorised tagging was added to the support tool.
10

A business tester raises a defect, and the developer closes it as 'works as designed'. How do you resolve it?

Save to ▾
Show answer
Go back to the requirement and acceptance criteria. If the system matches the agreed requirement, the developer is right, and the business need is a change request. If the requirement is unclear or the design misread it, it is a defect, and the requirement wording should be fixed. Discuss it in triage with both parties, using examples. Either way, close the loop with the tester so they understand the outcome and keep trusting the process.
11

What are the 4 Ps of marketing?

Save to ▾
Show answer
Product, Price, Place and Promotion, the levers a business uses to bring an offering to market.
12

A release passed all system testing, but business users reject it during UAT. What went wrong and what do you do?

Save to ▾
Show answer
The team built what was written, but not what users needed, which points to gaps in elicitation, missing real-world scenarios or users not involved early. Capture each rejection and classify it as a defect, a missed requirement or a new request. Prioritise blockers with the product owner and agree on a fix plan and date. Going forward, involve users in demos every sprint and base UAT scenarios on real workflows.
13

Write a SQL query for a 7-day rolling average of daily revenue.

Save to ▾
Show answer
WITH daily AS ( SELECT order_date, SUM(amount) AS revenue FROM orders GROUP BY order_date ) SELECT order_date, revenue, AVG(revenue) OVER (ORDER BY order_date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS rolling_7d FROM daily ORDER BY order_date; -- fill missing dates from a calendar table first, or gaps skew the average
14

Guesstimate: how many smartphones are sold in India each year?

Save to ▾
Show answer
Use a replacement plus new-buyer approach. India has about 144 crore people; assume around 60 crore active smartphone users. If people replace phones every 4 years on average, replacements are about 15 crore a year. Add first-time buyers, say 2 to 3 percent of the remaining adult population, roughly 1.5 crore. The estimate is about 16 to 17 crore phones a year, which is close to reported industry numbers of around 15 crore.
15

A food delivery company's orders fell 15%. How do you investigate?

Save to ▾
Show answer
Check data accuracy, then segment by city, restaurant, time and user type; look at supply, delivery time, pricing, competitors and seasonality before proposing fixes.
16

UAT starts tomorrow, but the business has not nominated any testers. What do you do?

Save to ▾
Show answer
Escalate immediately to the business sponsor with the impact: each day without testers delays sign-off and go-live. Ask for named testers with protected time, even part-time. Meanwhile, prepare so no time is lost: finalise test cases, check the environment and data, and plan a short tester briefing. If testers cannot be released, propose re-planning UAT dates rather than letting IT or the BA test on the business's behalf, because acceptance must come from the users.
17

A query using NOT IN to find customers without orders returns zero rows, although you know such customers exist. Why?

Save to ▾
Show answer
The subquery probably returns at least one NULL, for example SELECT customer_id FROM orders where some orders have a NULL customer_id. With NOT IN, comparing any value to NULL gives UNKNOWN, so no row passes the condition. Fix it by using NOT EXISTS with a correlated subquery, or a LEFT JOIN with WHERE o.customer_id IS NULL, or by adding WHERE customer_id IS NOT NULL inside the subquery. NOT EXISTS is the safest habit.
18

After many sprints, project documentation is out of date and new team members are confused. What do you do?

Save to ▾
Show answer
Identify which documents are actually used: usually a product overview, process maps, business rules, data dictionary and integration details. Update those first rather than everything. Make documentation part of the Definition of Done, so a story is not complete until related docs are updated. Keep living documents in a shared wiki with owners and last-reviewed dates, and archive outdated files clearly. Test the result by having a new joiner use it during onboarding.
19

A critical defect is found on the last day of UAT, and the go-live date cannot move. What do you do?

Save to ▾
Show answer
Confirm the impact and reproduce it quickly. Work with development to estimate a fix and its regression effort. Then present options to the business owner with risks: fix and do targeted retesting before go-live, go live with a temporary workaround or manual process, go live with the affected feature switched off, or delay. The decision belongs to the business, documented at the go or no-go meeting. Never hide a critical defect to protect a date.
20

Prepare a simple cost-benefit analysis for automating invoice processing.

Save to ▾
Show answer
Costs: software 12 lakh in year 1 plus 3 lakh per year support, and 4 lakh for implementation and training. Benefits: 60,000 invoices a year at 10 minutes saved each is 10,000 hours; at 400 rupees per hour that is 40 lakh, plus around 5 lakh from fewer late-payment penalties. Year-1 net benefit is 45 - 16 = 29 lakh and payback is under six months. Then test sensitivity, for example if only half the time saving is realised.
21

What is value chain analysis?

Save to ▾
Show answer
Value chain analysis breaks a business into the activities that create value: primary activities such as inbound logistics, operations, outbound logistics, marketing and sales, and service, plus support activities like procurement, technology, HR and infrastructure. For each activity you look at cost and differentiation. In cases it helps locate where costs are rising or where a competitive advantage can be built, for example in last-mile delivery.
22

Write an Excel formula for month-to-date sales up to today.

Save to ▾
Show answer
// Dates in Sales[Date], amounts in Sales[Amount] =SUMIFS(Sales[Amount], Sales[Date], ">=" & EOMONTH(TODAY(), -1) + 1, Sales[Date], "<=" & TODAY()) // EOMONTH(TODAY(),-1)+1 gives the first day of the current month
23

Three departments describe the same order process in three different ways during workshops. How do you arrive at the true AS-IS?

Save to ▾
Show answer
Treat each version as a hypothesis. Walk the process physically or observe real cases end to end, and pull a sample of 20 to 30 recent orders from the system to trace what actually happened. Compare timestamps and status changes with each department's story. Then hold a joint session, show the evidence-based map and mark the variants openly. Often all three are partly right because different order types follow different paths, which should be modelled explicitly.
24

Write a SQL query to get each customer's first order date and first order amount.

Save to ▾
Show answer
WITH ordered AS ( SELECT customer_id, order_date, amount, ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY order_date, order_id) AS rn FROM orders ) SELECT customer_id, order_date AS first_order_date, amount AS first_order_amount FROM ordered WHERE rn = 1;
25

A new TO-BE process went live three months ago. How do you prove that the improvement actually worked?

Save to ▾
Show answer
Compare against the baseline you measured before the change, using the same definitions: cycle time, first-time-right rate, cost per case, backlog and customer complaints. Pull data from system timestamps rather than surveys. Check that the gain is not explained by lower volumes or seasonality, ideally by comparing similar periods. Also check for side effects, such as faster processing but more rework downstream. Present the before-and-after with the business owner, and note where adoption is still incomplete.
26

What does the CALCULATE function do in DAX?

Save to ▾
Show answer
CALCULATE evaluates an expression under a modified filter context. You pass a measure plus filter arguments that add, replace or remove filters, for example CALCULATE([Sales], 'Region'[Name] = "North") or CALCULATE([Sales], ALL('Product')). It is the basis of time intelligence, percent-of-total and comparison measures. It also triggers context transition when used inside a row context, which is powerful but a common source of confusion.
27

How do you calculate cycle time, touch time and process efficiency? Give an example.

Save to ▾
Show answer
Cycle time (lead time) is the total elapsed time from the start to the end of a case. Touch time is the time someone actually works on it. Process cycle efficiency is touch time divided by cycle time. Example: a refund takes 5 working days (40 working hours) end to end, but the agents spend only 2 hours in total working on it. Efficiency is 2 / 40 = 5 percent, so 95 percent of the time is waiting, and queues are the main target.
28

How would you prioritise 10 features with a limited budget?

Save to ▾
Show answer
Score them with RICE or value-vs-effort, align with goals, consider dependencies and risks, validate with stakeholders, then use MoSCoW for the release plan.
29

Write SQL checks to validate a customer data migration between the legacy and new systems during UAT.

Save to ▾
Show answer
-- 1. Row counts should match SELECT (SELECT COUNT(*) FROM legacy.customers) AS legacy_rows, (SELECT COUNT(*) FROM target.customers) AS target_rows; -- 2. Records missing in the target SELECT l.customer_id FROM legacy.customers l LEFT JOIN target.customers t ON t.customer_id = l.customer_id WHERE t.customer_id IS NULL; -- 3. Financial totals should reconcile SELECT SUM(outstanding_balance) FROM legacy.customers; SELECT SUM(outstanding_balance) FROM target.customers;
30

Tell me about a time you built a business case for a project. Was it approved?

Save to ▾
Show answer
Situation: our support team handled order-status queries manually, about 9,000 a month. Task: I was asked to evaluate a self-service tracking page. Action: I measured handling time from ticket data, estimated deflection conservatively at 40 percent, worked with IT on build and run costs and showed best, base and worst cases with payback. Result: leadership approved the base case. Six months after launch, deflection reached 46 percent, and I presented the benefits review to the same committee.
31

Daily active users dropped 10 percent week over week. How do you investigate?

Save to ▾
Show answer
Rule out data issues first: tracking changes, app release bugs, pipeline delays or bot filters. Check whether the drop is seasonal by comparing with the same week last year or a festival calendar. Then segment by platform, app version, country or city, acquisition channel and new versus returning users to locate it. Look at the funnel for the core action. Connect findings to releases, outages or marketing changes, then recommend fixes.
32

The CEO wants one KPI to judge the customer support team. What would you propose?

Save to ▾
Show answer
A single KPI can be gamed, so I would propose one headline with guardrails. The headline could be first-contact resolution rate, because it reflects solving problems, not just closing tickets. Guardrails would be customer satisfaction score after the ticket and median first response time. I would also watch ticket volume per thousand orders, which shows whether product issues are falling. Review targets quarterly with the support head.
33

How do you calculate the percentage contribution of each category?

Save to ▾
Show answer
SUM(sales) per category divided by SUM(SUM(sales)) OVER () and multiplied by 100 gives each category's share of the total.
34

How do you handle changing requirements?

Save to ▾
Show answer
Log the change, assess impact on scope, cost and timeline, get approval through change control or backlog grooming, and update documents and stakeholders.
35

A bank wants to reduce customer churn. What would you do?

Save to ▾
Show answer
Define churn, analyse who leaves and why, segment customers, find drivers through data and surveys, design retention offers and measure uplift with a control group.
36

A product line shows a loss after allocated overheads. Leadership wants to shut it down. How do you advise?

Save to ▾
Show answer
Separate contribution from allocation. If the product's revenue exceeds its variable and directly attributable fixed costs, it contributes to covering shared overheads, which will not disappear if it is closed and will be reallocated to other products. Check whether the overhead allocation key, such as revenue share, is fair. Also consider strategic links, like customers who buy it alongside profitable products. Recommend shutting it only if contribution is negative or the freed capacity has a better use.
37

Your A/B test was meant to split traffic 50/50, but the actual split is 52/48 on 200,000 users. What do you do?

Save to ▾
Show answer
This is a sample ratio mismatch. With 200,000 users, a 52/48 split is far outside random chance, which a chi-square test will confirm. It means the assignment or logging is broken, for example the variant page crashing before the tracking event fires, bots filtered unevenly or a redirect losing users. Do not trust the results. Investigate by segment, platform and day to find the cause, fix it and rerun the test.
38

Write a SQL query that shows revenue, cost and gross margin percent by product category.

Save to ▾
Show answer
SELECT p.category, SUM(oi.quantity * oi.unit_price) AS revenue, SUM(oi.quantity * p.unit_cost) AS cost, ROUND(100.0 * (SUM(oi.quantity * oi.unit_price) - SUM(oi.quantity * p.unit_cost)) / NULLIF(SUM(oi.quantity * oi.unit_price), 0), 2) AS gross_margin_pct FROM order_items oi JOIN products p ON p.product_id = oi.product_id GROUP BY p.category ORDER BY gross_margin_pct DESC;
39

What is process mining and how does it help a business analyst?

Save to ▾
Show answer
Process mining uses event logs from systems such as ERP or CRM, each record holding a case ID, activity name and timestamp, to automatically rebuild how a process really runs. It shows actual paths, rework loops, bottlenecks and how often cases deviate from the designed flow. For a BA it replaces opinion-based AS-IS workshops with evidence, for example showing that 22 percent of purchase orders are changed after approval. Data quality of the logs is the main limitation.
40

What is a product backlog vs a sprint backlog?

Save to ▾
Show answer
The product backlog is the ordered list of all desired work; the sprint backlog is the subset the team commits to in the current sprint.

Tips to crack the Zomato Business Analytics interview

  • Practise product and business cases about restaurant ratings, delivery times or Blinkit order growth with clear metrics.
  • Revise SQL and Excel well, since analyst assignments often involve cleaning order data and presenting insights.
  • Follow Zomato and Eternal shareholder letters, which openly explain business priorities and are useful for interview discussion.
  • Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
  • Practise the hard questions on this page aloud; Zomato interviewers usually ask follow-ups on your first answer.

Frequently asked questions

How many rounds are there in the Zomato Business Analytics interview?

Candidates usually go through 4 stages: Online assessment or assignment; Technical or case round; Hiring manager round; Culture fit round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.

Which topics should I prepare for the Zomato Business Analytics interview?

This practice set leans on Case Studies and Guesstimates (10), Process Modelling and BPMN (5), Requirements and Agile (5), UAT and BA Documentation (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Zomato interviewers ask you to walk through real work.

Are these the exact questions asked at Zomato?

No. These are curated practice questions that match the skills and difficulty usually tested in e-commerce & consumer tech interviews like Zomato's. They are not a leaked or verified list of past questions.

Where does Zomato hire Business Analytics professionals in India?

Zomato has large teams in Gurugram. Openings and locations change often, so check the Zomato careers page and filter by city and experience.

Business Analytics questions for similar companies