Upload Button Icon Add office photos
Engaged Employer

i

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

Meesho Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Meesho Business Analyst Interview Questions, Process, and Tips

Updated 8 Jan 2025

Top Meesho Business Analyst Interview Questions and Answers

View all 12 questions

Meesho Business Analyst Interview Experiences

43 interviews found

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

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

Round 1 - Assignment 

SQL based coding round (Online Assignment)

Round 2 - Technical 

(1 Question)

  • Q1. SQL query to print gold members of zomato
  • Ans. 

    SQL query to print gold members of zomato

    • Use SELECT statement to retrieve data from the database

    • Filter the results using WHERE clause to only include gold members

    • Specify the table and column names where the membership status is stored

    • Example: SELECT * FROM zomato_members WHERE membership_type = 'gold'

  • Answered by AI

Skills evaluated in this interview

Business Analyst Interview Questions & Answers

user image Sumedh Gajghate

posted on 14 Oct 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at National Institute of Technology (NIT), Rourkela and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Conceptual sql queries

Round 2 - HR 

(2 Questions)

  • Q1. Introduction tell me about your self
  • Ans. 

    Experienced business analyst with a background in data analysis and process improvement.

    • Over 5 years of experience in analyzing business processes and identifying areas for improvement

    • Skilled in data analysis tools such as Excel, SQL, and Tableau

    • Strong communication skills, able to effectively communicate with stakeholders to gather requirements

    • Certified in Business Analysis Professional (CBAP)

    • Previous projects include...

  • Answered by AI
  • Q2. Why do you want to join our company
  • Ans. 

    I am impressed by your company's innovative approach and strong reputation in the industry.

    • I admire the company's commitment to innovation and cutting-edge technology

    • I am drawn to the company's strong reputation and track record of success

    • I believe that the company's values align with my own professional goals and aspirations

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice sql concepts thoroughly

Business Analyst Interview Questions Asked at Other Companies

asked in Evalueserve
Q1. You have 10 boxes of balls (each ball weighing exactly10 gm) with ... read more
asked in Infosys
Q2. What is your strong point in terms of technical knowledge? Like J ... read more
Q3. There are 100 people standing in a circle, the first person has a ... read more
asked in Paytm
Q4. Sum of Squares of First N Natural Numbers Problem Statement You a ... read more
asked in EXL Service
Q5. If I have 333 digits to number pages of a book, How many pages ca ... read more
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Aug 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 

HackerRank OA on SQL. 3 questions, 1 Hour with webcam proctoring.

Question 1:
"""
1. The Good and The Bad City

There is a blood bank which maintains two tables: DONOR that contains information on the people who are willing to donate blood and ACCEPTOR, the people who are in need of blood. The bank wants to conduct a survey and find out the city that has the best and the worst donor sum amount/acceptor sum amount ratio. Both ratios are unique. That is, exactly one city has the best ratio and exactly one city has the worst ratio.
The donor sum amount is the total amount of blood, regardless of blood group, that people are ready to donate. The acceptor sum amount is the total amount of blood needed by that city.
There must be exactly two rows that denote the best and the worst ratios. The order of the rows does not matter. Each row must contain the following attributes:

1. The city's name (CITY).
2. The ratio ( donor sum amount / acceptor sum amount ), correct to 4 decimal places.

The schema of the two tables is given below:
Schema
DONOR
Name Type Description
ID Integer It is the ID of the donor.
NAME String It is the name of the donor.
GENDER Character It is the gender of the donor.
CITY String It is the city where the donor lives.
BLOOD_GROUP String It is the blood group of the donor.
AMOUNT Integer It is the amount of blood in pints, which the donator can donate.
ACCEPTOR
Name Type Description
ID Integer It is the id of the acceptor.
NAME String It is the name of the acceptor.
GENDER Character It is the gender of the acceptor.
CITY String It is the city where the acceptor lives.
BLOOD_GROUP String It is the blood group of the acceptor.
AMOUNT Integer It is the amount of blood in pints, which the acceptor needs.
Sample Data Tables
DONOR
ID NAME GENDER CITY BLOOG_GROUP AMOUNT
1 MARIA F Warne, NH AB+ 7
2 DOROTHY F East Natchitoches, PA AB+ 3
3 CHARLES M East Natchitoches, PA A- 6
4 DOROTHY F East Natchitoches, PA AB+ 9
5 MICHAEL M Warne, NH A+ 1
ACCEPTOR
ID NAME GENDER CITY BLOOG_GROUP AMOUNT
1 LINDA F Warne, NH A+ 9
2 CHARLES M Warne, NH AB+ 8
3 RICHARD M East Natchitoches, PA AB+ 3
4 LINDA F East Natchitoches, PA A+ 1
5 PATRICIA F Warne, NH A+ 5

Sample Output

East Natchitoches, PA 4.5000
Warner, NH 0.3636



Explanation

The amount of blood available for donation in East Natchitoches, PA is 3 + 6 + 9 = 18.

The amount of blood needed in East Natchitoches, PA is 3 +1 = 4.

Hence, the ratio is = ( 18 : 4 ) = 4.5000.

The amount of blood available for donation in Warne, NH is 1 + 7 = 8.

The amount of blood needed in Warne, NH is 9 + 8 + 5 = 22.

Hence, the ratio is = ( 8 : 22 ) = 0.3636.
"""

Question 2:
"""
2. Maximum Discount Product

A department store maintains data on customers, products, and purchase records in three tables: CUSTOMER, PRODUCT, and PURCHASE. The store manager wants to know which product is on maximum discount for each category. Write a query to print the following fields for each category, ordered by category, ascending: category, product ID and discount for the product that has the maximum discount in the category. In the case of multiple products having same maximum discount within a category, print the product with minimum product_id.


Table Schema
CUSTOMER
Name Type Description
CUSTOMER_ID Integer A customer's ID in the inclusive range [1, 500]. This is a primary key.
CUSTOMER_NAME String A customer's name. This field contains between 1 and 100 characters (inclusive).
CITY String A city name. This field contains between 1 and 50 characters (inclusive).
STATE String A state name. This field contains between 1 and 50 characters (inclusive).


PRODUCT
Name Type Description
PRODUCT_ID Integer A product's ID in the inclusive range [1, 500]. This is a primary key.
PRODUCT_NAME String A product's name. This field contains between 1 and 50 characters (inclusive).
CATEGORY String A category name of the product. This field contains between 1 and 50 characters (inclusive).
PRICE Integer The price of the product in the inclusive range [500, 1000].
DISCOUNT Integer The discount associated with the product in the inclusive range [5, 20].
AVAILABLE Integer The availability of a product. It is 1 if the product is available or it is 0 if the product is not available.

PURCHASE
Name Type Description
ID Integer An id associated with a purchase that is done in the inclusive range [1, 1000]. This is a primary key.
CUSTOMER_ID Integer A customer ID. This is a foreign key to customer.customer_id.
PRODUCT_ID Integer A product ID. This is a foreign key to product.product_id.
PURCHASE_DATE Date The date associated with a purchase. The date falls in the range '2000-01-01' to '2000-12-31' (inclusive).
'
Sample Case 0

Sample Input for Custom Testing
CUSTOMER
CUSTOMER_ID CUSTOMER_NAME CITY STATE
1 Pickett Wilhelm Park SD
2 Pickett Ipswich AZ
3 Poole Farwell KS
4 Pollard Bent Pine WV
5 Phelps Momford Landing VA


PRODUCT
PRODUCT_ID PRODUCT_NAME CATEGORY PRICE DISCOUNT AVAILABLE
1 P-1 C-5 720 10 1
2 P-2 C-1 935 17 1
3 P-3 C-2 588 19 1
4 P-4 C-4 619 5 0
5 P-5 C-1 803 16 1


PURCHASE
ID CUSTOMER_ID PRODUCT_ID PURCHASE_DATE
1 5 5 2000-06-04
2 1 5 2000-11-24
3 1 3 2000-10-02
4 5 1 2000-08-06
5 5 3 2000-06-22
6 3 1 2000-06-30
7 2 5 2000-01-10
8 2 1 2000-07-26
9 3 5 2000-09-23
10 4 5 2000-09-02
11 3 2 2000-05-25



Sample Output

C-1 2 17
C-2 3 19
C-4 4 5
C-5 1 10

Explanation

By referring to the sample data above, we find that:

For category C-1, there are two products P-2 and P-5 with discount 17 and 16 respectively. So the maximum discount is for product P-2 which is 17.
For category C-2, there is only one product P-3 with discount 19, so this is the product with maximum discount in this category.
For category C-4, there is only one product P-4 with discount 5, so this is the product with maximum discount in this category.
For category C-5, there is only one product P-1 with discount 10, so this is the product with maximum discount in this category.
"""

Question 3:
"""
3. Increase in Population

You are provided with the records of births and deaths during the course of years. Their records consist of a year and a type, either 'birth' or 'death'. Determine the year(s) when the population is highest versus the starting population. Return the year and the amount of the increase in population. If there is a tie, return the earliest of them.


Schema

You are provided 1 table: records.
records
Name Type Description
id int The unique id of a record.
type char(5) The type of record (birth/death).
year int The year in which the birth/death happened.
Sample Data Tables
records
id type year
2187 birth 2002
9941 death 2001
4361 birth 2003
6477 death 2001
3478 birth 2005
9719 death 2005
7292 birth 2002
4931 death 2005
5833 birth 2002
9379 death 2001
3472 birth 2003
5580 death 2003
4472 birth 2002
5915 death 2004
2624 birth 2003
5223 death 2005
7198 birth 2002
5384 death 2001
7660 birth 2004
5302 death 2005
5192 birth 2003
2537 death 2003
5260 birth 2003
7218 death 2004
2726 birth 2002
3856 death 2002
6594 birth 2003
9013 death 2005
4657 birth 2001
1782 death 2005
9744 birth 2004
5149 death 2001
2054 birth 2003
7423 death 2003
7156 birth 2002
2956 death 2001
3273 birth 2001
3721 death 2002
9756 birth 2002
6632 death 2003


OUTPUT
year count
2003 5


Explanation
year count cumulative
2001 -4 -4
2002 6 2
2003 3 5
2004 0 5
2005 -5 0

The highest cumulative increase in population is in the years 2003 and 2004. Return the earlier of the two, so the output is:
2003 5
"""

Round 3 - Technical 

(1 Question)

  • Q1. No further communication received

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL, joins, advanced sql
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Coding Test 

HackerRank Test - 3 questions
SQL - Window functions and Joins

Round 2 - Technical 

(1 Question)

  • Q1. SQL - Joins, window functions and stored procedure

Meesho interview questions for designations

 Senior Business Analyst

 (5)

 Business Process Analyst

 (1)

 Lead Business Analyst

 (1)

 Business Intelligence Analyst

 (1)

 Analyst

 (1)

 Business Associate

 (2)

 Data Analyst

 (9)

 Quality Analyst

 (2)

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Coding Test 

2 SQL error detection MCQ and 1 SQL coding question

Round 2 - One-on-one 

(1 Question)

  • Q1. 3 SQL questions. 2 queries and 1 fundamental question on Joins

Get interview-ready with Top Meesho Interview Questions

Business Analyst Interview Questions & Answers

user image Kumari Deeksha

posted on 19 Oct 2024

Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at Malviya National Institute of Technology (NIT), Jaipur and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Coding Test 

25 mcq, 3 sql queries, 90min

Interview Preparation Tips

Topics to prepare for Meesho Business Analyst interview:
  • SQL

Business Analyst Jobs at Meesho

View all
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Oct 2023.

Round 1 - Coding Test 

3 questions of SQL Coding

Round 2 - Technical 

(1 Question)

  • Q1. Topics of SQL and little bit of Excel and tableau
Round 3 - Technical 

(1 Question)

  • Q1. This is the interview with Analytics director and 2 business cases were asked.
Round 4 - HR 

(1 Question)

  • Q1. Little business case and usual HR interview
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - Coding Test 

SQL, Hackerank,CTEs, Window functions , mcq

Round 2 - Coding Test 

SQL,Probability,Python

Round 3 - Case Study 

Orders at amazon down, find the root cause analysis

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

I applied via Company Website and was interviewed in Sep 2023. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. SQL - BASIC TO ADVANCE
Round 3 - Technical 

(1 Question)

  • Q1. SQL BASED QUESTIONS WERE TO SOLVED IN THE INTERVIEW, WHERE THE QUESTIONS WERE GIVEN BY INTERVIEWER.
Round 4 - Case Study 

CASE STUDY ( BUSINESS RELATED PROBLEM + TECHNICAL)

Round 5 - One-on-one 

(1 Question)

  • Q1. BEHAVIORAL ROUND
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Screening round 

(1 Question)

  • Q1. Strategy for marketing for new product launch
  • Ans. 

    Utilize a mix of digital and traditional marketing strategies to create buzz and reach target audience effectively.

    • Conduct market research to understand target audience and competition

    • Develop a comprehensive marketing plan including online advertising, social media campaigns, PR efforts, and events

    • Utilize influencers and brand ambassadors to generate excitement and credibility

    • Offer exclusive promotions or discounts to ...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Meesho Business Analyst interview:
  • Strategy
Interview preparation tips for other job seekers - Be prepared with your current experience and have strategy for a scenario for new product launch.

Meesho Interview FAQs

How many rounds are there in Meesho Business Analyst interview?
Meesho interview process usually has 2-3 rounds. The most common rounds in the Meesho interview process are Technical, Coding Test and One-on-one Round.
How to prepare for Meesho 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 Meesho. The most common topics and skills that interviewers at Meesho expect are SQL, Business Analysis, Python, Statistics and Strategic Planning.
What are the top questions asked in Meesho Business Analyst interview?

Some of the top questions asked at the Meesho Business Analyst interview -

  1. Describe different types of jo...read more
  2. Number of returns have increased, find possible reasons for ...read more
  3. what is the Output in rows if two tables joined using various jo...read more
How long is the Meesho Business Analyst interview process?

The duration of Meesho Business Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Meesho Business Analyst Interview Process

based on 42 interviews

3 Interview rounds

  • Coding Test Round
  • Technical Round - 1
  • Technical Round - 2
View more
Meesho Business Analyst Salary
based on 190 salaries
₹8 L/yr - ₹23 L/yr
62% more than the average Business Analyst Salary in India
View more details

Meesho Business Analyst Reviews and Ratings

based on 31 reviews

3.6/5

Rating in categories

3.6

Skill development

3.3

Work-life balance

4.0

Salary

3.2

Job security

3.7

Company culture

3.3

Promotions

3.5

Work satisfaction

Explore 31 Reviews and Ratings
Business Analyst

Bangalore / Bengaluru

3-5 Yrs

Not Disclosed

Explore more jobs
Key Account Manager
741 salaries
unlock blur

₹3 L/yr - ₹6.9 L/yr

City Manager
205 salaries
unlock blur

₹4 L/yr - ₹10 L/yr

Business Analyst
190 salaries
unlock blur

₹8 L/yr - ₹23 L/yr

Business Development Manager
172 salaries
unlock blur

₹3 L/yr - ₹7.5 L/yr

Team Lead
166 salaries
unlock blur

₹1.6 L/yr - ₹9 L/yr

Explore more salaries
Compare Meesho with

Amazon

4.1
Compare

Flipkart

4.0
Compare

Myntra

4.0
Compare

GlowRoad

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