Expect a pipeline round on computing supplier catalogue-quality scores from listing, order, and return events while handling high return rates that skew the signal, a SQL round on fastest-growing suppliers per category month-over-month with volume thresholds, and a platform round on a cost-efficient data stack where controlling warehouse and compute spend is a hard constraint. Interviewers reward reasoning about noisy-signal handling, window-function growth metrics, and partition pruning and storage-format cost trade-offs over throwing compute at the problem. Ground answers in real marketplace analytics.
Recruitment process
- Recruiter screen and technical pre-screen
- SQL and data-manipulation round
- Scoring pipeline and cost-efficient platform round
- Hiring-manager and behavioural round, then offer
Interview rounds
- Round 1 (45-60 min): SQL round on growth metrics and threshold filtering
- Round 2 (60 min): scoring pipeline round with noisy-signal handling
- Round 3 (45-60 min): cost-efficient data-platform design round
- Round 4 (45 min): behavioural and hiring-manager round
Score and economise framework
- Build multi-event scoring pipelines robust to noisy signals, compute growth metrics in SQL with thresholds, and design a genuinely cost-efficient data platform
Practice questions
- 01Practise
Design a pipeline that computes supplier catalogue-quality scores from listing, order, and return events. How do you handle high return rates skewing the signal?
IntenseMeesho data-engineer rounds probe multi-event scoring pipelines and handling of noisy signals like returns in a social-commerce context. - 02Practise
Write SQL to find, per category, the suppliers whose order volume grew fastest month-over-month, excluding suppliers with fewer than 100 orders.
StandardMeesho tests window-function growth metrics with LAG and threshold filtering for supplier analytics. - 03Practise
How would you design a cost-efficient data platform for a value-focused marketplace where controlling warehouse and compute spend is a hard constraint?
StandardMeesho is cost-conscious; rounds probe partition pruning, storage-format choices, and compute-cost trade-offs in platform design. - 04Practise
Design a model to rank supplier listings for a value-conscious shopper where price sensitivity is high. How do you balance relevance, price, and quality?
IntenseMeesho data-scientist rounds test ranking under multiple objectives: relevance, price sensitivity, and quality signals for a value marketplace. - 05Practise
You want to reduce returns without hurting orders. Frame this as an ML and experimentation problem end to end.
StandardMeesho probes problem framing tied to a real cost (returns) with a guardrail (orders), plus sound experiment design. - 06Practise
Explain how you'd evaluate a recommendation model offline when you only have logged data from the current production model (selection bias).
IntenseMeesho data-scientist rounds probe off-policy evaluation and selection bias in logged recommendation data.
