Jobra
🐞Step 1 of Jobra:AI Debugging Rounds
DSA+AIPreparing you for both.
JOBRA · AI DEBUG ROUND (PREVIEW)sum.cpp
// buggy snippet
int total(vector<int>& a, int n) {
    int sum = 0;
    for (int i = 0; i <= n; i++) { // 🐞        sum += a[i];
    }
    return sum;
}
A real codebase. A real bug. You + AI.

Jobra drops you into a broken repo. Find it, fix it, ship it. AI helps you debug like on the job.

Prompt:Correct the loop condition
Tap 'Let Jobra fix it' below to simulate AI debugging...

How to crack Zomato: The Product Analyst interview, from real experiences

9 min read

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.

In this article
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 summarySkill or patternReported follow-upLevel / scopeCodinzhub question or experience
How many 4-digit numbers are divisible by 11 but are not palindromes?Number theory, countingNot reportedProduct Analyst, IIT Guwahati, 2026MCQs Eternal, IIT Guwahati
How many 4-digit numbers n exist such that the last four digits of n² equal n itself?Number theoryNot reportedProduct Analyst, IIT Guwahati, 2026Four-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-exclusionNot reportedProduct Analyst, IIT Guwahati, 2026Product 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, aggregationNot reportedProduct Analyst, IIT Guwahati, 2026Anonymous 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, combinatoricsNot reportedProduct analyst, IIT Guwahati, 2026MCQs: Probability and Statistics
Given TP=40, FP=10, TN=20, FN=4 from a classification report, find the F1 score.Statistics, classification metricsNot reportedProduct analyst, IIT Guwahati, 2026Statistics

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 summarySkill or patternLevel / scopeCodinzhub question or experience
CV-based questions, one guesstimate question, and one SQL question.Resume depth, estimation, SQLProduct Analyst, IIT Indore, 2026Zomato 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 summarySkill or patternLevel / scopeCodinzhub question or experience
CV questions, plus questions on Pandas, Excel and SQL.Analyst toolsProduct Analyst, IIT Indore, 2026Zomato 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

CollegeRole and resultWhat was askedExperience
IIT IndoreProduct Analyst, result not reportedCV, one guesstimate, SQL; CV, Pandas, Excel, SQL; HRRead 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

DoDon'tWhy 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.

TopicWhat it meansReported examplesCodinzhub practice
SQLWriting queries, especially with date/time handlingViewer watch-time queryAnonymous vs. Subscribed Viewer Watch Time
Probability and statisticsConditional probability, classification metricsF1 score, parent-illness probabilityMCQs: Probability and Statistics
Number theory aptitudeDigit and divisibility propertiesPalindrome multiples of 11, self-ending squaresMCQs Eternal, IIT Guwahati
Analyst tools (Pandas, Excel)Data manipulation outside SQLMentioned in interview round 2Zomato 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 problemPatternRelated reported question or variant
1Average Time of Process per Machine (LeetCode: date/time SQL practice)SQL, timestamp subtractionAnonymous vs. Subscribed Viewer Watch Time
2F1 score calculation from a confusion matrix (standard statistics exercise)Classification metricsF1 score question
3Conditional probability with inclusion-exclusion (standard probability exercise)ProbabilityParent-illness probability question

How to handle a question you have never seen

  1. For an SQL question, check the column types first; a "time difference looks wrong" bug is usually a string vs. date type issue.
  2. For a probability question, write out what is given as P(A), P(B), P(A and B) before picking a formula.
  3. For a guesstimate, state your assumptions out loud, break the number into factors you can estimate individually, then multiply them back together.
  4. 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

  1. Zomato's Product Analyst OA mixes SQL, aptitude and Python/statistics MCQs.
  2. Practise converting string timestamps to real dates before computing a duration in SQL.
  3. Expect at least one guesstimate question in the interview.
  4. Round 2 may test Pandas and Excel alongside SQL, not SQL alone.
  5. 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

Ready for the next topic?

Keep track of what you’ve learned.