How to crack Zomato: The Product Analyst interview, from real experiences
Zomato (Eternal) Product Analyst interview guide for India campus hiring: the SQL/aptitude/Python OA, and the CV-and-SQL interview rounds, with real reported questions.
On this page
Last reviewed November 17, 2026.
For students interviewing for Product Analyst at Zomato (Eternal) on Indian campuses.
Built by the Codinzhub team from Zomato/Eternal Product Analyst online assessment papers and one interview experience that students shared on Codinzhub in October 2026, from IIT Guwahati and IIT Indore. This is a thinner dataset than our Zomato SDE 1 guide — one interview report and one detailed OA paper — so some sections below say plainly where evidence runs out. Use this guide as a map, not a promise.
How this guide was built. We reviewed every Zomato/Eternal Product Analyst record on Codinzhub, searched LeetCode Discuss, Glassdoor, Naukri Code360, Medium, GeeksforGeeks and Reddit for "Zomato Eternal product analyst interview experience," and read through the results. No Reddit thread specific to this exact role came up; the closest related finds were analyst-style interview-prep pages for Zomato in general (SQL, metrics and business-recommendation questions), which we note only as general context, not as verified Zomato process. Because of the thin dataset, treat every claim here as a single report unless we say otherwise.
The 30-second version. Zomato's campus Product Analyst hiring, seen at IIT Guwahati in 2026, runs an online assessment with SQL query questions, aptitude MCQs, and Python/statistics MCQs (one paper reported 4 SQL + 20 aptitude + 4 Python questions; another reported 30 MCQs plus 3 coding questions in 60 minutes). One IIT Indore candidate (2026) reported three interview rounds: a CV-based round with one guesstimate and one SQL question, a round on CV plus Pandas, Excel and SQL, and a final HR round. The candidate's own advice afterward was simply "practice SQL."
Important things to know before the interview
This role's data is thin, so take every number with real caution. We have one full interview report and a handful of OA question records, all from October 2026. Where a report says a count or a cutoff, it is one person's experience, not a verified rule.
SQL shows up in every single stage we have evidence for. The OA has SQL query questions, and the one interview report mentions SQL in two of its three rounds. If you prepare only one thing for this role, make it SQL.
Timestamps-as-text is a real trap in the OA's SQL questions. One reported SQL question explicitly warns that timestamps are stored as strings in dd-mm-yyyy hh:mm:ss format, and that subtracting them as raw text gives the wrong answer; you must convert them to a proper date type first.
Pandas and Excel came up alongside SQL in the interview, not just in the OA. The one interview report describes a round that mixed CV questions with Pandas, Excel and SQL together, so analyst tool fluency matters beyond the written test.
What this guide covers
This guide covers the Product Analyst role at Zomato/Eternal, based on one on-campus interview report (IIT Indore, October 2026) and OA question records from IIT Guwahati (October 2026). It does not cover the SDE 1, data scientist or business analyst roles; see the SDE 1 guide linked at the end for that process.
Given how thin this dataset is, treat this guide as a starting point and confirm the current format with your placement cell or recruiter.
Round-by-round breakdown
Stage 1: Application, where candidates applied
How it works. Not reported. The one interview report and the OA records in this guide are both from on-campus placement drives (IIT Guwahati and IIT Indore).
Stage 2: Shortlisting, how candidates moved forward
How it works. Not reported.
Stage 3: Online assessment (OA)
How it works. The OA mixes SQL query-writing, aptitude/reasoning MCQs, and Python or statistics MCQs. One IIT Guwahati paper (2026) listed 4 SQL questions, 20 aptitude MCQs and 4 Python MCQs. A separate paper from the same drive instead listed 30 MCQs plus 3 coding questions in 60 minutes, which may be a different OA slot or set within the same drive — we cannot confirm which.
At a glance
- Duration: 60 minutes reported for the "30 MCQ + 3 coding" paper; not reported for the SQL/aptitude/Python paper
- Questions per round: 4 SQL + 20 aptitude + 4 Python in one paper; 30 MCQ + 3 coding in another
- Topics: SQL joins and date/time handling, probability and statistics, basic number theory aptitude
- Reported examples: F1 score from a confusion matrix, probability that a parent is ill given conditional probabilities, 4-digit numbers whose square ends in themselves
Reported questions
| Question summary | Skill or pattern | Reported follow-up | Level / scope | Codinzhub question or experience |
|---|---|---|---|---|
| How many 4-digit numbers are divisible by 11 but are not palindromes? | Number theory, counting | Not reported | Product Analyst, IIT Guwahati, 2026 | MCQs Eternal, IIT Guwahati |
| How many 4-digit numbers n exist such that the last four digits of n² equal n itself? | Number theory | Not reported | Product Analyst, IIT Guwahati, 2026 | Four-digit numbers whose square ends in itself |
| Given P(at least one parent ill) = 20%, P(father ill) = 7%, P(both ill) = 5%, find P(mother ill). | Conditional probability, inclusion-exclusion | Not reported | Product Analyst, IIT Guwahati, 2026 | Product Analyst MCQs, IIT Guwahati |
| Write a SQL query comparing anonymous vs subscribed viewers: count of sessions and average watch time per type, handling string timestamps and a possible empty table. | SQL, date/time conversion, aggregation | Not reported | Product Analyst, IIT Guwahati, 2026 | Anonymous vs. Subscribed Viewer Watch Time |
| From a bag of 4 red, 7 blue and 3 green balls, find the probability of drawing 3 consecutive red balls without replacement. | Probability, combinatorics | Not reported | Product analyst, IIT Guwahati, 2026 | MCQs: Probability and Statistics |
| Given TP=40, FP=10, TN=20, FN=4 from a classification report, find the F1 score. | Statistics, classification metrics | Not reported | Product analyst, IIT Guwahati, 2026 | Statistics |
Stage 4: Interview round 1
How it works. Based on the one IIT Indore report, this round is mainly about your CV, plus one guesstimate question and one SQL question.
Reported questions
| Question summary | Skill or pattern | Level / scope | Codinzhub question or experience |
|---|---|---|---|
| CV-based questions, one guesstimate question, and one SQL question. | Resume depth, estimation, SQL | Product Analyst, IIT Indore, 2026 | Zomato Product analyst Interview Experience |
Stage 5: Interview round 2
How it works. Mostly CV-based again, with added questions on Pandas, Excel and SQL.
Reported questions
| Question summary | Skill or pattern | Level / scope | Codinzhub question or experience |
|---|---|---|---|
| CV questions, plus questions on Pandas, Excel and SQL. | Analyst tools | Product Analyst, IIT Indore, 2026 | Zomato Product analyst Interview Experience |
Stage 6: HR round
How it works. Mainly HR-based questions, per the one report we have. No specific questions were listed.
Zomato experiences shared on Codinzhub
| College | Role and result | What was asked | Experience |
|---|---|---|---|
| IIT Indore | Product Analyst, result not reported | CV, one guesstimate, SQL; CV, Pandas, Excel, SQL; HR | Read it |
The Codinzhub next-round playbook
To prepare for the OA
- Practise SQL date/time handling specifically: converting string timestamps to a proper date type before computing a duration, and handling an empty table gracefully (return 0, not an error).
- Revise conditional probability (inclusion-exclusion for "at least one of two events") and classification metrics (precision, recall, F1 score) by hand.
- Keep basic number-theory aptitude sharp: divisibility, palindromes, digit properties.
To prepare for the interview
- Prepare one or two guesstimate answers using a clear, simple structure: state your assumptions, break the estimate into parts, and sanity-check the final number out loud.
- Revise Pandas basics (groupby, merge, filtering) and common Excel functions (VLOOKUP/XLOOKUP, pivot tables) alongside SQL, since round 2 mixed all three.
- Know your CV in depth; both interview rounds in the one report we have were CV-led.
Variations within this role
Not enough data to describe variations within this role across colleges or years. The one interview report and the OA records we have are both from October 2026 drives.
Do's and don'ts
| Do | Don't | Why it matters |
|---|---|---|
| Convert string timestamps to a real date type before subtracting them. | Subtract date strings directly. | The reported OA question explicitly warns this gives the wrong answer. |
| Practise a simple, structured guesstimate method. | Blurt out a single guessed number with no reasoning shown. | The one interview report lists a guesstimate question directly. |
| Revise Pandas and Excel alongside SQL. | Prepare SQL only. | Round 2 in the one report mixed all three tools together. |
| Know your CV well enough to field unscripted follow-ups. | Memorise a rehearsed script. | Both interview rounds in the one report were CV-led. |
Most-asked topics
This dataset is small: 1 interview experience and 6 OA question records. We list what appeared, without ranking by frequency.
| Topic | What it means | Reported examples | Codinzhub practice |
|---|---|---|---|
| SQL | Writing queries, especially with date/time handling | Viewer watch-time query | Anonymous vs. Subscribed Viewer Watch Time |
| Probability and statistics | Conditional probability, classification metrics | F1 score, parent-illness probability | MCQs: Probability and Statistics |
| Number theory aptitude | Digit and divisibility properties | Palindrome multiples of 11, self-ending squares | MCQs Eternal, IIT Guwahati |
| Analyst tools (Pandas, Excel) | Data manipulation outside SQL | Mentioned in interview round 2 | Zomato Product analyst Interview Experience |
Preparing for the HR round
The one report we have says this round was "mainly HR based questions" with no specifics listed. Prepare standard HR basics: why Zomato, why this role, and your career goals, using honest, specific answers.
Practice problems that match the experiences
These are practice analogues, not proof that Zomato asked the exact problem, unless marked otherwise.
| # | Practice problem | Pattern | Related reported question or variant |
|---|---|---|---|
| 1 | Average Time of Process per Machine (LeetCode: date/time SQL practice) | SQL, timestamp subtraction | Anonymous vs. Subscribed Viewer Watch Time |
| 2 | F1 score calculation from a confusion matrix (standard statistics exercise) | Classification metrics | F1 score question |
| 3 | Conditional probability with inclusion-exclusion (standard probability exercise) | Probability | Parent-illness probability question |
How to handle a question you have never seen
- For an SQL question, check the column types first; a "time difference looks wrong" bug is usually a string vs. date type issue.
- For a probability question, write out what is given as P(A), P(B), P(A and B) before picking a formula.
- For a guesstimate, state your assumptions out loud, break the number into factors you can estimate individually, then multiply them back together.
- For a metrics question (F1, precision, recall), write the confusion-matrix formula first, then plug in numbers.
Why candidates were rejected
No report in this guide gives an outcome or rejection feedback for this role.
If you remember only five things
- Zomato's Product Analyst OA mixes SQL, aptitude and Python/statistics MCQs.
- Practise converting string timestamps to real dates before computing a duration in SQL.
- Expect at least one guesstimate question in the interview.
- Round 2 may test Pandas and Excel alongside SQL, not SQL alone.
- Both interview rounds we have evidence for are CV-led, so know your CV cold.
FAQ
How many OA questions should I expect?
Reports differ: one paper lists 4 SQL + 20 aptitude + 4 Python questions, another lists 30 MCQs plus 3 coding questions in 60 minutes. We cannot confirm which is the current standard format.
Is this the same OA as the SDE role?
No. The SDE 1 OA (see our separate guide) is DSA-heavy with trees and graphs; this Product Analyst OA is SQL, aptitude and statistics-focused.
Do I need Python for this role?
One OA paper included 4 Python MCQs, so basic Python/pandas fluency is worth having, though this is based on a single reported paper.
Is there a guesstimate round every time?
Based on the one interview report we have, yes, one round included a guesstimate question. We cannot confirm this for every drive.
About this guide
The Codinzhub team wrote this guide from 1 Zomato/Eternal Product Analyst interview experience and 6 OA question records shared on Codinzhub in October 2026, from IIT Guwahati and IIT Indore. We also searched LeetCode Discuss, Glassdoor, Naukri Code360, Medium, GeeksforGeeks and Reddit for this exact role and found no additional verified reports; the closest material was general Zomato analyst-role prep content, which we have not used as a source of facts here. Questions are short paraphrases in our own words.
You can help other students by sharing your Zomato experience on Codinzhub.
Interview processes change by college, year and team. Your placement cell or recruiter can confirm the current format.
Other company and role guides
Keep track of what you’ve learned.