Upload Button Icon Add office photos

Swiggy

Compare button icon Compare button icon Compare

Filter interviews by

Swiggy Business Analyst Interview Questions and Answers

Updated 21 May 2025

18 Interview questions

A Business Analyst was asked 4mo ago
Q. What improvements would you suggest for Swiggy, and what metrics would you use to measure and evaluate them?
Ans. 

Enhancing Swiggy's user experience and operational efficiency through targeted improvements and measurable metrics.

  • Improve delivery time: Measure average delivery time and set a target to reduce it by 15% over the next quarter.

  • Enhance customer support: Track response time and resolution rate of customer queries, aiming for a 90% satisfaction score.

  • Expand restaurant partnerships: Monitor the number of new restauran...

A Business Analyst was asked 8mo ago
Q. How do you handle outliers?
Ans. 

Outliers can be handled by identifying, analyzing, and deciding whether to remove or adjust them based on their impact on the analysis.

  • Identify outliers using statistical methods like Z-score, IQR, or visualization techniques like box plots.

  • Analyze the outliers to understand if they are due to errors in data collection or represent true anomalies.

  • Decide whether to remove outliers if they are errors or adjust them ...

Business Analyst Interview Questions Asked at Other Companies

asked in Evalueserve
Q1. You have 10 boxes of balls (each ball weighing exactly 10 gm) wit ... read more
Q2. There are 100 people standing in a circle, the first person has a ... read more
asked in EXL Service
Q3. Doors numbered 1 to 100 are initially closed. In the first step, ... read more
asked in Infosys
Q4. What is your strong point in terms of technical knowledge? Like J ... read more
asked in EXL Service
Q5. If you have 333 digits to number the pages of a book, how many pa ... read more
A Business Analyst was asked 8mo ago
Q. What is skewness and what are its types?
Ans. 

Skewness is a measure of the asymmetry of a distribution.

  • Skewness indicates the lack of symmetry in a distribution.

  • Positive skewness means the tail on the right side of the distribution is longer or fatter.

  • Negative skewness means the tail on the left side of the distribution is longer or fatter.

  • Types of skewness: Positive skewness, Negative skewness, and Zero skewness (symmetric distribution).

A Business Analyst was asked 8mo ago
Q. How does NULL behave in different types of joins?
Ans. 

Null behaves differently in different types of joins in SQL

  • In INNER JOIN, rows with NULL values are excluded from the result set

  • In LEFT JOIN, rows with NULL values from the left table are included in the result set

  • In RIGHT JOIN, rows with NULL values from the right table are included in the result set

  • In FULL OUTER JOIN, rows with NULL values from either table are included in the result set

What people are saying about Swiggy

View All
benevolentoyster
Verified Icon
2w
works at
Swiggy
Data Analyst job hunt—referrals welcome!
Actively seeking entry-level/junior Data Analyst roles and would love any referrals or leads. About me: B.Tech (2023) 6-month data analysis internship Skills: Excel, Power BI, Tableau, MySQL, Python Projects: Real business problem-solving Expertise: Data cleaning, visualization, dashboarding, reporting If you know of any openings, your support would be greatly appreciated! I'm ready to learn and contribute. Happy to share my resume/portfolio upon request. Thank you in advance!
Got a question about Swiggy?
Ask anonymously on communities.
A Business Analyst was asked 8mo ago
Q. What is the difference between DDL and DML?
Ans. 

DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.

  • DDL is used to create, modify, and delete database objects like tables, indexes, etc.

  • DML is used to insert, update, delete, and retrieve data from the database.

  • Examples of DDL statements include CREATE TABLE, ALTER TABLE, DROP ...

A Business Analyst was asked 9mo ago
Q. Write an SQL query to find the cumulative sum of cost for a given table.
Ans. 

Calculate cumulative sum of cost using SQL with window functions for a given table.

  • Use the SUM() function with OVER() clause for cumulative sum.

  • Example: SELECT cost, SUM(cost) OVER (ORDER BY date) AS cumulative_cost FROM expenses;

  • Ensure proper ordering to get accurate cumulative results.

  • You can partition data if needed using PARTITION BY clause.

A Business Analyst was asked 9mo ago
Q. Why did Flipkart's revenue drop 20% in December compared to November?
Ans. 

The drop in Flipkart's revenue in December compared to November can be attributed to seasonal factors, promotional activities, or changes in consumer behavior.

  • Seasonal factors such as holiday sales in November leading to higher revenue compared to December

  • Promotional activities like Black Friday or Cyber Monday driving higher sales in November

  • Changes in consumer behavior, such as delayed purchases or reduced spend...

Are these interview questions helpful?
A Business Analyst was asked
Q. Flipkart's sales this week were lower than last week, and competitors didn't run any special promotions. What metrics would you examine, and what framework would you use to analyze this?
Ans. 

Analyzing Flipkart's sales drop requires examining various metrics and frameworks to identify underlying issues.

  • 1. Sales Trends: Compare daily sales data from this week to last week to identify specific days with significant drops.

  • 2. Customer Traffic: Analyze website/app traffic to see if there was a decrease in visitors, indicating potential issues in attracting customers.

  • 3. Conversion Rate: Check if the conversi...

A Business Analyst was asked
Q. If Flipkart wants to replace its payment options from credit card to UPI, what would be the null and alternative hypotheses? What metrics would you use to evaluate this change?
Ans. 

Formulating hypotheses for Flipkart's payment option transition from credit cards to UPI.

  • Null Hypothesis (H0): There is no significant difference in transaction success rates between credit card and UPI payments.

  • Alternate Hypothesis (H1): UPI payments have a significantly higher transaction success rate compared to credit card payments.

  • Metrics to check: Transaction success rate, average transaction time, customer ...

A Business Analyst was asked
Q. Why Swiggy, and what values did you identify before applying?
Ans. 

I chose Swiggy for its innovative technology, market leadership, and growth potential.

  • Swiggy's cutting-edge technology in the food delivery industry stood out to me

  • The company's strong market presence and leadership position were appealing

  • I was impressed by Swiggy's rapid growth and expansion in the market

  • Swiggy's customer-centric approach and focus on quality service were values I admired

Swiggy Business Analyst Interview Experiences

11 interviews found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I appeared for an interview in Apr 2025, where I was asked the following questions.

  • Q1. Starting from how joins work to advanced sql.
  • Q2. A question on case study
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Coding Test 

8 sql questions
1 hard, 4 easy and 3 medium

Round 2 - One-on-one 

(5 Questions)

  • Q1. Tell me about yourself. Your responsibilities in current role.
  • Ans. 

    I am a Business Analyst with experience in data analysis, process improvement, and stakeholder management.

    • Analyze data to identify trends and insights

    • Improve business processes through automation and optimization

    • Manage relationships with stakeholders to gather requirements and ensure project success

  • Answered by AI
  • Q2. SQL based basic questions. Output of left join and inner right join
  • Q3. Any notable project you’ve done which made any remarkable change in business
  • Ans. 

    Implemented a data analytics project that optimized inventory management, resulting in a 20% reduction in costs.

    • Analyzed historical sales data to forecast demand and optimize inventory levels

    • Implemented a new inventory management system based on data-driven insights

    • Collaborated with cross-functional teams to ensure successful implementation

    • Monitored key performance indicators to track the impact of the project

  • Answered by AI
  • Q4. Difference between DDL and DML
  • Ans. 

    DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.

    • DDL is used to create, modify, and delete database objects like tables, indexes, etc.

    • DML is used to insert, update, delete, and retrieve data from the database.

    • Examples of DDL statements include CREATE TABLE, ALTER TABLE, DROP TABLE...

  • Answered by AI
  • Q5. How null behaves in different types of joins
  • Ans. 

    Null behaves differently in different types of joins in SQL

    • In INNER JOIN, rows with NULL values are excluded from the result set

    • In LEFT JOIN, rows with NULL values from the left table are included in the result set

    • In RIGHT JOIN, rows with NULL values from the right table are included in the result set

    • In FULL OUTER JOIN, rows with NULL values from either table are included in the result set

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Apr 2024. There were 3 interview rounds.

Round 1 - Coding Test 

SQL round - 6 problems 2 case studies

Round 2 - Technical 

(2 Questions)

  • Q1. SQL #1 Self join
  • Q2. SQL #2 Window funciton
Round 3 - Case Study 

RCA for CTR drop in youtube

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Mostly sql question asked, moderate level

Round 2 - One-on-one 

(2 Questions)

  • Q1. Sql join and sub query
  • Q2. Window functions
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
-
Round 1 - Coding Test 

SQL Test by HackerRank

Interview experience
3
Average
Difficulty level
-
Process Duration
2-4 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Sep 2023. There were 4 interview rounds.

Round 1 - Coding Test 

SQL and case study and was of an hour length

Round 2 - Technical 

(1 Question)

  • Q1. Mostly SQL based questions
Round 3 - Technical 

(1 Question)

  • Q1. Statistics and data Visualization and SQL again
Round 4 - Behavioral 

(1 Question)

  • Q1. Job fit and more sql
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

SQL test coding assessment which I am yet to give

Interview experience
3
Average
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Advance SQL test conducted by hackerrank

Round 3 - Technical 

(2 Questions)

  • Q1. SQL and business case questions
  • Q2. Joins and windows

I appeared for an interview in Mar 2021.

Interview Questionnaire 

4 Questions

  • Q1. Sql, A/B testing, case study about how to increase sales in particular area, what are the metrics that effect sales.
  • Q2. Steps involved in analysis of decrease in sales for particular area
  • Ans. 

    Steps involved in analyzing decrease in sales for a particular area

    • Identify the time period for which sales have decreased

    • Analyze the sales data for the area and compare it with previous periods

    • Identify any external factors that may have contributed to the decrease in sales

    • Conduct customer surveys to identify any issues with products or services

    • Analyze competitor activity in the area

    • Develop a plan to address the issues...

  • Answered by AI
  • Q3. Write sql query to find mean waiting period for delivery partner given driver I'd, ordered time and delivered time.
  • Q4. Write query for rolling sum
  • Ans. 

    Rolling sum query adds up a specified number of rows in a table based on a given condition.

    • Use the OVER() function to specify the window frame for the rolling sum.

    • Specify the number of rows to include in the window frame using ROWS BETWEEN.

    • Use ORDER BY to specify the order of rows in the window frame.

    • Example: SELECT column1, SUM(column2) OVER (ORDER BY column1 ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FR...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for SQL, you have to be strong in SQL.
there will be two round one sql and other cae study

Skills evaluated in this interview

I applied via Referral and was interviewed before Mar 2021. There were 4 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Types of Joins in SQL, minimum and maximum number of rows possible from these joins
  • Q2. Mean, median, mode, measures of central tendency
Round 2 - Case Study 

1.Features you would look for if you have to buy an elevator
2. How do you estimate the number of trains passing through a station

Round 3 - Behavioral 

(1 Question)

  • Q1. Why do you want to join swiggy ? What are your plans for upcoming years ?
Round 4 - HR 

(1 Question)

  • Q1. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident and don't behave cocky. At Swiggy, candidate attitude and team fit is given a lot of importance.

Skills evaluated in this interview

Swiggy Interview FAQs

How many rounds are there in Swiggy Business Analyst job interview?
Swiggy interview process usually has 2-3 rounds. The most common rounds in the Swiggy interview process are Coding Test, Technical and Case Study.
How to prepare for Swiggy Business Analyst job interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Swiggy. The most common topics and skills that interviewers at Swiggy expect are SQL, Python, Machine Learning, Analytics and Business Analysis.
What are the top questions asked in Swiggy Business Analyst interview for job?

Some of the top questions asked at the Swiggy Business Analyst interview for job -

  1. Write sql query to find mean waiting period for delivery partner given driver I...read more
  2. Types of Joins in SQL, minimum and maximum number of rows possible from these j...read more
  3. Steps involved in analysis of decrease in sales for particular a...read more
How long is the Swiggy Business Analyst interview process?

The duration of Swiggy Business Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Overall Interview Experience Rating

3.5/5

based on 8 interview experiences

Difficulty level

Moderate 83%
Hard 17%

Duration

Less than 2 weeks 67%
2-4 weeks 33%
View more
Swiggy Business Analyst Salary
based on 281 salaries
₹11 L/yr - ₹18.1 L/yr
35% more than the average Business Analyst Salary in India
View more details

Swiggy Business Analyst Reviews and Ratings

based on 22 reviews

3.5/5

Rating in categories

3.8

Skill development

3.4

Work-life balance

3.3

Salary

2.9

Job security

3.6

Company culture

2.9

Promotions

3.6

Work satisfaction

Explore 22 Reviews and Ratings
Business Analyst

Bangalore / Bengaluru

1-3 Yrs

₹ 12-21 LPA

Explore more jobs
Delivery Boy
897 salaries
unlock blur

₹1.7 L/yr - ₹5.1 L/yr

Fleet Manager
641 salaries
unlock blur

₹2.5 L/yr - ₹6 L/yr

Sales Manager
573 salaries
unlock blur

₹4.3 L/yr - ₹9.5 L/yr

Assistant Manager
531 salaries
unlock blur

₹5.2 L/yr - ₹13 L/yr

Store Manager
498 salaries
unlock blur

₹3.3 L/yr - ₹7.2 L/yr

Explore more salaries
Compare Swiggy with

Eternal Limited

3.7
Compare

Dunzo

3.4
Compare

FoodPanda

3.6
Compare

Rapido

3.7
Compare
write
Share an Interview