
Swiggy Business Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 49 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Swiggy.
Business Analyst
The interview process had 4 rounds. The first was technical, the second was about AB experiments, the third was a case study, and the fourth was with the hiring manager. The technical round mostly involved SQL questions, ranging from basic to advanced. The AB testing round covered topics like z-score, different types of tests, and normalization. The case study round focused on root cause analysis.
- If Uber's conversion percentage has dropped, how would you investigate the potential causes?
Business Analyst
The interview process included one online assessment, followed by three interviews: one technical, one case study, and one with the hiring manager. The experience with HR was quite negative. Initially, they offered 12 LPA for a Business Analyst role. During the interview process, they asked if I could join as an MIS role for 10 LPA, which I declined. Then they offered an Associate BA role for 11 LPA. When I inquired about the BA role and the frequent changes, I received no clear answers. They negotiated the salary like a fish market and reneged on their initial offer. The recruiters showed a lack of accountability, which was a very pathetic experience.
- Can you explain SQL self join and provide an example?
- What is your estimate for...?
Business Analyst
The interview process was quite smooth and straightforward. We started with Round 1, which was an online technical test featuring SQL queries of easy to moderate difficulty, along with a business case study (split into 8+1 parts). Next was Round 2, a SQL technical interview focusing on a strong grasp of basic concepts and practical implementation. Round 3 was a stats interview involving hypothesis testing case studies and fundamental statistics. Then came Round 4, a business case study where I was asked about improving sales in a specific area and about tracking metrics for a new feature in an e-commerce app. Finally, Round 5 was with the hiring manager, covering strengths, weaknesses, and general interpersonal questions.
- Can you explain how to calculate a rolling sum in SQL?
- What are SQL joins and how do they work?
- Can you demonstrate some Excel questions, like using VLOOKUP?
Swiggy Business Analyst Interview Questions
Quoted word for word from Swiggy interview reports.
“Estimation question: How many footballs are there in Bangalore?”
Read reports →“What are the reasons for Swiggy Super subscriptions not being renewed?”
Read reports →“What are SQL joins and how do they work?”
Read reports →“What are the advantages and disadvantages of linear regression?”
Read reports →“Can you explain how to calculate a rolling sum in SQL?”
Read report →“Explain Box Plot and how to remove outliers in the Statistical Round.”
Read report →“What is the ideal timeframe for identifying customer churn?”
Read report →“Can you explain SQL self join and provide an example?”
Read report →“Explain the question on order of execution of SQL query.”
Read report →Formats, difficulty and experience
Across all 49 Swiggy interview reports.