Add office photos
Filter interviews by
Swiggy Senior Business Analyst Interview Questions and Answers
Swiggy Senior Business Analyst Interview Experiences
4 interviews found
Anonymous
I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.
8 SQl questions of easy, medium and hard diffiulty
(2 Questions)
- Q1. SQL Question on join
- Q2. SQL question on window funtions
(1 Question)
- Q1. Questions on SQL joins, window functions etc.
I applied via Company Website and was interviewed in Nov 2023. There were 2 interview rounds.
SQL case study - tough questions
(1 Question)
- Q1. Culter fit and Hr round
Selected
I applied via LinkedIn and was interviewed before Aug 2022. There were 5 interview rounds.
(5 Questions)
- Q1. SQL Theory - joins, order of execution, window functions
- Q2. Hands-on SQL - handling corner cases, solving practical problems
- Q3. Python/Excel (if on resume). Important functions and packages e.g. (VLOOKUP, pandas, etc.)
- Q4. Data visualization - basic understanding of storytelling with data, when to use what visualization
- Q5. Schema design (if having experience) - what factors to consider, normalization, fact vs transaction tables
(3 Questions)
- Q1. Basic stats - central tendencies, distributions, skewness, outlier detection
- Q2. Experiment design, hypothesis testing
- Q3. Analytical case studies - how to solve problems and when to apply different approaches such as segmentation, clustering, forecasting, etc.
Open-ended case study to understand your approach and considerations. Use common sense, explain your thinking and be rigorous. Can come from any field but does not require field-intensive knowledge
(3 Questions)
- Q1. Personality questions, motivations, company culture fit
- Q2. Can re-touch on anything from previous round
- Q3. In-depth exploration of any project or skill on resume
Interview Preparation Tips
Swiggy interview questions for designations
Interview questions from similar companies
I applied via Company Website and was interviewed in Jun 2024. There was 1 interview round.
(2 Questions)
- Q1. SQL question about joins on table having null values
- Q2. SQL question on lead/lag/cummulative sum application
I applied via Naukri.com and was interviewed in May 2024. There were 4 interview rounds.
Hacker rank test with SQL questions
Design the database and write a query to find the most re-ordered product
Case study and technical round - database design questions and analytical thinking check
HR Related questions and market entry level case study
Interview Preparation Tips
- SQL
- Case Studies
On their new product launch was given 2-4 days for completion
(2 Questions)
- Q1. Based on case study
- Q2. SQL related question , how will you perform analysis, check if data is accurate
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed before Feb 2023. There were 3 interview rounds.
(1 Question)
- Q1. Normal verification
(2 Questions)
- Q1. Questions related to sql
- Q2. Windows function in sql
- Ans.
The Windows function in SQL is used to perform calculations on a specific subset of rows in a result set.
The Windows function is used with the OVER clause to define the subset of rows to perform calculations on.
Common Windows functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.
Example: SELECT ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS row_num FROM employees;
(1 Question)
- Q1. Interview with stakeholders
Skills evaluated in this interview
(2 Questions)
- Q1. Windows Function
- Q2. Joins (Self, Left, Right, Outer)
I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.
They sent a hackerrank test which had only sql questions
They asked for my last project and asked few sql questions. They also asked few statistics question which was not expected
Interview Preparation Tips
Swiggy Interview FAQs
Some of the top questions asked at the Swiggy Senior Business Analyst interview -
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 Analyst Interview Questions
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Manager Interview Questions
- Business Executive Interview Questions
- Show more
Swiggy Senior Business Analyst Interview Process
based on 3 interviews in last 1 year
Interview experience
People are getting interviews through
Senior Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
Swiggy Senior Business Analyst Reviews and Ratings
based on 13 reviews
Rating in categories
|
Delivery Boy
855
salaries
|  ₹0.4 L/yr - ₹5 L/yr |
|
Fleet Manager
596
salaries
| ₹2.5 L/yr - ₹5.6 L/yr |
|
Sales Manager
515
salaries
| ₹2.4 L/yr - ₹9 L/yr |
|
Assistant Manager
501
salaries
| ₹3 L/yr - ₹13.8 L/yr |
|
Assistant Store Manager
430
salaries
| ₹1.8 L/yr - ₹4.2 L/yr |
Zomato
Dunzo
FoodPanda
Rapido
Calculate your in-hand salary
- Home >
- Interviews >
- Swiggy Interview Questions >
- Swiggy Senior Business Analyst Interview Questions
