Meesho

Social commerce (India) · Data Engineering interview

Rigorous SDE-2 DE loop: HackerRank OA, Spark/big-data-dominant rounds, and an e-commerce system design with Kafka streaming.

Cloud / platform

AWS; Spark, Kafka, Delta/warehouse

Reported difficulty

Not reported

SQLPythonSparkKafkaETL

Hiring process

OA (HackerRank, 4 timed sections)

Technical (Spark/big data)

System design

Behavioral

Offer

Round-by-round breakdown

Online Assessment

Medium confidence

HackerRank, 1 hr, 4 timed sections
SQL MCQ + coding (DB management, query optimization, data manipulation)

Spark / Big Data

· dominant categoryHigh confidence

Spark internals, skew/salting, partitioning, broadcast, optimization
PySpark coding

SQL

Medium confidence

Window functions, optimization, dedup over order/clickstream

System & pipeline design prompts

Create a system design for an e-commerce company like Flipkart
ETL design using Spark & Kafka streaming; networking/DB/OS fundamentals

Prep — high priority

Spark/big-data internals + PySpark + optimization (skew/salting)
E-commerce system design + ETL (Spark + Kafka streaming)
SQL optimization (timed OA)

Prep — medium priority

CS fundamentals (networking/DB/OS); Python/DSA
Behavioral

Rejection patterns

Weak Spark/big-data internals (the dominant category)
Poor e-commerce system design
Shaky CS fundamentals

Reported experiences

Data Engineer (SDE-2)

ReportedFirst-hand

OA (HackerRank SQL+coding) → technical (Spark/big data heavy) → system design (e-commerce like Flipkart; ETL w/ Spark+Kafka; networking/DB/OS) → behavioral.

Rehearse for Meesho

Answered questions on what Meesho actually asks — each with the short answer, the answer that gets you rejected, and the follow-up.

Then build one and have it reviewed: design a daily orders pipeline or model a marketplace. No account.

All interview experiences

Openingloading the content…