Swiggy interview experience Real time questions & tips from candidates to crack your interview
Business Analyst
Swiggy
2 rounds | 2 Coding
problems
Selected Interview preparation journey
Preparation
Duration: 3 months
Topics: Data Structures, Algorithms, System Design, Aptitude, OOPS, Database and SQL
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Prepare well for SQL, you have to be strong in SQL.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Application process
Where: Campus
Eligibility: Above 7 CGPA
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
Interview rounds
01
Round
Easy
Video Call
Duration60 minutes
Interview date3 Mar 2021
Coding problem2
Prepare well for SQL, you have to be strong in SQL. Questions related to SQL and A/B testing were asked.
1. DBMS Question
Write SQL query to find mean waiting period for delivery partner given driver Id, ordered time and delivered time.
Problem approach
We need to find the difference of delivered time and ordered time and calculate the average by grouping on the basis of driver ID. So, the SQL query can be written as :
SELECT ID, AVG(DeliveredTime – OrderedTime)
FROM Table
Group by ID
2. DBMS Question
Write query for rolling sum.
Problem approach
If the table given has the following columns: ID | Val
Then to calculate cumulative sum, the following sql query can be written:
SELECT ID, Val, SUM(Val) OVER(ORDER BY ID ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RollSum
FROM TABLE
ORDER BY ID
02
Round
Medium
Video Call
Duration45 minutes
Interview date5 Nov 2021
Coding problem0
This was a case study round. A case study about how to increase sales in particular area was given. Then on the basis of the case study , few questions were asked.
1. What are the metrics that effect sales
2. Steps involved in analysis of decrease in sales for particular area
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
To make an AI less repetitive in a long paragraph, you should increase:
Choose another skill to practice
Similar interview experiences
SDE - 1
4 rounds | 9 problems
Interviewed by Swiggy
Selected 
2420 views
0 comments
0 upvotes
SDE - 1
4 rounds | 7 problems
Interviewed by Swiggy
Selected 1992 views
1 comments
0 upvotes
SDE - 1
3 rounds | 10 problems
Interviewed by Swiggy
Selected 1517 views
0 comments
0 upvotes
Business Analyst
2 rounds | 4 problems
Interviewed by Swiggy
Rejected
301 views
0 comments
0 upvotes
Companies with similar interview experiences
Business Analyst
3 rounds | 8 problems
Interviewed by Paytm (One97 Communications Limited)
Selected 1165 views
1 comments
0 upvotes
Business Analyst
3 rounds | 5 problems
Interviewed by Paytm (One97 Communications Limited)
Selected 1314 views
0 comments
0 upvotes