Meesho Data Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 17 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Meesho.
Meesho
Data Analyst
Entry Easy Positive experience No offer 1 round
Interview process
Technical screen
Interview formats
Technical Coding
The technical round focused exclusively on SQL. Questions covered various join types and their distinctions, the difference between lag and lead functions, and the differences between row number, rank, and dense rank.
Confirmed questions4 questions
- Could you explain the difference between the Lag and Lead functions?
- What are the different types of joins, and how do they differ from each other?
- Using a table with department_id, employee gender, and salary, determine which gender earns more within each department.
Meesho
Data Analyst
Mid Average Positive experience No offer 1 round
Interview process
Recruiter call Technical screen
Interview formats
Technical Coding
It was a good experience, focusing on SQL concepts like window functions, joins, and CTEs. They started with my introduction and then moved on to joins, followed by questions on window functions. Overall, it was a positive experience.
Confirmed questions4 questions
- Can you explain a self join?
- What is a left join?
- Describe window functions, such as calculating a running average.
Meesho
Data Analyst
Lead Average Negative experience No offer 3 rounds
Interview process
Technical screen Technical screen Take home
Interview formats
Coding Coding Case
The interview process included 3 rounds before I was ghosted. The first round was an online assessment with SQL questions. The second round was a live SQL interview. The third round involved a case study and problem-solving.
Confirmed questions3 questions
- Three SQL questions were asked, one of which was particularly good.
- Root cause analysis for the increase in returns.
- Figure out the reasons behind the rising returns.
Meesho Data Analyst Interview Questions
Quoted word for word from Meesho interview reports.
“What is the order of execution for SQL statements?”
Read reports →“Write a SQL query using rank and window functions.”
Read reports →“What is a left join?”
Read reports →“What are the different types of joins, and how do they differ from each other?”
Read reports →“Describe window functions, such as calculating a running average.”
Read report →“Could you explain the difference between the Lag and Lead functions?”
Read report →“Write a basic SQL query that uses three tables.”
Read report →“Can you write a query to calculate the customer retention rate from one month to the next?”
Read report →“Explain window functions, like cumulative sum.”
Read report →Formats, difficulty and experience
Across all 17 Meesho interview reports.