HackerRank, 1 hr, 4 timed sections
Out loud, in order: clarify, build it, check it, explain it.
Loadingone moment…
Data engineering interview · Commerce, Travel & Marketplaces
Rigorous SDE-2 DE loop: HackerRank OA, Spark/big-data-dominant rounds, and an e-commerce system design with Kafka streaming.
01
And what its data engineers work with.
02
Stages in the order candidates meet them.
5 stages. 3 rounds have reported questions, described below.
03
The topics it covers and the questions candidates reported.
2 reported questions. See them below
dominant category
High confidence2 reported questions. See them below
1 reported question. See them below
04
By round. Questions marked Expected are written from the company's standards.
Online AssessmentMedium confidence
Spark / Big DataHigh confidence
SQLMedium confidence
Nobody reported these exact questions at Meesho. They are the questions a loop for each of its top topics is known to ask, so prepare for them as likely, not as confirmed.
05
Ranked by how much of the evidence points at each topic.
06
Do the first group before the second.
Spark/big-data internals + PySpark + optimization (skew/salting)
Do first (3)E-commerce system design + ETL (Spark + Kafka streaming)
SQL optimization (timed OA)
CS fundamentals (networking/DB/OS); Python/DSA
ThenBehavioral
07
Why candidates were turned down, as reported.
Weak Spark/big-data internals (the dominant category)
Spark is named in 25 of 50 company accounts.Poor e-commerce system design
Design is named in 27 of 50 company accounts.Shaky CS fundamentals
08
3 reported, 2 composite. Each opens and closes. Composites are labelled.
An online HackerRank test with SQL and coding, a technical round heavy on Spark and big data, a design round (an e-commerce system like Flipkart, an ETL with Spark and Kafka, networking, databases and operating systems) and a behavioral round.
What to take from it Prepare for Spark depth and some computer science basics.
Round one was SQL and Spark coding, run by an outside agency. Round two covered SQL, data modeling and Spark basics and internals, also through the agency.
What to take from it Expect the first rounds to be run by a partner agency.
Round three was Spark coding and internals with a Meesho panel. Round four was with the hiring manager: a deep talk on a recent project plus behavioral questions. The candidate felt strong in the technical rounds, but said a weaker manager round led to lower base pay.
What to take from it Do not relax in the manager round. It can affect pay.
Composite walkthroughs. Built from the company's documented loop, not from one person's account.
This is a composite, not one person's account. It is built from the loop we have on record for Meesho. Questions reported for this round: HackerRank, 1 hr, 4 timed sections; SQL MCQ + coding (DB management, query optimization, data manipulation).
What to take from it Practise these questions before you reach this round.
This is a composite, not one person's account. It is built from the loop we have on record for Meesho. dominant category. Questions reported for this round: Spark internals, skew/salting, partitioning, broadcast, optimization; PySpark coding.
What to take from it Practise these questions before you reach this round.
Spark/big-data depth dominates; system design is e-commerce-flavored.
09
Their reported questions, one at a time, against a stopwatch.
HackerRank, 1 hr, 4 timed sections
Out loud, in order: clarify, build it, check it, explain it.
10
Pick your level and the weeks you have.
Built from what Meesho asks, strongest first. For the wider basics at your level, follow the Mid level plan alongside it.
Spark and big data
Read: Spark chaptersDrill: Spark playgroundSay it aloud: Spark questionsFull plan: Ace the Spark round
Python and coding
Read: Python chaptersDrill: Python practiceSay it aloud: Python questionsFull plan: Ace the Python round
Cloud and tools
Pipeline and system design
Read: Data pipeline chaptersDrill: Pipeline practiceSay it aloud: Data pipeline questionsFull plan: Ace the pipeline round
Behavioral and communication
Read: Behavioral storytellingSay it aloud: Behavioral questions
Rehearse the Meesho loop
Run the question deckThen repeat your weakest topic once more.