Swiggy Business Analyst Interview Questions & Experience Guide

Swiggy Business Analyst Interview Questions & Experience Guide

Company Name: Swiggy

Position: Business Analyst

Application Process: The application process was straightforward. I applied through the company’s career portal, and the recruitment team reached out for further rounds.

Interview Rounds:

  • Round 1 - Technical Round (SQL & Problem Solving):

    • Questions Asked:
      • SQL queries related to data retrieval and manipulation.
      • Guesstimate problems, such as “How many orders does Swiggy receive in one day?”
    • Your Approach:
      • For SQL, I focused on writing efficient queries and explaining my thought process.
      • For the guesstimate, I broke down the problem into smaller components (e.g., population, average orders per person, etc.) and used logical assumptions.
    • Outcome: Cleared the round with positive feedback on my problem-solving approach.
  • Round 2 - Hiring Manager Round:

    • Questions Asked:
      • Behavioral questions about past experiences and how I handled challenges.
      • More problem-solving scenarios related to business analysis.
    • Your Approach:
      • I used the STAR method for behavioral questions to structure my answers.
      • For problem-solving, I focused on aligning my solutions with business goals.
    • Outcome: Successfully cleared the round and received an offer.

Preparation Tips:

  • Brush up on SQL, especially joins, subqueries, and aggregations.
  • Practice guesstimate problems to improve logical structuring.
  • Be ready to discuss past experiences in detail, focusing on outcomes and learnings.

Conclusion:
The interview process was smooth and well-structured. The key was to stay calm and think logically during the guesstimate and problem-solving rounds. I would advise future candidates to practice SQL and guesstimates thoroughly and be prepared to articulate their thought process clearly.

Company Name: Swiggy

Position: Business Analyst

Application Process: Applied through an online job portal.

Interview Rounds:

  • Round 1 - Technical Interview:

    • Questions Asked: The interviewer asked about my previous experience and how I would approach a specific business problem. They seemed rigid in their expectations and dismissed alternative solutions I proposed.
    • Your Approach: I tried to explain my thought process logically, but the interviewer was not receptive to new ideas.
    • Outcome: The round did not go well due to the interviewer’s inflexibility.
  • Round 2 - HR Interview:

    • Questions Asked: Basic HR questions about my background, expectations, and why I wanted to join Swiggy.
    • Your Approach: Answered honestly and professionally, but the overall experience was overshadowed by the previous round.
    • Outcome: Did not proceed further in the process.

Conclusion:
This was one of the most unprofessional interview processes I have encountered. The interviewers were not open to new logics or diverse thinking, expecting only one line of thought. My advice to future candidates would be to research the company’s interview culture beforehand and be prepared for rigid expectations.

Company Name: Swiggy

Position: Business Analyst

Application Process: Applied through an online platform.

Interview Rounds:

  • Round 1 - SQL HackerRank Test:

    • Questions Asked: Moderate-level SQL questions.
    • Your Approach: Focused on writing efficient queries and ensuring correctness.
    • Outcome: Cleared this round.
  • Round 2 - Technical Interview:

    • Questions Asked:
      • SQL concepts like rolling sum, rank, dense rank, row_num.
      • Case study-based queries, such as finding highest orders based on category.
      • Order of query execution and subqueries.
    • Your Approach: Practiced hands-on SQL extensively before the interview to tackle these questions confidently.
    • Outcome: Cleared this round.
  • Round 3 - Analytical Round:

    • Questions Asked:
      • Statistical questions.
      • Business case study: How to increase the number of orders to 1.5x the current value after sales were hit during lockdown.
      • KPIs to measure restaurant performance.
    • Your Approach: Used logical reasoning and structured thinking to address the case study and KPIs.
    • Outcome: Cleared this round.

Preparation Tips:

  • SQL must be hands-on; practice writing complex queries.
  • Brush up on statistical concepts and business case study frameworks.
  • Understand KPIs relevant to the role.

Conclusion:
The interview process was thorough and tested both technical and analytical skills. Practicing SQL and case studies beforehand was crucial. For future candidates, focus on real-world problem-solving and be prepared to think on your feet.

Company Name: Swiggy

Position: Business Analyst

Application Process: The application process involved a telephonic round followed by onsite interviews.

Interview Rounds:

  • Round 1 - Telephonic Round:

  • Questions Asked: General screening questions about my background and interest in the role.

  • Your Approach: I kept my answers concise and aligned them with the job requirements.

  • Outcome: Cleared the round and was invited for onsite interviews.

  • Round 2 - Technical Round:

  • Questions Asked: Questions on SQL, R, Python, and Linear Regression.

  • Your Approach: I focused on explaining my thought process clearly and used examples from my past projects to demonstrate my skills.

  • Outcome: Successfully cleared the round.

  • Round 3 - Problem-Solving Round:

  • Questions Asked: Case-based questions to assess problem-solving abilities.

  • Your Approach: I structured my answers using frameworks and ensured I covered all aspects of the problem.

  • Outcome: Moved to the next round.

  • Round 4 - Business Sense Round:

  • Questions Asked: Guesstimate questions and questions about my work experience, as well as “Why Swiggy?”

  • Your Approach: I used logical reasoning for guesstimates and tied my work experience to the role. For “Why Swiggy?” I highlighted my passion for the company’s mission.

  • Outcome: The hiring manager seemed satisfied, and this round was merged with the previous one.

Preparation Tips:

  • Brush up on SQL, R, Python, and statistical concepts like Linear Regression.
  • Practice case studies and guesstimates to improve problem-solving and business sense.
  • Be ready to articulate your work experience and how it aligns with the role.

Conclusion:
The overall experience was challenging but rewarding. The technical round was the most demanding, but my preparation paid off. For future candidates, I’d recommend practicing case studies and being clear about your motivations for joining Swiggy.

Company Name: Swiggy

Position: Business Analyst

Application Process: I applied via LinkedIn and was interviewed before September 2022.

Interview Rounds:

  • Round 1 - Resume Shortlist:

    • Details: My resume was reviewed for relevance and accuracy.
    • Outcome: Passed to the next round.
  • Round 2 - Coding Test:

    • Questions Asked: Basic SQL questions.
    • Your Approach: I practiced SQL queries beforehand to ensure I was comfortable with the basics.
    • Outcome: Cleared the round successfully.
  • Round 3 - Technical Round:

    • Questions Asked: SQL, Python, and basic statistics.
    • Your Approach: I focused on explaining my thought process clearly and demonstrated my knowledge of SQL and Python.
    • Outcome: Advanced to the next round.
  • Round 4 - Case Study Round:

    • Questions Asked: Problem-solving case studies and analytics cases.
    • Your Approach: I structured my answers logically and used data-driven insights to solve the cases.
    • Outcome: Moved forward to the final round.
  • Round 5 - One-on-One Round:

    • Questions Asked: General HR questions and resume-based questions.
    • Your Approach: I ensured my answers aligned with my resume and highlighted my relevant skills and experiences.
    • Outcome: Final evaluation pending.

Preparation Tips:

  • Practice SQL and Python basics thoroughly.
  • Work on case studies to improve problem-solving skills.
  • Review your resume in detail to answer HR questions confidently.

Conclusion:
The interview process was comprehensive and tested both technical and analytical skills. I felt well-prepared for the technical rounds but could have practiced more case studies to refine my approach. Overall, it was a great learning experience!

Company Name: Swiggy

Position: Business Analyst

Application Process: The application was made through an online platform, likely a job portal or Swiggy’s career page. The process began with a coding test.

Interview Rounds:

  • Round 1 - Coding Test (SQL Test by HackerRank):

    • Questions Asked: The test consisted of SQL-based questions to assess data querying and manipulation skills. Specific questions weren’t shared, but it covered topics like joins, subqueries, aggregations, and possibly window functions.

    • Your Approach: I focused on writing efficient queries, ensuring proper indexing and avoiding redundant operations. I also double-checked my syntax and logic before submitting.

    • Outcome: Passed the round and moved forward in the process.

Preparation Tips:

  • Brush up on SQL fundamentals, especially joins, aggregations, and subqueries.
  • Practice writing optimized queries to handle large datasets.
  • Familiarize yourself with HackerRank’s SQL environment to avoid surprises during the test.

Conclusion:

The coding test was straightforward but required a solid grasp of SQL. Practicing on platforms like HackerRank beforehand helped me feel more confident. For future candidates, I’d recommend focusing on query optimization and time management during the test.

Company Name: Swiggy

Position: Business Analyst

Location: Not specified

Application Process: I applied via a referral and was interviewed before March 2021.

Interview Rounds:

  • Round 1 - Technical Round:

    • Questions Asked:
      1. Types of Joins in SQL, minimum and maximum number of rows possible from these joins.
      2. Mean, median, mode, measures of central tendency.
    • Your Approach: I explained the different types of joins (INNER, LEFT, RIGHT, FULL) and their row outcomes. For the second question, I defined each measure and provided examples.
    • Outcome: Cleared the round.
  • Round 2 - Case Study Round:

    • Questions Asked:
      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?
    • Your Approach: For the elevator question, I focused on safety, capacity, and energy efficiency. For the train estimation, I considered factors like station size, peak hours, and train schedules.
    • Outcome: Advanced to the next round.
  • Round 3 - Behavioral Round:

    • Questions Asked:
      1. Why do you want to join Swiggy?
      2. What are your plans for the upcoming years?
    • Your Approach: I highlighted my interest in Swiggy’s data-driven culture and my career goals aligned with the role.
    • Outcome: Successfully cleared the round.
  • Round 4 - HR Round:

    • Questions Asked:
      1. What are your salary expectations?
    • Your Approach: I provided a realistic range based on industry standards and my experience.
    • Outcome: Final round cleared.

Preparation Tips:

  • Just be confident and don’t behave cocky. At Swiggy, candidate attitude and team fit are given a lot of importance.

Conclusion:
Overall, the interview process was smooth and well-structured. I focused on being clear and concise in my answers, which worked well. For future candidates, I’d recommend brushing up on SQL, case studies, and behavioral questions, and most importantly, staying confident and humble throughout the process.

Company Name: Swiggy

Position: Business Analyst

Location: [Not specified]

Application Process: Applied via LinkedIn in July 2023.

Interview Rounds:

  • Round 1 - Technical Round:

  • Questions Asked: SQL queries, most using direct functions.

  • Your Approach: Prepared by practicing SQL queries and understanding common functions. Focused on writing efficient and optimized queries.

  • Outcome: [Result not specified]

Preparation Tips:

  • Practice SQL queries thoroughly, especially those involving direct functions.
  • Brush up on analytical skills and problem-solving techniques.
  • Familiarize yourself with business analytics concepts and tools.

Conclusion:
Overall, the interview was focused on technical skills, particularly SQL. Preparing well for SQL queries and understanding business analytics concepts would be beneficial for future candidates.

Company Name: Swiggy

Position: Business Analyst

Application Process: I applied via the company website and was interviewed in August 2022.

Interview Rounds:

  • Round 1 - Resume Shortlist:

    • Questions Asked: N/A (Resume screening round)
    • Your Approach: Ensured my resume was well-formatted and aligned to make it easy for the recruiter to read.
    • Outcome: Successfully shortlisted for the next round.
  • Round 2 - Technical Round:

    • Questions Asked:
      1. How many delivery boys have called customers more than 5 times?
      2. Count distinct unique names from the table.
    • Your Approach: Prepared thoroughly for SQL queries, focusing on problem-solving and efficiency.
    • Outcome: Answered the questions to the best of my ability.

Preparation Tips:

  • Prepared well for SQL.
  • Used platforms like HackerRank for practice.

Conclusion:
Overall, the interview process was smooth. I focused on SQL preparation, which helped me tackle the technical round effectively. For future candidates, I recommend practicing SQL problems regularly and ensuring your resume is clean and well-structured.

Company Name: Swiggy

Position: Business Analyst

Location: Not specified

Application Process: I applied for the position through the company’s recruitment process in November 2021.

Interview Rounds:

  • Round 1 - Video Call Round:
    • Questions Asked:
      1. Write an SQL query to find the mean waiting period for a delivery partner given driver ID, ordered time, and delivered time.
      2. Write a query for a rolling sum.
    • Your Approach: I prepared extensively for SQL queries, focusing on aggregations and time-based calculations. For the mean waiting period, I used the AVG function along with timestamp differences. For the rolling sum, I utilized window functions like SUM() OVER().
    • Outcome: I successfully answered both questions and advanced to the next stage.

Preparation Tips:

  • Topics to Prepare: Data Structures, Algorithms, System Design, Aptitude, OOPS, Database, and SQL.
  • Time Required: 3 months of dedicated preparation.
  • Tips:
    1. Practice previously asked interview and online test questions.
    2. Focus on mastering SQL, as it is a critical skill for this role.
    3. Work on at least 2 good projects and ensure you can explain them thoroughly.

Conclusion:
The interview was straightforward, with a strong emphasis on SQL. Preparing well for SQL and having a good grasp of database concepts helped me succeed. My advice to future candidates is to focus on SQL and ensure you can solve practical problems efficiently. I was selected for the role, and I attribute my success to thorough preparation and clarity in problem-solving.

Company Name: Swiggy

Position: Business Analyst

Location: [Not specified]

Application Process: [Not specified]

Interview Rounds:

  • Round 1 - Technical Interview:

    • Questions Asked:
      1. SQL-related questions, including writing a query to find the mean waiting period for a delivery partner given driver ID, ordered time, and delivered time.
      2. Write a query for rolling sum.
    • Your Approach: Focused on writing efficient SQL queries and ensuring clarity in logic.
    • Outcome: Passed to the next round.
  • Round 2 - Case Study:

    • Questions Asked:
      1. Case study about how to increase sales in a particular area and identifying the metrics that affect sales.
      2. Steps involved in analyzing a decrease in sales for a particular area.
    • Your Approach: Structured the analysis by breaking down the problem into key metrics and proposing actionable insights.
    • Outcome: Successfully cleared the round.
  • Round 3 - A/B Testing:

    • Questions Asked:
      1. Questions related to A/B testing methodologies and their application in business scenarios.
    • Your Approach: Explained the principles of A/B testing and its relevance to business decisions.
    • Outcome: Cleared the round.

Preparation Tips:

  • Focus on strengthening SQL skills as it is a critical component of the interview.
  • Be prepared for case studies and A/B testing questions, as they are commonly asked.
  • Practice writing efficient and clear SQL queries.

Conclusion:
The interview process was thorough and tested both technical and analytical skills. Preparing well for SQL and case studies was key to performing well. For future candidates, I recommend dedicating time to SQL practice and understanding business metrics deeply.

Company Name: Swiggy

Position: Business Analyst

Location: [Location not specified]

Application Process: [Details not provided]

Interview Rounds:

  • Round 1 - Interview:
  • Questions Asked:
    • Q1. How much work experience do you have?
  • Your Approach: [Details not provided]
  • Outcome: The interview ended after the first question.

Preparation Tips:

  • Interview preparation tips for other job seekers: The interview ended abruptly after the first question, so ensure you are prepared to answer basic questions confidently.

Conclusion:

  • The interview experience was brief and unexpected. Future candidates should be ready for any type of question, even if the interview seems to end early.

Company Name: Swiggy

Position: Business Analyst

Application Process: Approached by the company and interviewed in April 2023.

Interview Rounds:

  • Round 1 - Resume Shortlist:

    • Pro Tip: Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, so make sure to leave the best impression.
    • Outcome: Passed
  • Round 2 - Coding Test:

    • Focus Areas: SQL and case studies related to Swiggy’s business.
    • Test Details: Hackerrank online test with 8 SQL questions (ranging from easy to hard difficulty) and 1 case study to be completed in 85 minutes.
    • Outcome: Passed
  • Round 3 - Technical Round:

    • Questions Asked: Details not provided (candidate did not reach this stage).
    • Outcome: N/A

Preparation Tips:

  • Focus on SQL and case studies, especially those relevant to Swiggy’s business model.
  • Practice solving SQL problems of varying difficulty levels.
  • Be prepared to tackle a case study within a tight timeframe (85 minutes).

Conclusion:
The interview process was structured and focused on technical skills, particularly SQL and business case studies. While I didn’t progress to the technical round, the experience was valuable. For future candidates, I recommend thorough preparation in SQL and practicing case studies under time constraints.

Company Name: Swiggy

Position: Business Analyst

Application Process: I applied via a referral and was interviewed before May 2020.

Interview Rounds:

  • Round 1 - Case Study/Problem-Solving:
    • Questions Asked: How can you understand the supply of restaurants in a particular area of a city?
    • Your Approach: I considered the city’s demographics, focusing on busy roads where 70% of the supply would likely be on food-tech platforms (market standard). I also suggested checking platforms like Swiggy or Zomato during peak times to assess the available supply in that area.
    • Outcome: The interviewer appreciated the structured approach and the practical method of validating assumptions using existing platforms.

Preparation Tips:

  • Understand the demographics of any city you’re analyzing. For example, busy roads are likely to have a higher concentration of restaurants.
  • Use food-tech platforms like Swiggy or Zomato to validate assumptions about supply during peak hours.
  • Be prepared to think of multiple ways to solve a problem, as there may not be a single correct answer.

Conclusion:
The interview was a great learning experience, and the case study round was particularly insightful. I realized the importance of validating assumptions with real-world data. For future candidates, I’d recommend practicing case studies and being comfortable with making data-driven assumptions.

Company Name: Swiggy

Position: Business Analyst

Location: [Not specified]

Application Process: Applied via the company website before June 2022.

Interview Rounds:

  • Round 1 - Resume Shortlist:

    • Questions Asked: Resume screening.
    • Your Approach: Ensured the resume was concise and relevant to the role, avoiding unnecessary personal details.
    • Outcome: Passed to the next round.
  • Round 2 - Coding Test:

    • Questions Asked: 8 SQL questions with increasing complexity and 1 case study.
    • Your Approach: Focused on writing efficient SQL queries and analyzing the case study thoroughly.
    • Outcome: Advanced to the technical rounds.
  • Round 3 - Technical Round (Screening):

    • Questions Asked: SQL and statistics screening.
    • Your Approach: Prepared by revising SQL concepts and basic statistics.
    • Outcome: Cleared the screening.
  • Round 4 - Technical Round (Case Studies):

    • Questions Asked: Business case studies, guesstimates, and some technical questions.
    • Your Approach: Practiced case studies beforehand and structured answers logically.
    • Outcome: Moved to the hiring manager round.
  • Round 5 - Hiring Manager Round:

    • Questions Asked: Profile screening, suitability for the role, case studies, and guesstimates.
    • Your Approach: Highlighted relevant experience and demonstrated problem-solving skills.
    • Outcome: Progressed to the HR round.
  • Round 6 - HR Round:

    • Questions Asked: Why the sudden job change plan? Why Swiggy, and what values did you see before applying?
    • Your Approach: Answered honestly about career goals and aligned them with Swiggy’s values.
    • Outcome: Final selection.

Preparation Tips:

  • Focus on SQL and statistics for the technical rounds.
  • Practice case studies and guesstimates to improve problem-solving skills.
  • Ensure your resume is tailored to the role and free of unnecessary details.

Conclusion:
The interview process was thorough and tested both technical and analytical skills. Preparing case studies and revising SQL concepts were crucial. Being honest and clear about career goals during the HR round also helped.

Company Name: Swiggy

Position: Business Analyst

Location: [Not specified]

Application Process: I applied through Naukri.com and was interviewed in February 2024.

Interview Rounds:

  • Round 1 - Coding Test:

    • Questions Asked: Mostly SQL questions of moderate difficulty.
    • Your Approach: I focused on writing efficient queries and ensuring I understood the problem requirements clearly before jumping into coding.
    • Outcome: I passed this round and moved to the next stage.
  • Round 2 - One-on-One Round:

    • Questions Asked:
      1. SQL joins and subqueries.
      2. Window functions.
    • Your Approach: I explained the concepts clearly and provided examples where necessary. For window functions, I demonstrated how they could be used in real-world scenarios.
    • Outcome: The interview went well, and I received positive feedback.

Preparation Tips:

  • Brush up on SQL concepts, especially joins, subqueries, and window functions.
  • Practice writing efficient and optimized queries.
  • Understand real-world applications of SQL to explain concepts better during interviews.

Conclusion:
Overall, the interview process was smooth, and the questions were aligned with the role’s requirements. I could have practiced more complex SQL scenarios beforehand, but my preparation was sufficient to clear the rounds. For future candidates, I’d recommend focusing on SQL fundamentals and their practical applications.

Company Name: Swiggy

Position: Business Analyst

Application Process: I applied via a referral and was interviewed before October 2023.

Interview Rounds:

  • Round 1 - Coding Test:

    • Questions Asked: The round focused on SQL and Python, along with some questions about my work experience.
    • Your Approach: I brushed up on my SQL queries and Python basics beforehand and ensured I could articulate my past work clearly.
    • Outcome: Successfully cleared this round.
  • Round 2 - Technical Round:

    • Questions Asked:
      1. How to handle outliers?
      2. What is skewness and its types?
    • Your Approach: For outliers, I discussed techniques like trimming, winsorizing, and transformation. For skewness, I explained its definition and the difference between positive and negative skewness.
    • Outcome: Cleared this round as well.
  • Round 3 - Case Study Round:

    • Questions Asked: The round included a guesstimate question and other problem-solving scenarios.
    • Your Approach: I structured my answers logically, breaking down the guesstimate into smaller parts and using assumptions where necessary. For problem-solving, I focused on clarity and practicality.
    • Outcome: Successfully navigated this round.

Preparation Tips:

  • Focus on SQL and Python basics, especially for data manipulation.
  • Revise statistical concepts like outliers, skewness, and data distributions.
  • Practice guesstimates and case studies to improve problem-solving skills.

Conclusion:
The interview process was thorough but fair. I felt well-prepared for the technical and case study rounds, but practicing more guesstimates beforehand would have been helpful. My advice for future candidates is to focus on both technical skills and structured problem-solving.

Company Name: Swiggy

Position: Business Analyst

Location: (Not specified)

Application Process: I applied for the Business Analyst role at Swiggy through Naukri.com in September 2023.

Interview Rounds:

  • Round 1 - Resume Shortlist:

    • Questions Asked: No specific questions were asked in this round. The focus was on reviewing my resume.
    • Your Approach: I ensured my resume was concise and highlighted relevant skills and experiences for the role.
    • Outcome: My resume was shortlisted, and I moved to the next round.
  • Round 2 - Coding Test (Advance SQL):

    • Questions Asked: The test was conducted on HackerRank and focused on advanced SQL concepts.
    • Your Approach: I practiced SQL queries extensively beforehand, focusing on joins, subqueries, and window functions.
    • Outcome: I performed well and advanced to the next round.
  • Round 3 - Technical Round:

    • Questions Asked:
      1. SQL and business case questions.
      2. Questions on joins and window functions.
    • Your Approach: I tackled the SQL questions methodically and explained my thought process clearly. For the business case, I structured my answer logically.
    • Outcome: The interview went well, and I received positive feedback.

Preparation Tips:

  • Focus on mastering SQL, especially joins and window functions.
  • Practice solving business case studies to improve analytical thinking.
  • Keep your resume updated and tailored to the role.

Conclusion:
Overall, the interview process was smooth and well-structured. I felt prepared for each round, but I could have practiced more complex SQL scenarios. My advice to future candidates is to thoroughly prepare for SQL and business case questions, as they are critical for this role.

Company Name: Swiggy

Position: Business Analyst

Location: [Location not specified]

Application Process: [Application process details not provided]

Interview Rounds:

  • Round 1 - Weekend Interview (13 Nov 2021):
    • Questions Asked: [Specific questions not provided]
    • Your Approach: [Approach details not provided]
    • Outcome: The interview process was helpful in improving my interview practice for other companies. The HR provided constructive feedback, which was valuable for future interviews.

Conclusion:

The overall experience with Swiggy was positive, and the feedback from the HR was particularly useful for my subsequent interviews. It was a great learning opportunity, and I appreciated the supportive environment.