AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Medlife Business Analyst Interview Questions and Answers
Medlife Business Analyst Interview Experiences
1 interview found
Anonymous
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 ...
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.
It was based on 4 sql questions of medium to hard level and 24 mcqs based on sql,aptitude,excel.
(1 Question)
- Q1. They give you some questions and you have to write sql queries for them
(1 Question)
- Q1. You are given case study and come sql questions based on that
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.
(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
- Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.
Interview Preparation Tips
I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Case study questions based on Logistics & Porter business.
- Q2. More Case study & porter business questions
(2 Questions)
- Q1. Some medium SQL Queries
- Q2. Some medium python codes
(1 Question)
- Q1. Sql questions on advanced concepts
(1 Question)
- Q1. Previous experience and business questions
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
(1 Question)
- Q1. More about your role and insurance based questions
(1 Question)
- Q1. More about insurance based and brd, requirements gathering, sdlc
vivek duggal
(2 Questions)
- Q1. Salary discussion
- Q2. Expected salary vs what they can offer
govind goel
I applied via Internshala and was interviewed in Sep 2023. There were 3 interview rounds.
Medium difficultty on pandas SQL
(1 Question)
- Q1. Coding interview python pandas medium difficulty
- Ans. Solved it and had to discuss with manager
Interview Preparation Tips
- Python
(1 Question)
- Q1. SQL, Case study, and puzzles.
Interview Preparation Tips
I applied via LinkedIn and was interviewed in May 2023. There were 3 interview rounds.
4 challenges on coderbyte
(1 Question)
- Q1. Joins, windowed function and basic sql queries
Medlife Interview FAQs
Tell us how to improve this page.
Medlife Interviews By Designations
- Medlife Associate Pharmacist Interview Questions
- Medlife Pharmacist Interview Questions
- Medlife Senior IT Support Engineer Interview Questions
- Medlife Accounts & Finance Executive Interview Questions
- Medlife Associate Interview Questions
- Medlife Business Analyst Interview Questions
- Medlife Customer Support Executive Interview Questions
- Medlife Data Entry Operator Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
|
Executive Pharmacist
143
salaries
|  ₹2 L/yr - ₹4 L/yr |
|
Associate Pharmacist
130
salaries
| ₹2 L/yr - ₹3.8 L/yr |
|
Pharmacist
126
salaries
| ₹1.8 L/yr - ₹4.2 L/yr |
|
Team Lead
65
salaries
| ₹1.2 L/yr - ₹6 L/yr |
|
Executive Accountant
62
salaries
| ₹2.4 L/yr - ₹4.2 L/yr |
PharmEasy
Netmeds.com
Tata 1mg
Practo
- Home >
- Interviews >
- Medlife Interview Questions >
- Medlife Business Analyst Interview Questions
