Swiggy
Leading Indian food delivery aggregator with complex real-time logistics.
4 Rounds
~15 Days
Hard
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Data Engineer
•
Technical
•
medium
Write a SQL query to find the top 3 restaurants by order volume in each city for the last 30 days.
#Window Functions
#Aggregations
#Ranking
Data Engineer
•
Technical
•
hard
Given an orders table, write a SQL query to calculate the 7-day rolling average of order values for each user.
#Window Functions
#Time Series
#Moving Averages
Data Engineer
•
Technical
•
hard
Write a query to find delivery partners who have delivered more than 5 orders consecutively without any cancellations.
#Gaps and Islands
#Window Functions
#Conditional Logic
Data Engineer
•
Technical
•
medium
For Swiggy Instamart, write a query to find items that went out of stock within 1 hour of being restocked.
#Self Joins
#Datetime Manipulation
#Event Logs
Data Engineer
•
Technical
•
hard
Write a SQL query to find the percentage of users who placed a second order within 7 days of their first order.
#Cohort Analysis
#Self Joins
#Window Functions
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.