Meesho Data Analyst interview typically runs 3 rounds: assessment, technical, HR. It usually takes a few weeks and is notably SQL-heavy and structured.
$83K
Avg. Base Comp
$126K
Avg. Total Comp
3
Typical Rounds
2-4 weeks
Process Length
Our candidates report that Meesho is looking for analysts who can move comfortably from query syntax to business reasoning without much hand-holding. The strongest signal across experiences is precision under pressure: the assessment leaned heavily on SQL correctness, and the live discussion stayed practical with joins, self joins, left joins, and window functions like running averages and cumulative sums. This is not the kind of process where broad theory or flashy tooling carries much weight; what matters is whether you can choose the right join, explain why it fits, and write it cleanly when the clock is running.
A recurring theme is that Meesho seems to value people who understand the mechanics behind the answer, not just the final output. Multiple candidates mentioned being pushed on when and why to use a self join versus a left join, which tells us the team is screening for day-to-day analytical judgment. We also saw business and motivation questions woven into the technical conversation, including why Meesho and career aspirations, so the bar is not purely SQL execution. The non-obvious make-or-break here is being able to stay crisp on core analytics patterns while sounding grounded in how you think about marketplace data problems.
Synthesized from 1 candidate report by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Meesho process.
The process felt pretty structured and was mostly SQL-heavy from start to finish. I applied through LinkedIn and first had a technical assessment on Unstop that lasted about 70 minutes. It had three SQL questions across different difficulty levels, and the emphasis was clearly on writing correct queries under time pressure rather than on anything broad or theoretical. The questions I remember most were around window functions, self joins, joins, and more advanced filtering. I also saw pandas mentioned in the broader assessment, but the main focus in my case was SQL syntax and use cases for window functions.
After that came a technical interview with a Data Analyst from the team. It started with a quick intro and then moved straight into joins and window functions, including things like running average and cumulative sum. They also asked about self join and left join, so it was important to be comfortable explaining when and why to use each one, not just writing the query. The round also included some business discussion and behavioral questions, like why Meesho and my career aspirations. Overall, the interviewers were direct and the questions were practical, centered on day-to-day analytics work rather than tricky algorithmic puzzles. The process was described as 3 rounds for me: assessment, technical, and HR, though the HR round was only mentioned as part of the flow and I didn’t get to a positive outcome. I ended up not getting selected, and the only frustrating part was that the process took a while and communication from HR was weak. If you’re preparing, I’d spend most of my time on SQL joins, CTEs, and window functions, especially running totals and cumulative calculations, since that came up repeatedly.
Prep tip from this candidate
Focus on SQL joins, self joins, CTEs, and window functions like running averages and cumulative sums. Also be ready to explain why Meesho and talk through your career goals, since the technical round included those behavioral questions.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Meesho
Write a query to display the top three users by downloads each day
| Question | |
|---|---|
| Identifying User Sessions | |
| Target Indices | |
| Ride-Sharing App Schema | |
| Upsell Carousel | |
| Duplicate Product Names | |
| Evaluating Revenue Decline | |
| Parking Application System Design | |
| Empty Neighborhoods | |
| Rolling Bank Transactions | |
| 2nd Highest Salary | |
| Customer Orders | |
| Comments Histogram | |
| Experiment Validity | |
| Closest SAT Scores | |
| Top Three Salaries | |
| Button AB Test | |
| Monthly Customer Report | |
| First to Six | |
| Compute Deviation | |
| Download Facts | |
| 500 Cards | |
| Random SQL Sample | |
| Subscription Overlap | |
| Longest Streak Users | |
| Bagging vs Boosting | |
| Month Over Month | |
| Raining in Seattle | |
| Prime to N | |
| Decreasing Comments |
Synthesized from candidate reports. Individual experiences may vary.
The process begins with a SQL-heavy assessment on Unstop. Candidates solve three SQL questions of varying difficulty, with a strong emphasis on writing correct queries under time pressure. Topics mentioned include joins, self joins, window functions, advanced filtering, and some pandas exposure.
A technical round with a Data Analyst from the team follows the assessment. The interviewer drills into joins and window functions, including running averages and cumulative sums, and also checks understanding of self joins and left joins. The round includes some business discussion and behavioral questions such as why Meesho and career aspirations.
The interview flow also includes an HR round, though the experience did not reach a positive outcome before this stage. Based on the candidate's account, this appears to be the final step in the process and likely covers general fit and closing discussions.