Swiggy Business Analyst Interview Questions & Experience Guide

Interview Preparation
,
61

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 my resume was concise and relevant to the role, avoiding unnecessary personal details.

  • Outcome: Shortlisted for 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 logically solving the case study.

  • Outcome: Cleared the round.

  • Round 3 - Technical Round (Screening):

  • Questions Asked: SQL and statistics screening.

  • Your Approach: Demonstrated strong SQL skills and basic statistical knowledge.

  • Outcome: Advanced to the next round.

  • Round 4 - Technical Round (Case Studies):

  • Questions Asked: Business case studies, guesstimates, and some technical questions.

  • Your Approach: Structured my answers logically and used frameworks for case studies.

  • Outcome: Successfully cleared the round.

  • Round 5 - Hiring Manager Round:

  • Questions Asked: Profile screening, suitability for the role, case studies, and guesstimates.

  • Your Approach: Aligned my experience with the role requirements and confidently tackled case studies.

  • Outcome: Moved to the final 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: Highlighted my career aspirations and Swiggy’s alignment with my values.

  • Outcome: Received positive feedback.

Preparation Tips:

  • Focus on SQL and case study preparation.
  • Practice guesstimates and business case frameworks.
  • Ensure your resume is tailored to the role.

Conclusion:
The interview process was thorough and tested both technical and analytical skills. Preparing for SQL and case studies was crucial. I could have practiced more guesstimates to improve my confidence. Overall, it was a great learning experience!

62

Company Name: Swiggy

Position: Business Analyst

Application Process: I applied via the company website and was interviewed in January 2024.

Interview Rounds:

  • Round 1 - Coding Test Round:

    • Questions Asked: Hackerrank SQL questions and one case study question.
    • Your Approach: Focused on writing efficient SQL queries and structured the case study response logically.
    • Outcome: Cleared the round successfully.

  • Round 2 - Technical Round:

    • Questions Asked:
      1. SQL questions related to rank, dense rank, and joins.
      2. Flipkart wants to replace its payment options from credit card to UPI. What will be the null and alternate hypotheses for this, and what metrics will you check?
    • Your Approach: For SQL, I ensured my queries were optimized and covered edge cases. For the hypothesis question, I framed it as a statistical problem and identified key metrics like adoption rate and transaction success rate.
    • Outcome: Advanced to the next round.

  • Round 3 - One-on-one Round:

    • Questions Asked:
      1. Your Uber rating is 4.2 for your first 80 rides. Uber has started a new scheme where they give an additional 10% discount to customers with a rating of 4.5 or above. How would you analyze whether this scheme is effective?
      2. Flipkart’s sales this week were lower than last week, and there were no schemes run by competitors. What metrics would you check, and what framework would you use to diagnose the issue?
      3. Myntra, which is currently only online, wants to open an offline outlet. Using Myntra data, which city would you choose for the outlet?
    • Your Approach: For the Uber question, I considered metrics like customer retention and discount utilization. For Flipkart, I analyzed internal factors like inventory or website performance. For Myntra, I looked at data like customer density and purchasing patterns.
    • Outcome: Awaiting results.

Preparation Tips:

  • Practice SQL extensively, especially window functions and joins.
  • Brush up on statistical concepts like hypothesis testing.
  • Familiarize yourself with case study frameworks for business problems.

Conclusion:
The interview process was thorough and tested both technical and analytical skills. I felt well-prepared for the SQL and case study questions but realized I could improve in framing business problems statistically. For future candidates, I’d recommend practicing real-world business scenarios and being comfortable with data-driven decision-making.

63

Company Name: Swiggy

Position: Business Analyst

Application Process: Applied through the company’s career portal.

Interview Rounds:

  • Round 1 - Technical Interview:

    • Questions Asked:
      • Explain a business problem you solved in the past.
      • How would you analyze user behavior data to improve Swiggy’s services?
      • SQL query to extract specific data from a given dataset.
    • Your Approach:
      • Used the STAR method to explain the business problem.
      • Discussed potential metrics and tools for analyzing user behavior.
      • Wrote and optimized the SQL query on the spot.
    • Outcome: Passed to the next round.

  • Round 2 - Case Study Interview:

    • Questions Asked:
      • Given a scenario where Swiggy’s delivery times have increased, how would you identify the root cause and propose solutions?
      • Estimate the potential revenue impact of introducing a new feature.
    • Your Approach:
      • Broke down the problem into smaller components (e.g., logistics, demand, etc.).
      • Used a structured framework to estimate revenue impact.
    • Outcome: Advanced to the next round.

  • Round 3 - Behavioral Interview:

    • Questions Asked:
      • Describe a time you worked in a team under tight deadlines.
      • How do you handle disagreements with stakeholders?
    • Your Approach:
      • Shared a specific example using the STAR method.
      • Emphasized collaboration and communication skills.
    • Outcome: Moved to the next round.

  • Round 4 - Product Sense Interview:

    • Questions Asked:
      • How would you improve Swiggy’s recommendation system?
      • What metrics would you track to measure the success of a new feature?
    • Your Approach:
      • Suggested A/B testing and user feedback loops.
      • Prioritized metrics like user engagement and retention.
    • Outcome: Advanced to the final round.

  • Round 5 - Leadership Interview:

    • Questions Asked:
      • How would you lead a team to implement a new business strategy?
      • Share an example of a time you took initiative to solve a problem.
    • Your Approach:
      • Highlighted leadership style and past initiatives.
      • Focused on problem-solving and team motivation.
    • Outcome: Received positive feedback and moved forward in the process.

Preparation Tips:

  • Practice SQL and case studies thoroughly.
  • Use frameworks like STAR for behavioral questions.
  • Research Swiggy’s business model and recent updates.
  • Mock interviews helped a lot in building confidence.

Conclusion:
The entire process was intense but rewarding. Each round tested different skills, and the interviewers were very engaging. I could have prepared more on specific product metrics, but overall, it was a great learning experience. My advice: stay calm, think aloud, and interact with the interviewers—it makes a difference! Good luck to future candidates!

64

Company Name: Swiggy

Position: Business Analyst

Application Process: The process was swift and completed within 2 days. It consisted of 4 rounds, including a CV screening, a technical round, 2 manager case interview rounds, and a final HR round. There was also a pre-screening interview before the main rounds.

Interview Rounds:

  • Round 1 - Pre-screening Interview:

  • Questions Asked: General questions about my background, interest in the role, and understanding of Swiggy’s business model.

  • Your Approach: I focused on aligning my experience with the role and demonstrating my enthusiasm for the company.

  • Outcome: Cleared this round and moved to the main interview process.

  • Round 2 - CV Screening:

  • Questions Asked: Detailed questions about my resume, projects, and past experiences.

  • Your Approach: I prepared thoroughly by revisiting my resume and ensuring I could explain every detail clearly.

  • Outcome: Successfully cleared this round.

  • Round 3 - Technical Round:

  • Questions Asked: Questions on SQL, data analysis, and problem-solving scenarios.

  • Your Approach: I brushed up on SQL queries and practiced case studies beforehand.

  • Outcome: Cleared the technical round.

  • Round 4 - Manager Case Interview (1):

  • Questions Asked: A business case study related to Swiggy’s operations.

  • Your Approach: I structured my answer using a framework and focused on logical reasoning.

  • Outcome: Moved to the next round.

  • Round 5 - Manager Case Interview (2):

  • Questions Asked: Another case study, this time more complex, involving data interpretation.

  • Your Approach: I took my time to analyze the data and presented my findings clearly.

  • Outcome: Cleared this round as well.

  • Round 6 - HR Round:

  • Questions Asked: Questions about my career goals, salary expectations, and cultural fit.

  • Your Approach: I was honest and aligned my answers with the company’s values.

  • Outcome: Received a positive response.

Preparation Tips:

  • Practice SQL and data analysis problems.
  • Familiarize yourself with business case frameworks.
  • Be thorough with your resume and past projects.
  • Research Swiggy’s business model and recent updates.

Conclusion:
The overall experience was smooth and well-structured. I felt prepared, but I could have practiced more case studies to improve my confidence. My advice for future candidates is to focus on both technical and analytical skills, and to stay calm during the interviews.