Swiggy Business Analyst interviews, as candidates report them, combine a SQL assessment, technical or statistics questions, business cases and a hiring-manager conversation. Round counts range from 2 to 4.
$21K
Avg. Base Comp
$31K
Avg. Total Comp
2-4 rounds
Typical Rounds
Not reported
Process Length
Candidates describe the Swiggy Business Analyst interview as a mix of SQL, business cases and a hiring-manager conversation, though the format varies from one report to the next. Reported processes run from two rounds (an HR screen and a manager round) to four rounds with a timed assessment and separate technical, case and hiring-manager interviews.
SQL appears most often. Candidates report a HackerRank test of seven or eight questions ranging from easy to hard, with limited time. One 2024 candidate who did not receive an offer said window functions such as lead, lag, row_number, rank and dense_rank were the trickiest part, including how rank and dense_rank handle ties. Another report mentioned a query counting orders per restaurant in November, along with join scenarios.
The business cases are Swiggy-specific. Candidates were asked why orders might fall by 5%, how to estimate Swiggy's order volume, how to raise quick-commerce revenue, and what to do if a restaurant gets no orders. One candidate also reported guesstimates and root cause analysis in a dedicated case round. Interviewers appear to care more about structured reasoning, assumptions and clarifying questions than one perfect answer.
Some candidates also reported hypothesis testing, A/B testing, outliers and null handling, and one mentioned Excel. The hiring-manager round typically goes through your CV and past work, so be ready to link it to Swiggy's marketplace problems.
Synthesized from 7 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Swiggy process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Swiggy
Create top_ads with the top 3 ads and return the row counts for inner, left, right, and cross joins with ads
| Question | |
|---|---|
| Z and t-Tests | |
| Forecasting New Year Revenue | |
| Unified Event Pipeline | |
| Increased Cancellations | |
| Empty Neighborhoods | |
| 2nd Highest Salary | |
| Longest Streak Users | |
| Customer Orders | |
| Button AB Test | |
| Paired Products | |
| Month Over Month | |
| Fair Coin | |
| Upsell Transactions | |
| Experiment Validity | |
| Top 3 Users | |
| Monthly Customer Report | |
| Rolling Bank Transactions | |
| 500 Cards | |
| Scrambled Tickets | |
| Comments Histogram | |
| 7 Day Streak | |
| Cumulative Reset | |
| Top Three Salaries | |
| Closest SAT Scores | |
| Get Top N Frequent Words | |
| Subscription Overlap | |
| Duplicate Rows | |
| Prime to N | |
| WAU vs Open Rates |
Synthesized from candidate reports. Individual experiences may vary.
One candidate reports an initial HR screening call before meeting the hiring manager. Another describes a short HR conversation at the end about compensation. The order may vary, so confirm the sequence with your recruiter and be ready to explain your background and interest in the role.
Two candidates report a HackerRank SQL test with seven or eight questions, ranging from easy to hard, with one report citing 1.25 hours. Reported topics include joins, aggregates and window functions such as lead, lag, row_number, rank and dense_rank. One report included a case-study-style question. Practice under time pressure.
Some candidates report a technical round that went beyond the assessment. Reported topics include SQL and Python in practical scenarios, outlier handling, null replacement, hypothesis testing and A/B testing. Another candidate's first round mixed SQL, join scenarios, puzzles and aptitude questions. Not every candidate describes this round, so treat it as a likely area rather than a fixed stage.
Candidates report guesstimates such as the number of Swiggy orders, a 5% order drop, root cause analysis, and puzzles or aptitude questions. Interviewers reportedly value clear assumptions, clarifying questions and visible reasoning over a single correct answer.
Candidates report a hiring-manager round that goes through their CV and past work, sometimes with another business case. One candidate also reported questions about quick-commerce revenue and underperforming restaurants. Another candidate's final round was an HR conversation on handling pressure, leadership and time management. Prepare to link your experience to Swiggy's business.
