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

Tata 1mg Senior Business Analyst Interview Questions and Answers

Updated 11 Jun 2024

Tata 1mg Senior Business Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - Coding Test 

SQL and Tableau were asked. 4 questions each.

Round 2 - Case Study 

Case study was asked related to covid

Interview Preparation Tips

Topics to prepare for Tata 1mg Senior Business Analyst interview:
  • SQL
  • Tableau
  • Excel
Interview preparation tips for other job seekers - easy interview round. easy to crack. be confident and present in the interview.

Interview questions from similar companies

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
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Salary discussion
  • Q2. Expected salary vs what they can offer

I applied via Naukri.com and was interviewed in Oct 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How do u rate yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest to the recruiter that's it
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via IIM Jobs and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

SQL + Python based questions

Round 2 - Technical 

(2 Questions)

  • Q1. More SQL + simple aptitude problems
  • Q2. Questions on joins, group by etc. Other questions on average speed, guesstimates.
Round 3 - Case Study 

A data set was given and the questions were asked around strategies to handle cancellations.

Interview Preparation Tips

Topics to prepare for Practo Business Analyst interview:
  • SQL
  • Case Studies
Interview preparation tips for other job seekers - Focus on SQL and problem solving.

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 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

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

SQL test coding assessment which I am yet to give

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

Tata 1mg Interview FAQs

How many rounds are there in Tata 1mg Senior Business Analyst interview?
Tata 1mg interview process usually has 2 rounds. The most common rounds in the Tata 1mg interview process are Coding Test and Case Study.
How to prepare for Tata 1mg Senior Business 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 Python, SQL, Advanced Excel, Analytics and Data Analytics.

Tell us how to improve this page.

Tata 1mg Senior Business Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Join Tata 1mg We bring you closer to better health
Tata 1mg Senior Business Analyst Salary
based on 19 salaries
₹13 L/yr - ₹19 L/yr
8% more than the average Senior Business Analyst Salary in India
View more details

Tata 1mg Senior Business Analyst Reviews and Ratings

based on 2 reviews

3.2/5

Rating in categories

2.5

Skill development

1.5

Work-life balance

3.0

Salary

5.0

Job security

3.2

Company culture

3.2

Promotions

2.5

Work satisfaction

Explore 2 Reviews and Ratings
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