
Zomato Product Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 23 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Zomato.
Product Analyst
the interview process was three rounds. first round: SQL moderate questions, statisctics and logical reasoning mcq. second round: sql grilling, rca and product sense and resume projects. third round: manager round company fit and some hr related questions.
- Calculate month-over-month sales from the provided table.
- What are some strategies to improve customer retention?
Product Analyst
We had an online assessment that was 1.5hrs long and included quant aptitude, data interpretation, logical reasoning, 3 SQL questions, and 1 Python question. 10 candidates were shortlisted for the interviews as it was an on-campus process. There were 3 interview rounds in total. The first round focused on internships, product improvement, and puzzles. The second round was a proper product interview where they grilled us on why product, why Zomato, and included some guesstimates.
- Can you introduce yourself and elaborate on your internships?
- What are your ideas to increase Zomato's Average Order Value?
- Could you solve some puzzles from GeeksforGeeks?
Product Analyst
The entire interview process took place on a single day. We started with an assessment on HackerEarth's platform right there on campus. It was proctored, and Zomato representatives were supervising the venue. The test lasted for an hour and had two sections. The first section included 20 MCQs covering Data Interpretation, Logical Reasoning, Quantitative Aptitude, and MySQL, ranging from easy to moderate difficulty. The second section had 3 coding questions in MySQL, focusing on Joins and Subqueries. One of these was easy to moderate, but the other two were hard and proved to be the main challenge. It's a good idea to get familiar with HackerEarth's MySQL IDE beforehand because the outputs and test cases are different from typical DSA assessments. We got the OA results within an hour. Out of 408 students, only 19 were shortlisted for interviews, and then 4 of us made it to the second round.
- Can you give a brief introduction about yourself?
- What makes you want to pursue a product role?
- We'd like to discuss every point mentioned on your resume and ask some follow-up questions.
Zomato Product Analyst Interview Questions
Quoted word for word from Zomato interview reports.
“How many dustbins are there in a college?”
Read reports →“Can you write an SQL query using a window function?”
Read reports →“Can you write SQL queries using window functions?”
Read reports →“Would you prefer lower or higher delivery charges for users?”
Read reports →“Can you estimate the number of pizzas sold in your area?”
Read report →“Can you write an SQL query for this database?”
Read report →“Can you solve this coding problem using Python and pandas?”
Read report →“Since delivery rates can't be changed or tested with A/B testing, how would you test or monitor a change in delivery rates, say from 30 to 25 or 34?”
Read report →“Zomato has an 80% rate of happy deliveries (on-time), which has now increased to 95%. What are your thoughts on why this might have happened?”
Read report →Formats, difficulty and experience
Across all 23 Zomato interview reports.