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
Backend Engineer
•
Technical
•
medium
Explain how you would optimize a slow-performing SQL query that fetches order history for a user.
#Database Indexing
#Query Execution Plan
#Partitioning
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
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 Scientist
•
Coding
•
medium
Write a SQL query to find the top 3 restaurants in each city based on the number of completed orders in the last 30 days.
#Window Functions
#Aggregations
#Date Functions
Data Scientist
•
Coding
•
hard
Write a SQL query to calculate the week-over-week retention rate of new users who joined in Q1.
#Cohort Analysis
#Self Joins
#Date Manipulation
Data Scientist
•
Coding
•
medium
Write a SQL query to find delivery executives who have a cancellation rate of more than 5% but have completed at least 100 orders.
#Filtering
#Aggregations
#Having Clause
Data Scientist
•
Coding
•
hard
Write a SQL query to calculate the median order value for each user segment (e.g., Swiggy One vs. Non-Swiggy One).
#Percentiles
#Window Functions
#Advanced SQL
Machine Learning Engineer
•
Coding
•
medium
Given an 'orders' table, write a SQL query to find the top 3 most ordered dishes per city in the last 30 days.
#Window Functions
#Aggregation
#Joins
Machine Learning Engineer
•
Coding
•
medium
Write a SQL query to calculate the 7-day rolling average of delivery times for each delivery zone.
#Window Functions
#Date Functions
#Time Series
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.