i
Tata 1mg
Filter interviews by
Clear (1)
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 4 interview rounds.
Case studies based on one of your projects which you had done in your past organisation
How would you approach a problem of auto application of coupon
Brainstorming on a case studies
Top trending discussions
I applied via Naukri.com and was interviewed in Jun 2021. There were 4 interview rounds.
I applied via Approached by Company and was interviewed before Jul 2022. There were 4 interview rounds.
1. Tell me about yourself
2. Estimate the number of hospitals in India
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?
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 ...
I applied via Referral and was interviewed before May 2020. There was 1 interview round.
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...
I applied via Company Website and was interviewed in Aug 2022. There were 2 interview rounds.
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.
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
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
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.
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
I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.
Mostly sql question asked, moderate level
I applied via LinkedIn and was interviewed before Sep 2022. There were 5 interview rounds.
Basic SQL questions
Problem solving case studies, analytics cases
SQL test coding assessment which I am yet to give
based on 1 interview
Interview experience
Team Lead
259
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Executive
255
salaries
| ₹0 L/yr - ₹0 L/yr |
Pharmacist
250
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
185
salaries
| ₹0 L/yr - ₹0 L/yr |
Executive
144
salaries
| ₹0 L/yr - ₹0 L/yr |
PharmEasy
Netmeds.com
Medlife
Practo