Meesho Data Engineer Interview Questions (2026)
Prepare for your technical rounds at Meesho with 59+ reported questions across SQL, Apache Spark, Python, and System Design. Compare typical candidate answers against FAANG 9/10 benchmarks, and test your own solutions with instant AI feedback.
Interview Topic Weightage at Meesho
Based on verified interview loopsUnlocked FAANG-Calibrated Answer Rubric (Top 3 Tested Questions)
- •Structured delivery following Problem Formulation -> Execution Plan -> Failure Recovery
- •Concrete parameters: partition keys, join strategies, memory limits, and I/O costs
- •Explicit trade-off evaluation (e.g. storage cost vs query latency, exactly-once overhead)
Complete Meesho Question Vault (56 Questions)
Showing 15 of 56Design a fault-tolerant Spark Streaming checkpoint strategy: what to persist, recovery semantics, and cost/scalability trade-offs with checkpoint frequency.
**Section 1 — The Context (The 'Why')** Spark Streaming fault tolerance requires checkpointing state and offsets. Checkpoint corruption loses replay; too-frequent checkpoints add overhead. **Section 2 — The Diagram** ``` [Source] --> [Stream] --> [Sink] Checkpoint:S3 State:RocksDB ``` **Section 3 — Component Logic** **Checkpoint** stores offsets and metadata to S3/HDFS. On restart, driver replays from last offset. **State store** (RocksDB) backs aggregation state....
Given a streaming dataset from Kafka, how would you ingest the data in real-time using Spark?
Kafka ingestion with Spark Structured Streaming follows a standard pattern: readStream → parse → writeStream with checkpoint. **Architectural decisions**: (1) **startingOffsets**: 'earliest' for backfill, 'latest' for tail-only; use JSON per-partition offsets for exactly-once replay. (2) **Checkpoint**: Mandatory for exactly-once; stores offsets + write metadata; without it, duplicates or data loss on restart....
What are your hobbies or activities you enjoy outside of work?
Outside of work, I enjoy a mix of activities that keep me active, intellectually stimulated, and creatively engaged. I regularly hike and practice yoga, which helps me stay physically and mentally…
What are your key achievements in your career so far?
My key achievements center on significantly enhancing data platform reliability and efficiency, driving substantial cost reductions, and fostering a culture of data quality and team growth. I've led…
What database would you choose for handling transactional and non-transactional data? Why?
Situation: Mixed OLTP and OLAP. Task: Recommend with rationale. Action: Why separate: OLTP needs ACID, low latency; OLAP needs scans, columnar. Polyglot: PostgreSQL/Aurora for OLTP; Snowflake/BigQuery or Delta for OLAP. Sync via CDC. Single-store (CockroachDB) trades off....
What is your ultimate career goal or life goal?
My ultimate goal is to build and lead data engineering initiatives that deliver tangible business value through robust, scalable systems, while fostering a collaborative environment where engineers…
Why do you think Meesho is the right fit for you?
Meesho's dynamic, high growth e commerce environment and its mission to empower small businesses through technology perfectly align with my passion for building scalable, impactful data solutions. I…
Can you elaborate on your Big Data project experience?
**STAR**: **Situation**: Needed to process 50TB monthly; real-time + batch. **Task**: Build scalable pipelines. **Action**: Built Kinesis real-time + Spark batch. S3 data lake. Migrated on-prem to cloud. **Result**: 50TB/mo processed; sub-minute real-time; batch SLA met....
Describe the ZS projects you worked on
**Situation**: At ZS Associates, I joined a healthcare analytics practice where pharmaceutical clients needed unified views of prescription data from IQVIA and internal systems, with HIPAA compliance constraints. **Task**: Design and deliver ETL pipelines supporting patient journey analytics, sales territory optimization, and KPI dashboards for brand managers—translating consultant requirements into production-grade data models....
Find All Numbers that Appear at Least Three Times Consecutively
To find numbers appearing at least three times consecutively, utilize SQL window functions to create a unique group identifier for each sequence of identical, consecutive numbers. Then, filter these…
The Stock Span Problem
Span = consecutive days (incl. today) with price ≤ today. Monotonic stack: store (price, span); for each price, pop smaller elements (sum their spans), push (price, total_span). Python: for p in prices: span=1; while stack and stack[-1][0]<=p: span+=stack.pop()[1]; stack.append((p,span)); res.append(span)....
What would you do if a job misses its SLA? How would you handle such situations?
**Situation:** Job misses SLA. **Immediate:** Alert stakeholders; assess impact. **Triage:** Root cause—contention, data delay, bug. **Mitigate:** Re-run if safe; skip late partitions; accept partial + communicate. **Post-incident:** Document; add monitoring; improve retry/backfill. **Why:** SLAs build trust; breaches need process....
Can you explain the concept of polymorphism and inheritance in Java with examples?
**Inheritance:** Class extends another; inherits fields/methods. `class Dog extends Animal`. **Polymorphism:** Supertype reference → subtype; runtime dispatch. `Animal a = new Dog(); a.eat()` calls Dog's override. **Why:** Extensibility; Liskov Substitution. **Trade-off:** Composition often > inheritance. **Production:** Interfaces for contracts....
Discuss the tech stacks and responsibilities at Morgan Stanley
Morgan Stanley's data engineering leverages a robust tech stack, primarily centered around SQL, Python/Scala, Spark, Kafka, and cloud platforms (AWS/Azure), to build low latency, high integrity data…
Trapping Rain Water - calculate amount of water trapped between array elements
**Why This Problem:** Teaches two-pointer and prefix reasoning. Water at i = min(max_left, max_right) - height[i]. **Approaches:** (1) Precompute max_left, max_right arrays—O(n) time, O(n) space. (2) Two pointers—O(n) time, O(1) space: move from smaller side, track max on that side. Water = max_side - height. **Data Eng Analogy:** 'Valleys' in time-series—local minima between peaks....
Stop Guessing If Your Answers Clear the Bar at Meesho
DataEngPrep’s AI evaluates your real answers against strict FAANG hire rubrics. Check accuracy, optimize shuffle partitions, detect edge case omissions, and receive an instant 9/10 rewrite before stepping into your real interview loop.
Similar Tier Companies Hiring Data Engineers
Explore interview loops with overlapping system design and SQL standards.
Frequently Asked Questions About Meesho Data Engineering Interviews
What topics are asked most frequently in Meesho data engineering interviews?▼
Technical interviews at Meesho heavily emphasize Spark/Big Data and SQL, accounting for the majority of technical questions in our repository of 59+ verified interview questions. Candidates should expect hands-on rounds testing query optimization, data skew mitigation, and end-to-end pipeline architecture.
How deep do Meesho interviewers go on Apache Spark, SQL, and system design?▼
Interviewers at Meesho probe far beyond syntax. They expect candidates to discuss Spark DAG execution plans, shuffle partitions, join selection strategies (broadcast hash vs shuffle sort-merge), and handling un-even data distributions. In system design, emphasis is placed on fault tolerance, backfilling, and SLA preservation under high data volume.
What is the typical technical interview loop format for Data Engineers at Meesho?▼
The Meesho interview process typically consists of: 1) Initial Recruiter Screen (30 mins), 2) Technical Phone Screen focusing on live SQL and data manipulation (45-60 mins), followed by a 4-5 round Virtual Onsite covering SQL & Coding, Distributed Pipeline Architecture, Data Modeling, and a Behavioral/Bar-Raiser session.
How can I practice Meesho data engineer interview questions with AI feedback?▼
You can practice directly on DataEngPrep.tech. Select any question from the Meesho library, submit your answer, and receive an instant FAANG-calibrated evaluation scored across accuracy, technical depth, communication, and completeness, complete with an interview-ready model answer rewrite.