Upload Button Icon Add office photos

Medlife

Compare button icon Compare button icon Compare

Filter interviews by

Medlife Business Analyst Interview Questions and Answers

Updated 28 May 2021

Medlife Business Analyst Interview Experiences

1 interview found

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 questions from similar companies

I applied via LinkedIn and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. How can you reduce the delivery time of the order?
  • Ans. 

    Reducing delivery time can be achieved by optimizing the supply chain, improving communication, and automating processes.

    • Analyze the supply chain and identify bottlenecks

    • Implement automation tools to streamline processes

    • Improve communication between departments and with customers

    • Use data analytics to forecast demand and plan accordingly

    • Consider outsourcing or partnering with third-party logistics providers

    • Invest in tec...

  • Answered by AI
  • Q2. Questions based on Case Studies

Interview Preparation Tips

Interview preparation tips for other job seekers - The process consisted of two rounds. First was the business analysis kind of round which included the questions like how can you reduce the delivery time of the order? The second round was technical round where the person asked the questions on SQL and Excel

I applied via IIM Jobs and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

7 Questions

  • Q1. Advance SQL Questions.
  • Q2. Multiple Approaches in the SQL questions were seen. Some unconventional SQL Syntax was also asked.
  • Q3. Metrics Driven Case studies.
  • Q4. More number of solutions were seen instead of in depth implementation of 1 solution. Good Communication skills is judged.
  • Q5. Tell me something about yourself.
  • Ans. 

    I am a highly motivated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.

    • I have a Bachelor's degree in Business Administration with a focus on analytics.

    • I have experience working with cross-functional teams to gather and analyze business requirements.

    • I am proficient in using tools such as Excel, SQL, and Tableau for data analysis and visualization.

    • I have successfully im...

  • Answered by AI
  • Q6. Why quit last job.
  • Ans. 

    Seeking better growth opportunities and work-life balance.

    • Limited growth prospects in previous role

    • Lack of work-life balance

    • Desire for new challenges and learning opportunities

    • Company culture misalignment

    • Relocation or commute issues

    • Better compensation or benefits elsewhere

  • Answered by AI
  • Q7. Why Meesho.
  • Ans. 

    Meesho is a leading e-commerce platform that empowers individuals to start their own online businesses.

    • Meesho provides a user-friendly platform for individuals to sell products online without any investment.

    • It offers a wide range of products from various categories, allowing sellers to cater to different customer preferences.

    • Meesho provides extensive training and support to its sellers, helping them succeed in their on...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm, It's very similar to any other business analyst interview in industry.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Internshala and was interviewed in Sep 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 tips
Round 2 - Aptitude Test 

Medium difficultty on pandas SQL

Round 3 - One-on-one 

(1 Question)

  • Q1. Coding interview python pandas medium difficulty
  • Ans. Solved it and had to discuss with manager
  • Answered by govind goel

Interview Preparation Tips

Topics to prepare for Paisabazaar.com Business Analyst interview:
  • Python
Interview preparation tips for other job seekers - Prepare pandas
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Selected 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 tips
Round 2 - One-on-one 

(1 Question)

  • Q1. DBMS? Questions from Graduation Project
Round 3 - Technical 

(1 Question)

  • Q1. SQL RDBMS Situational based questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL, Case study, and puzzles.

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL, case study, and Puzzles. That's what I was asked.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Technical 

(1 Question)

  • Q1. More about your role and insurance based questions
Round 2 - Technical 

(1 Question)

  • Q1. More about insurance based and brd, requirements gathering, sdlc
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain about your work as BA in the insurance project
  • Ans. 

    As a BA in the insurance project, I analyzed business requirements, facilitated communication between stakeholders, and ensured project goals were met.

    • Analyzed business requirements to identify gaps and opportunities for improvement

    • Facilitated communication between stakeholders including business users, IT teams, and management

    • Ensured project goals were met by tracking progress, identifying risks, and proposing solutio...

  • Answered by AI
  • Q2. Agile methodologies, SQL knowledge , Insurance domain knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare Insurance terms .
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in May 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 tips
Round 2 - Coding Test 

4 challenges on coderbyte

Round 3 - Technical 

(1 Question)

  • Q1. Joins, windowed function and basic sql queries
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Technical 

(3 Questions)

  • Q1. Business use cases on logistics & last mile delivery??
  • Ans. 

    Business use cases on logistics & last mile delivery

    • Optimizing delivery routes to reduce time and cost

    • Implementing real-time tracking systems for better visibility

    • Using predictive analytics to forecast demand and optimize inventory

    • Implementing automated sorting and packaging systems to improve efficiency

    • Integrating with third-party delivery services to expand reach

    • Implementing customer feedback systems to improve servi

  • Answered by AI
  • Q2. Basic excel functions
  • Q3. Sumifs, pivot tables, Vlookup etc.

Medlife Interview FAQs

How to prepare for Medlife 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 Medlife. The most common topics and skills that interviewers at Medlife expect are Analytics, Business Analysis, Excel, Logistic Regression and Predictive Analytics.

Tell us how to improve this page.

Medlife Business Analyst Salary
based on 22 salaries
₹2 L/yr - ₹8.2 L/yr
52% less than the average Business Analyst Salary in India
View more details
Executive Pharmacist
143 salaries
unlock blur

₹2 L/yr - ₹4 L/yr

Associate Pharmacist
128 salaries
unlock blur

₹2 L/yr - ₹3.8 L/yr

Pharmacist
118 salaries
unlock blur

₹1.8 L/yr - ₹4.2 L/yr

Executive Accountant
62 salaries
unlock blur

₹2.4 L/yr - ₹4.2 L/yr

Team Lead
61 salaries
unlock blur

₹1.4 L/yr - ₹6 L/yr

Explore more salaries
Compare Medlife with

PharmEasy

3.8
Compare

Udaan

3.9
Compare

Swiggy

3.8
Compare

CARS24

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