Premium Employer

i

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

Tata 1mg Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Tata 1mg Production Analyst Interview Questions and Answers

Updated 15 Oct 2024

Tata 1mg Production Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 4 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL questions based on joins
  • Q2. Running sum questions
Round 2 - Case Study 

Case studies based on one of your projects which you had done in your past organisation

Round 3 - Case Study 

How would you approach a problem of auto application of coupon

Round 4 - Case Study 

Brainstorming on a case studies

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Jun 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. The questions were around technical documentation and tasks were given on documentation
  • Q2. E commerce related questions were asked

Interview Preparation Tips

Interview preparation tips for other job seekers - The managerial round was also core technical. If u do well in all the technical rounds you have high chance of clearing the interview
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jul 2022. There were 4 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 - Case Study 

1. Tell me about yourself
2. Estimate the number of hospitals in India

Round 3 - Case Study 

1. There has been a decrease in 20% of the users in the past 3 days in online pharmacy application, what will you do now?

Round 4 - HR 

(4 Questions)

  • Q1. Salary negotiation on what were last salary and related questions
  • Q2. How soon can you join?
  • Q3. Are you holding any other offer, in case you do..they will try to match it which ideally depends on your interview.
  • Q4. Are you comfortable relocating to the office location?

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview is fairly easy, just be confident and explain your thought process to the interviewer while answering any question. They will support you and help you reach the destination if you do so.

Interview Questionnaire 

1 Question

  • Q1. Different types of joins in SQL, Delete drop truncate difference
  • Ans. 

    Different types of joins in SQL, Delete drop truncate difference

    • Types of joins: Inner join, Left join, Right join, Full outer join

    • Inner join returns only matching rows from both tables

    • Left join returns all rows from left table and matching rows from right table

    • Right join returns all rows from right table and matching rows from left table

    • Full outer join returns all rows from both tables

    • Delete is used to remove specific ...

  • Answered by AI

Skills evaluated in this interview

I applied via Referral and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How can you understand the supply of restaurant in a particular area of a city ?
  • Ans. 

    To understand the supply of restaurants in a particular area of a city, we can use various methods.

    • Collect data from online directories like Yelp, Zomato, etc.

    • Conduct surveys to gather information about the number of restaurants in the area.

    • Analyze the population density and demographics of the area to estimate the demand for restaurants.

    • Check the number of restaurant permits issued by the local government.

    • Use GIS mapp...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand any city's demographics for instance. Take most busy road and assume that 70% supply will be on food -tech (MArket Standard). Open Sw / Zo and see the supply available in that area in peak time. There can be more than one way to solve for these question

I applied via Company Website and was interviewed in Aug 2022. There were 2 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 - Technical 

(2 Questions)

  • Q1. Ques.1 How many delivery boy have called customers more than 5 times?
  • Ans. 

    The number of delivery boys who called customers more than 5 times is not provided.

    • Data on the number of delivery boys who called customers more than 5 times is missing.

    • Need to gather data on the number of delivery boys and their call logs.

    • Analysis can be done once the data is available.

  • Answered by AI
  • Q2. Question 2. Count distinct uniques names from the table
  • Ans. 

    To count distinct unique names from a table, use the SELECT DISTINCT statement with the name column.

    • Use SELECT DISTINCT to retrieve unique names

    • Specify the name column in the SELECT statement

    • Example: SELECT DISTINCT name FROM table_name

    • Store the result in an array of strings

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepared well for SQL. Try to use hacker rank for the preparation.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

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

Round 1 - Coding Test 

Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Introduction and explain any one of the projects plus what was the analytics you used
  • Ans. 

    Implemented a project to optimize marketing campaigns using predictive analytics

    • Developed a predictive model to identify the most effective marketing channels

    • Utilized data from past campaigns to train the model

    • Used techniques such as regression analysis and decision trees to analyze the data

    • Generated insights on customer behavior and preferences to improve campaign targeting

  • Answered by AI
  • Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be very very well prepared with SQL and you should be aware of advanced sql, not only concepts but solving questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Coding Test 

Mostly sql question asked, moderate level

Round 2 - One-on-one 

(2 Questions)

  • Q1. Sql join and sub query
  • Q2. Window functions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Sep 2022. There were 5 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 - Coding Test 

Basic SQL questions

Round 3 - Technical 

(1 Question)

  • Q1. SQL python and basic statistics
Round 4 - Case Study 

Problem solving case studies, analytics cases

Round 5 - One-on-one 

(1 Question)

  • Q1. Hiring manager round, general HR questions and resume based questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

SQL test coding assessment which I am yet to give

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

Tata 1mg Interview FAQs

How many rounds are there in Tata 1mg Production Analyst interview?
Tata 1mg interview process usually has 4 rounds. The most common rounds in the Tata 1mg interview process are Case Study and Technical.
How to prepare for Tata 1mg Production Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Tata 1mg. The most common topics and skills that interviewers at Tata 1mg expect are Data Analytics, Analytics, SQL, Tableau and Google Analytics.
What are the top questions asked in Tata 1mg Production Analyst interview?

Some of the top questions asked at the Tata 1mg Production Analyst interview -

  1. SQL questions based on jo...read more
  2. Running sum questi...read more

Recently Viewed

INTERVIEWS

Expedia Group

No Interviews

INTERVIEWS

TCS

No Interviews

INTERVIEWS

Lifelong India

No Interviews

DESIGNATION

REVIEWS

Jaika Motors

No Reviews

INTERVIEWS

R.R. Donnelley

No Interviews

INTERVIEWS

Swiggy

No Interviews

JOBS

Urban Company

No Jobs

DESIGNATION

INTERVIEWS

Swiggy

No Interviews

Tell us how to improve this page.

Tata 1mg Production Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Join Tata 1mg We bring you closer to better health

Interview Questions from Similar Companies

Swiggy Interview Questions
3.8
 • 436 Interviews
Udaan Interview Questions
4.0
 • 335 Interviews
Meesho Interview Questions
3.7
 • 329 Interviews
CARS24 Interview Questions
3.6
 • 326 Interviews
Blinkit Interview Questions
3.7
 • 182 Interviews
BlackBuck Interview Questions
3.8
 • 174 Interviews
Paisabazaar.com Interview Questions
3.4
 • 139 Interviews
Urban Company Interview Questions
3.4
 • 134 Interviews
Ninjacart Interview Questions
4.0
 • 94 Interviews
Porter Interview Questions
4.1
 • 84 Interviews
View all
Tata 1mg Production Analyst Salary
based on 6 salaries
₹7 L/yr - ₹18 L/yr
48% more than the average Production Analyst Salary in India
View more details
Team Lead
259 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Executive
255 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Pharmacist
250 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
185 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Executive
144 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Tata 1mg with

PharmEasy

3.7
Compare

Netmeds.com

3.6
Compare

Medlife

3.7
Compare

Practo

3.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview