Add office photos
Filter interviews by
Swiggy Business Analyst Full-time Job Interview Questions, Process, and Tips
Top Swiggy Business Analyst Full-time Job Interview Questions and Answers
- Q1. Write sql query to find mean waiting period for delivery partner given driver I'd, ordered time and delivered time.
- Q2. Types of Joins in SQL, minimum and maximum number of rows possible from these joins
- Q3. Steps involved in analysis of decrease in sales for particular area
Swiggy Business Analyst Interview Experiences
12 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.
8 sql questions
1 hard, 4 easy and 3 medium
(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
- 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
- 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...
- 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
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Apr 2024. There were 3 interview rounds.
SQL round - 6 problems 2 case studies
(2 Questions)
- Q1. SQL #1 Self join
- Q2. SQL #2 Window funciton
RCA for CTR drop in youtube
I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.
Mostly sql question asked, moderate level
(2 Questions)
- Q1. Sql join and sub query
- Q2. Window functions
What people are saying about Swiggy
SQL Test by HackerRank
Swiggy interview questions for designations
I applied via Company Website and was interviewed in Sep 2023. There were 4 interview rounds.
SQL and case study and was of an hour length
(1 Question)
- Q1. Mostly SQL based questions
(1 Question)
- Q1. Statistics and data Visualization and SQL again
(1 Question)
- Q1. Job fit and more sql
SQL test coding assessment which I am yet to give
Business Analyst Jobs at Swiggy
I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.
Advance SQL test conducted by hackerrank
(2 Questions)
- Q1. SQL and business case questions
- Q2. Joins and windows
Just Code It- Sarthak
I was interviewed 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...
- Q3. Write sql query to find mean waiting period for delivery partner given driver I'd, ordered time and delivered time.
- Ans.
SQL query to find mean waiting period for delivery partner given driver ID, ordered time and delivered time.
Use AVG function to calculate mean waiting period
Subtract ordered time from delivered time to get waiting period
Filter data by driver ID and delivery partner
Group by delivery partner
- 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
Interview Preparation Tips
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.
(2 Questions)
- Q1. Types of Joins in SQL, minimum and maximum number of rows possible from these joins
- Ans.
Types of SQL joins and their minimum and maximum possible rows.
Types of joins: Inner, Left Outer, Right Outer, Full Outer, Cross
Minimum rows: Inner - 0, Left/Right Outer - 1, Full Outer - 0, Cross - product of rows
Maximum rows: Inner/Left/Right/Full Outer - product of rows, Cross - product of rows
- Q2. Mean, median, mode, measures of central tendency
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
(1 Question)
- Q1. Why do you want to join swiggy ? What are your plans for upcoming years ?
(1 Question)
- Q1. What are your salary expectations?
Interview Preparation Tips
Skills evaluated in this interview
Swiggy Interview FAQs
Some of the top questions asked at the Swiggy Business Analyst interview for job -
The duration of Swiggy Business Analyst interview process can vary, but typically it takes about 2-4 weeks to complete.
Tell us how to improve this page.
Swiggy Interviews By Designations
- Swiggy Business Analyst Interview Questions
- Swiggy Sales Manager Interview Questions
- Swiggy Fleet Manager Interview Questions
- Swiggy Assistant Store Manager Interview Questions
- Swiggy Store Manager Interview Questions
- Swiggy Business Associate Interview Questions
- Swiggy MIS Executive Interview Questions
- Swiggy Team Lead Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Manager Interview Questions
- Business Executive Interview Questions
- Show more
Swiggy Business Analyst Interview Process of Full-time Jobs
based on 6 interviews in last 1 year
1 Interview rounds
- Coding Test Round
People are getting interviews through
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
Swiggy Business Analyst Reviews and Ratings
based on 17 reviews
Rating in categories
|
Delivery Boy
854
salaries
|  ₹0.4 L/yr - ₹5 L/yr |
|
Fleet Manager
608
salaries
| ₹2.5 L/yr - ₹6 L/yr |
|
Sales Manager
585
salaries
| ₹2.4 L/yr - ₹9 L/yr |
|
Assistant Manager
493
salaries
| ₹5.3 L/yr - ₹13.8 L/yr |
|
Assistant Store Manager
424
salaries
| ₹1.6 L/yr - ₹4.2 L/yr |
Zomato
Dunzo
FoodPanda
Rapido
Calculate your in-hand salary
- Home >
- Interviews >
- Swiggy Interview Questions >
- Swiggy Business Analyst Job Interview Questions
