Zomato SDE -2 interview experience
- Posted
- 12 Feb 2026
Summary
I interviewed for an SDE-2 role at Zomato via referral and was rejected after several technical rounds covering system internals (Redis, Kafka), SQL, and Low-Level Design.
How it went
Zomato Interview Experience | November 2025 | SDE-2
Application Mode: Referral
(They only accept applications via employee referrals.)
Round 1
Redis
- Why is Redis extremely fast?
- How does Redis handle large scale despite being single-threaded?
Kafka
- How can consumer throughput be increased?
- What happens when consumption lags behind production?
SQL
Given: Order state transitions with timestamps
States: Created → Confirmed → Reached Merchant → Reached Customer → Delivered
Questions:
- Write a query to fetch all order IDs with their latest state in the last 1 hour
- Exclude orders that are already delivered
- How would this query behave at scale?
- What indexes would you add?
Low-Level Design - Snake and Food Game
- Design snake movement logic
- Ensure movement happens in O(1)
- Handle food consumption and snake growth
- Explain data structure choices & trade-offs
- Write pseudocode
Result: Rejected
Questions asked (7)
- 01
Redis Performance
Other
Why is Redis extremely fast?
- 02
Redis Scalability (Single-Threaded)
Other
How does Redis handle large scale despite being single-threaded?
- 03
Kafka Consumer Throughput Optimization
Other
How can consumer throughput be increased in Kafka?
- 04
Kafka Consumer Lag Scenario
Other
What happens in Kafka when consumption lags behind production?
- 05
SQL Query for Latest Order State
Data Structures & Algorithms
Given order state transitions with timestamps (States: Created → Confirmed → Reached Merchant → Reached Customer → Delivered), write a query to fetch all order IDs with their latest state in the last 1 hour, excluding orders that are already delivered.
- 06
SQL Query Performance and Indexing at Scale
System Design
How would the SQL query to fetch order IDs with their latest state behave at scale? What indexes would you add?
- 07
Low-Level Design: Snake and Food Game
System Design · Medium
Design the snake movement logic for a Snake and Food Game. Ensure movement happens in O(1). Handle food consumption and snake growth. Explain data structure choices & trade-offs. Write pseudocode.