Question 1

Can you elaborate on your Big Data project experience?

Accepted Answer

**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....

Question 2

Describe the ZS projects you worked on

Accepted Answer

**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....

Question 3

Find All Numbers that Appear at Least Three Times Consecutively

Accepted Answer

**Trick**: ROW_NUMBER() - ROW_NUMBER() OVER (PARTITION BY num) creates constant `grp` for consecutive same nums. Group by num, grp; HAVING COUNT(*) >= 3.

**Logic**: Consecutive same numbers share same (row_num - partition_row_num)....

Question 4

The Stock Span Problem

Accepted Answer

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)....

Question 5

What would you do if a job misses its SLA? How would you handle such situations?

Accepted Answer

**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....

Meesho General Interview Questions

Companies asking these questions

All 5 Questions

More Interview Prep Guides

Get All Answers in PDF Format

Meesho General Interview Questions

Companies asking these questions

All 5 Questions

More Interview Prep Guides

Get All Answers in PDF Format