Meesho Business Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 134 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Meesho.
Meesho
Business Analyst
Entry Easy Positive experience No offer 3 rounds
Interview process
Take home Technical screen Onsite
Interview formats
Technical Coding Case
So it was an on campus hiring drive, first we had this online assessment, which had 7 SQL Questions and a few aptitude questions (MCQs) and the ones who got shortlisted for the technical interview were the ones who did 4+ SQL Questions correctly. The technical interview depends a lot on your interviewer - mostly SQL Based (Queries+Theory) and RCA. After this Round there was another Interview round where we were asked Guesstimates, RCA and Advanced Queries.
Confirmed questions3 questions
- What is the difference between UNION and UNION ALL?
- What's the difference between UNION and JOINs?
- If you had to find the top 3 products by category from the meesho products table, how would you write the query?
Meesho
Business Analyst
Mid Difficult Positive experience No offer 2 rounds
Interview process
Technical screen Technical screen
Interview formats
Technical Behavioral Case
The interview had 2 rounds. The first was a technical round focusing heavily on SQL, asking questions of a good level. Leetcode easy problems might be enough practice for it. The second round involved a Root Cause Analysis scenario related to E-commerce profits and revenue, which was easier than the first. The recruiter emphasized that strong SQL skills are crucial for this role.
Confirmed questions6 questions
- Could you tell me about your resume, including projects and internships?
- Can you answer questions about SQL joins?
- How would you apply CTE logic?
Meesho
Lead Business Analyst
Lead Difficult Negative experience No offer 3 rounds
Interview process
Technical screen Technical screen Onsite
Interview formats
Technical Case
I interviewed for the Lead Business Analyst role. I got through all 3 rounds and the hiring manager gave positive feedback, saying HR would move my profile forward. Then, after following up, I heard the feedback wasn't positive from the final round. I don't get what they're looking for. This is the second time in 5 months I've been left hanging after clearing all rounds. The process was: R1 was technical with SQL and case studies in an hour. R2 was problem-solving with a case on real business problems Meesho is working on. R3 was with the hiring manager, a deep dive case on Meesho's real business problems. I'm disappointed because it seemed to go well and I got positive feedback, yet I was rejected twice. I'd advise looking elsewhere rather than wasting time interviewing with Meesho. Hope this helps.
Confirmed questions6 questions
- Tell me about your past projects.
- SQL questions were asked.
- Case study questions were asked.
Meesho Business Analyst Interview Questions
Quoted word for word from Meesho interview reports.
“From the orders table, what is the SQL query to find the highest spending custID for each city?”
Read reports →“What would be the number of rows in the output table when joining two identical tables, each having 4 rows and one column?”
Read reports →“What is your guesstimate for the number of people flying out of BLR airport on a daily basis?”
Read reports →“Can you write a SQL query that takes numbers 1, 2, 3, 4 as input and outputs them repeated based on their value, like 1, 2 2, 3 3 3, 4 4 4 4?”
Read reports →“How can you determine which of two given columns represents the primary key? Please provide the SQL query.”
Read report →“Can you write an SQL query to find the fraction of orders that are returned out of all orders?”
Read report →“Could you write a SQL query to retrieve the approximate home address pincode based on placed orders?”
Read report →“Using the RANK function, how would you retrieve a specific set of columns for a group?”
Read report →“If you had to find the top 3 products by category from the meesho products table, how would you write the query?”
Read report →Formats, difficulty and experience
Across all 134 Meesho interview reports.