Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Zomato Team. If you also belong to the team, you can get access from here

Zomato Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Zomato Production Analyst Interview Questions and Answers

Updated 4 Sep 2024

Zomato Production Analyst Interview Experiences

3 interviews found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Campus Placement and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Aptitude
SQL MCQ
SQL query -4
On hacker rank - 90 mins

Round 2 - Technical 

(2 Questions)

  • Q1. Project related questions and sql
  • Q2. Any project you mentioned in your resume
  • Ans. 

    Developed a project to optimize production processes using data analysis

    • Implemented statistical analysis to identify bottlenecks in production

    • Utilized machine learning algorithms to predict equipment failures and prevent downtime

    • Collaborated with cross-functional teams to implement process improvements

    • Generated reports and dashboards to track key performance indicators

  • Answered by AI
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Hacker rank 30 ques aptitude 3 ques sql and one ques python

Round 2 - One-on-one 

(2 Questions)

  • Q1. Probabilty and stats question
  • Q2. 2-3 sql question

Production Analyst Interview Questions Asked at Other Companies

asked in SPRINKLR
Q1. Minimum Time To Solve The Problems Given 'N' subjects, each conta ... read more
asked in SPRINKLR
Q2. Maximum of All Subarrays of Size K You are provided with an array ... read more
asked in CRED
Q3. you are PM of Netflix what will be the top 3 metrics you will loo ... read more
asked in SPRINKLR
Q4. LRU Cache Design Question Design a data structure for a Least Rec ... read more
asked in SPRINKLR
Q5. Shortest Path in a Binary Matrix Problem Statement Given a binary ... read more
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Apr 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Aptitude Test 

Simple aptitute question based on mathematics based

Round 3 - Technical 

(1 Question)

  • Q1. Sql queries ,guesstimates

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare sql and guesstimates

Interview questions from similar companies

I applied via Referral and was interviewed before Apr 2021. There were 3 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. Why are you looking for a change?
  • Q2. Tell me about yourself.
  • Q3. Why should we hire you?
Round 2 - Aptitude Test 

Basic sql

Round 3 - Technical 

(1 Question)

  • Q1. Project manager round

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure to read Amazon list of principles,and ensure your cv speaks to it

I applied via Company Website and was interviewed in May 2019. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQL, Business cases

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough with examples for each of the 14 principles

Interview Questionnaire 

1 Question

  • Q1. Question 1: General HR questions, some based on the CV Question 2: A marketing specific question

Interview Preparation Tips

Round: Test
Experience: The test basically tests your ability to solve questions as quickly as possible as it's a 60 minute test for 60 questions. The level of difficulty is pretty decent, so one just needs to be focused right from the beginning. English can trouble a bit, so some practice in English sections is also advisable.
Tips: Prepare from Arun Sharma Quantitative Aptitude and Logical Reasoning for CAT. It's a wholesome book and has enough questions to practice and build concepts. Join a test series so that you get a timed analysis of your performance, the ability to skip tough questions and to score as many marks as possible.
Duration: 40 minutes

Round: Group Discussion
Experience: It went pretty well. We had a great discussion. The approach was to list out all the problems one by one and think of probable solutions for each of them. During this, general group dynamics should be taken in consideration. Respect the views and thoughts of other people. Add value to the discussion by thinking critically and bringing new content every now and then. Always be specific and speak to the point.
Tips: Read. Read and Read.
Follow google news, read relevant articles in newspapers, magazines, social media sites or any other place.
Follow Quora, It'a an amazing source to boost your knowledge around any topic.
Duration: 50 minutes

Round: HR Interview
Experience: Be spontaneous, little humorous and lastly very confident. Communication skills improve with time, so start as early as possible. Take part in discussions. Speak up !
Tips: Have a sound knowledge about the industry and the company. They just check your approach. So be very clear and critical on the approach. Have good reasons to back what ever you present. Rest will be fine.

Skills: Communication And Confidence, Analytical Skills, Business Logic, Business Acumen
College Name: Institute of Management, Nirma University

Interview Questionnaire 

3 Questions

  • Q1. General HR questions, some based on the CV
  • Q2. A marketing specific question
  • Q3. Weight of an aircraft
  • Ans. 

    The weight of an aircraft is crucial for its performance and safety.

    • The weight of an aircraft includes the weight of the aircraft itself, fuel, passengers, cargo, and any other equipment on board.

    • The weight of an aircraft is measured in pounds or kilograms.

    • The weight of an aircraft affects its takeoff and landing performance, as well as its fuel efficiency and range.

    • Aircraft manufacturers provide maximum takeoff and la...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: The test basically tests your ability to solve questions as quickly as possible as it's a 60 minute test for 60 questions. The level of difficulty is pretty decent, so one just needs to be focused right from the beginning. English can trouble a bit, so some practice in English sections is also advisable.
Tips: Prepare from Arun Sharma Quantitative Aptitude and Logical Reasoning for CAT. It's a wholesome book and has enough questions to practice and build concepts. Join a test series so that you get a timed analysis of your performance, the ability to skip tough questions and to score as many marks as possible.

Round: Group Discussion
Experience: It went pretty well. We had a great discussion. The approach was to list out all the problems one by one and think of probable solutions for each of them. During this, general group dynamics should be taken in consideration. Respect the views and thoughts of other people. Add value to the discussion by thinking critically and bringing new content every now and then. Always be specific and speak to the point.
Tips: Read. Read and Read.
Follow google news, read relevant articles in newspapers, magazines, social media sites or any other place.
Follow Quora, It'a an amazing source to boost your knowledge around any topic.

Round: HR Interview
Experience: Be spontaneous, little humorous and lastly very confident. Communication skills improve with time, so start as early as possible. Take part in discussions. Speak up !
Tips: Have a sound knowledge about the industry and the company. They just check your approach. So be very clear and critical on the approach. Have good reasons to back what ever you present. Rest will be fine.

Round: Guesstimate Interview
Experience: A very commonly asked guesstimate problem. Ask as many questions as possible to clear out the situation for yourself and get enough hints to solve the problem. Break it down into smaller sections and solve each section individually.
Tips: Follow "case in point", Analytics Vidya and similar blogs and websites to practice more and more guesstimates.

General Tips: There are so many opportunities. You just need one. Be focused on that ONE.
Skill Tips: Take part in discussions among your friends. Read books and quora to get more content. Practice as many questions as possible for aptitude. Discuss problems and have critical analysis sessions to understand things with a company's perspective.
Skills: Communication , Aptitude, Business Acumen
College Name: IIT GUWHATI
Motivation: To learn the operations and Logistics of the e-commerce industry.
Funny Moments: There will be many while you'll be preparing with your friends. :D
All the best.

I was interviewed before Nov 2019.

Interview Questionnaire 

6 Questions

  • Q1. Visualize a Uber database of drivers and riders(users) and write a SQL query to get the top 100 drivers by city.
  • Ans. 

    SQL query to get top 100 Uber drivers by city

    • Join drivers and users tables on city

    • Aggregate driver ratings and count of rides

    • Order by rating and count of rides

    • Limit to top 100

  • Answered by AI
  • Q2. How do you optimize the listing of Restaurants on Swiggy?
  • Ans. 

    Optimizing the listing of Restaurants on Swiggy involves using data-driven strategies to improve visibility, relevance, and user experience.

    • Analyze user behavior and preferences to understand their needs and preferences

    • Implement a ranking algorithm based on factors like ratings, reviews, popularity, and delivery time

    • Optimize search functionality to ensure accurate and relevant results

    • Collaborate with restaurants to imp...

  • Answered by AI
  • Q3. What are the major differences between a Linear Regression and a Logistic Regression?
  • Ans. 

    Linear Regression is used for continuous data while Logistic Regression is used for categorical data.

    • Linear Regression predicts continuous values while Logistic Regression predicts probabilities.

    • Linear Regression uses a straight line to fit the data while Logistic Regression uses an S-shaped curve.

    • Linear Regression uses Mean Squared Error as the cost function while Logistic Regression uses Log Loss.

    • Linear Regression is...

  • Answered by AI
  • Q4. What is the Bias Variance trade-off and name some models with high bias and low variance?
  • Ans. 

    Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.

    • Bias-Variance trade-off is a fundamental concept in machine learning.

    • High bias models are simple and have low variance, but are inaccurate.

    • Low bias models are complex and have high variance, but can overfit the data.

    • Examples of high bias models are linear r...

  • Answered by AI
  • Q5. A car manufacturer has observed a decline in profits by 40% year over year. What would be the possible reasons for this?
  • Ans. 

    Possible reasons for a car manufacturer's decline in profits by 40% year over year

    • Decreased demand for cars due to economic downturn

    • Increased competition from other car manufacturers

    • Rising production costs and expenses

    • Decline in consumer confidence and spending

    • Changes in government regulations impacting the automotive industry

  • Answered by AI
  • Q6. If you have 100 unbiased coins and one of them is defective. You have a weighing balance to check the weight of the coins. What is the minimum number of times you need to weigh the coins to identify the de...

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for the projects which you have worked upon. Practice case studies on varied businesses from a problem-solving perspective with an analytical approach.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude test which is easily done

Round 2 - Technical 

(2 Questions)

  • Q1. What are joins? What is windows function
  • Ans. 

    Joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.

    • Joins are used in SQL to combine data from multiple tables based on a related column

    • Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Window functions are used to perform calculations on a set of rows rela...

  • Answered by AI
  • Q2. Aggregation and ctes and subqueries

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep the SQL ready

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Tell me about a project you faced difficulties?
  • Q2. Given a table ..asked some SQL questions
Round 2 - Technical 

(2 Questions)

  • Q1. Shared a table ...asked to write some SQL queries
  • Q2. Sman queries result how to derive in excel
  • Ans. 

    Use Excel functions like VLOOKUP or INDEX/MATCH to derive results from SQL queries in Excel.

    • Use VLOOKUP function to search for a value in a table and return a corresponding value from another column.

    • Use INDEX/MATCH function to perform a two-way lookup by matching values in two different ranges.

    • Import SQL query results into Excel using data connection or copy-paste method.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Question was moderate level

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Zomato Interview FAQs

How many rounds are there in Zomato Production Analyst interview?
Zomato interview process usually has 2-3 rounds. The most common rounds in the Zomato interview process are Aptitude Test, Technical and Resume Shortlist.
What are the top questions asked in Zomato Production Analyst interview?

Some of the top questions asked at the Zomato Production Analyst interview -

  1. Project related questions and ...read more
  2. sql queries ,guesstima...read more
  3. probabilty and stats quest...read more

Recently Viewed

INTERVIEWS

Keyence

No Interviews

INTERVIEWS

SmartBear

No Interviews

INTERVIEWS

ClearTax

No Interviews

INTERVIEWS

Vijaya Diagnostic Centre

No Interviews

INTERVIEWS

Dr Lal PathLabs

No Interviews

INTERVIEWS

Thyrocare Technologies

No Interviews

INTERVIEWS

FNZ

No Interviews

SALARIES

Dr Lal PathLabs

SALARIES

Dr Lal PathLabs

SALARIES

Dr Lal PathLabs

Tell us how to improve this page.

Zomato Production Analyst Interview Process

based on 4 interviews

Interview experience

3.5
  
Good
View more

Interview Questions from Similar Companies

Amazon Interview Questions
4.1
 • 5k Interviews
Flipkart Interview Questions
4.0
 • 1.3k Interviews
Swiggy Interview Questions
3.8
 • 428 Interviews
PolicyBazaar Interview Questions
3.6
 • 348 Interviews
Udaan Interview Questions
3.9
 • 334 Interviews
Meesho Interview Questions
3.7
 • 328 Interviews
JustDial Interview Questions
3.5
 • 328 Interviews
Info Edge Interview Questions
3.9
 • 316 Interviews
Myntra Interview Questions
4.0
 • 215 Interviews
View all
Zomato Production Analyst Salary
based on 30 salaries
₹13 L/yr - ₹28 L/yr
100% more than the average Production Analyst Salary in India
View more details

Zomato Production Analyst Reviews and Ratings

based on 2 reviews

3.1/5

Rating in categories

2.0

Skill development

2.0

Work-life balance

2.6

Salary

1.5

Job security

2.6

Company culture

2.0

Promotions

2.6

Work satisfaction

Explore 2 Reviews and Ratings
Key Account Manager
928 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Delivery Boy
893 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Analyst
588 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Accounts Manager
296 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
273 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Zomato with

Swiggy

3.8
Compare

Amazon

4.1
Compare

Dunzo

3.4
Compare

Flipkart

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent