Company Name: Swiggy
Position: Business Analyst
Application Process: I applied via the company website and was interviewed in September 2023.
Interview Rounds:
-
Round 1 - Coding Test:
- Questions Asked: SQL and a case study. The test was an hour long.
- Your Approach: Focused on writing efficient SQL queries and analyzing the case study thoroughly.
- Outcome: Cleared the round successfully.
-
Round 2 - Technical Round:
- Questions Asked: Mostly SQL-based questions.
- Your Approach: Prepared by revising SQL concepts and practicing queries beforehand.
- Outcome: Advanced to the next round.
-
Round 3 - Technical Round:
- Questions Asked: Statistics, data visualization, and SQL again.
- Your Approach: Brushed up on statistical concepts and practiced data visualization tools.
- Outcome: Cleared the round.
-
Round 4 - Behavioral Round:
- Questions Asked: Job fit and more SQL.
- Your Approach: Prepared by aligning my skills with the job requirements and practicing behavioral questions.
- Outcome: Successfully cleared the final round.
Preparation Tips:
- Focus on SQL as it was a recurring theme in all rounds.
- Practice case studies and data visualization tools.
- Revise statistical concepts and prepare for behavioral questions.
Conclusion:
The interview process was thorough but manageable with the right preparation. SQL was a major focus, so I’d advise future candidates to strengthen their SQL skills. Overall, it was a great learning experience!
Company Name: Swiggy
Position: Business Analyst
Location: [Not specified]
Application Process: Applied via LinkedIn and was interviewed in August 2024.
Interview Rounds:
Preparation Tips:
- Be very well-prepared with SQL, including advanced concepts and problem-solving.
- Practice writing and optimizing SQL queries for various scenarios.
Conclusion:
Overall, the interview process was smooth and focused heavily on SQL skills. Being thorough with SQL and able to explain projects clearly helped a lot. For future candidates, I’d recommend practicing SQL extensively and being ready to discuss your projects in detail.
Company Name: Swiggy
Position: Business Analyst
Application Process: I applied for the role via LinkedIn and was interviewed before May 2020.
Interview Rounds:
-
Round 1 - Technical Screening:
- Questions Asked: Questions covered SQL, Python, Statistics, and Business Case Studies/Metrics.
- Your Approach: I focused on demonstrating my technical proficiency in SQL and Python, while also highlighting my understanding of statistical concepts. For the business case studies, I tried to approach them methodically, breaking down problems and proposing data-driven solutions.
- Outcome: I advanced to the next round.
-
Round 2 - Technical Deep Dive:
- Questions Asked: More in-depth questions on SQL queries, Python scripting, and statistical analysis.
- Your Approach: I ensured my answers were detailed and included real-world applications of the concepts. I also emphasized my ability to translate business problems into technical solutions.
- Outcome: Successfully cleared this round.
-
Round 3 - Business Case Study:
- Questions Asked: A business scenario was presented, and I was asked to identify key metrics, potential problems, and solutions.
- Your Approach: I structured my response by first understanding the business context, identifying the core issues, and then proposing actionable solutions backed by data.
- Outcome: Moved forward in the process.
-
Round 4 - Final Interview:
- Questions Asked: A mix of technical and behavioral questions, focusing on my problem-solving approach and alignment with Swiggy’s business goals.
- Your Approach: I balanced technical answers with examples of how I’ve applied these skills in past projects. I also shared my enthusiasm for the role and the company.
- Outcome: Received a positive response.
Preparation Tips:
- Technical Skills: Be thorough with SQL, Python, and Statistics. Practice writing efficient queries and scripts.
- Business Acumen: Understand how to translate business problems into data-driven solutions. Familiarize yourself with common business metrics and case studies.
- Problem-Solving: Work on structuring your thoughts clearly and logically when tackling case studies or open-ended questions.
Conclusion:
The interview process was rigorous but rewarding. What worked well for me was my strong technical foundation and my ability to think critically about business problems. If I could do anything differently, I’d spend more time practicing case studies to refine my problem-solving approach. For future candidates, focus on both technical and business aspects—Swiggy values candidates who can bridge the gap between data and business impact.
Company Name: Swiggy
Position: Business Analyst
Application Process: I applied for the Business Analyst role at Swiggy through Naukri.com and was interviewed in April 2024.
Interview Rounds:
Preparation Tips:
- Practice SQL extensively, especially self-joins and window functions.
- Work on case studies related to business metrics like CTR, conversion rates, etc.
- Understand the basics of RCA and how to present findings logically.
Conclusion:
Overall, the interview process was smooth and well-structured. The technical rounds tested my SQL skills thoroughly, while the case study round evaluated my analytical thinking. I would advise future candidates to focus on SQL and case study preparation, as these are key for the Business Analyst role at Swiggy.
Company Name: Swiggy
Position: Business Analyst
Application Process: Applied through the company’s career portal.
Interview Rounds:
-
Round 1 - Technical Interview:
-
Questions Asked: Focused on solving problems using SQL queries, despite the candidate’s preference for PySpark and Python.
-
Your Approach: Provided one-line PySpark answers but was expected to write longer SQL queries.
-
Outcome: The interviewer’s condescending tone and insistence on SQL led to a negative experience.
-
Round 2 - Business Problem Solving:
-
Questions Asked: Thought-provoking business-related questions.
-
Your Approach: Engaged enthusiastically with the interviewer, who was humble and attentive.
-
Outcome: Positive interaction, but the candidate felt the first round’s negativity impacted the overall outcome.
-
Round 3 - Hiring Manager Discussion:
-
Questions Asked: Knowledgeable questions from the senior manager, Nakul.
-
Your Approach: Answered all questions to the best of their ability.
-
Outcome: Despite a good discussion, the candidate was rejected, possibly due to the first round’s issues.
Conclusion:
The interview process had its highs and lows. The business round and hiring manager discussion were highlights, but the technical round’s negative experience overshadowed the overall impression. Future candidates should be prepared for a mix of technical and business-focused rounds and ensure they handle unexpected challenges diplomatically.
Company Name: Swiggy
Position: Business Analyst
Application Process: I was approached by the company for this role and interviewed in March 2024.
Interview Rounds:
Preparation Tips:
- Focus on SQL, especially window functions and logic-based queries.
- Practice case studies to improve problem-solving and analytical skills.
Conclusion:
Overall, the interview process was thorough and tested both technical and analytical skills. Preparing SQL and case studies in advance was key. I’d advise future candidates to focus on these areas and stay calm during the interviews.
Company Name: Swiggy
Position: Business Analyst
Application Process: I applied for the Business Analyst role at Swiggy through Naukri.com and was interviewed in April 2024.
Interview Rounds:
Preparation Tips:
- Brush up on SQL concepts, especially joins, DDL, and DML.
- Practice explaining your projects concisely, focusing on measurable outcomes.
- Be ready to discuss your current role and responsibilities in detail.
Conclusion:
Overall, the interview process was smooth and well-structured. I felt prepared, but I could have practiced more SQL edge cases to ensure I answered every question perfectly. My advice for future candidates is to focus on both technical and behavioral aspects, as Swiggy values clarity and impact in responses.
Company Name: Swiggy
Position: Business Analyst
Location: [Not specified]
Application Process: [Not specified]
Interview Rounds:
-
Round 1 - [Not specified]:
-
Questions Asked: [Not specified]
-
Your Approach: [Not specified]
-
Outcome: Passed
-
Round 2 - [Not specified]:
-
Questions Asked: [Not specified]
-
Your Approach: [Not specified]
-
Outcome: Passed
(Additional rounds were conducted, but details are not provided.)
Conclusion:
Had a fantastic interview process with Swiggy for the Business Analyst role. The opportunity to work with Swiggy as a BA is life-changing, but unfortunately, I had to decline the offer due to personal and relocation reasons. The HR SPOC, Raksha Singh, was very accommodating and understanding of my situation, especially since I had to back out at the final stage after several hours of interview rounds. Thank you, team Swiggy, especially Raksha, for a great interview experience!
Company Name: Swiggy
Position: Business Analyst
Location: [Not specified]
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.
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 skills with the role and demonstrated my enthusiasm for the company.
-
Outcome: Cleared this round and moved to the next stage.
-
Round 2 - CV Screening:
-
Questions Asked: Detailed questions about my resume, past projects, and relevant experiences.
-
Your Approach: I highlighted key projects and explained how they prepared me for the Business Analyst role.
-
Outcome: Successfully passed this round.
-
Round 3 - Technical Round:
-
Questions Asked: Questions on SQL, data analysis, and problem-solving scenarios.
-
Your Approach: I practiced SQL queries beforehand and walked the interviewer through my thought process for problem-solving.
-
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 (e.g., SWOT analysis) and provided data-driven insights.
-
Outcome: Moved to the next round.
-
Round 5 - Manager Case Interview (2):
-
Questions Asked: Another case study, this time focusing on growth strategies for Swiggy.
-
Your Approach: I brainstormed ideas and validated them with logical reasoning.
-
Outcome: Cleared this round and proceeded to the HR round.
-
Round 6 - HR Round:
-
Questions Asked: Questions about my career goals, salary expectations, and cultural fit.
-
Your Approach: I was honest about my expectations and showed enthusiasm for joining Swiggy.
-
Outcome: Received positive feedback and an offer.
Preparation Tips:
- Practice SQL and data analysis concepts thoroughly.
- Familiarize yourself with Swiggy’s business model and recent trends in the food delivery industry.
- Work on structuring case study answers using frameworks like SWOT or Porter’s Five Forces.
Conclusion:
The interview process was well-structured and tested both technical and analytical skills. I felt prepared for most rounds, but I could have practiced more case studies beforehand. My advice to future candidates is to focus on problem-solving frameworks and stay updated on Swiggy’s business strategies.
Company Name: Swiggy
Position: Business Analyst
Location: Bangalore
Application Process: I was contacted for the interview process directly by Swiggy’s HR team after applying online.
Interview Rounds:
Preparation Tips:
- Brush up on SQL queries, especially joins and optimization techniques.
- Practice case studies and estimation problems for business rounds.
- Be ready with examples of leadership and teamwork for managerial rounds.
Conclusion:
Overall, the interview process was smooth and well-structured. The key was staying calm and thinking logically. I could have prepared more real-world examples for the managerial round, but I’m happy with the outcome. For future candidates, focus on clarity and structure in your answers!
Company Name: Swiggy
Position: Business Analyst
Location: (Not specified)
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: I focused on writing efficient SQL queries and structured my case study response logically.
-
Outcome: Passed this round.
-
Round 2 - Technical Round:
-
Questions Asked:
- SQL questions related to rank, dense rank, and joins.
- Flipkart wants to replace its payment options from credit card to UPI. What will be the null and alternate hypothesis for this, and what metrics will you check?
-
Your Approach: For the SQL questions, I used window functions and joins effectively. For the hypothesis question, I framed it as a statistical problem and identified relevant metrics like conversion rates and user feedback.
-
Outcome: Advanced to the next round.
-
Round 3 - One-on-one Round:
-
Questions Asked:
- Your Uber rating is 4.2 for your first 80 rides. Uber has started a new scheme where they give an additional 10% off to customers with a rating of 4.5 or above. How would you analyze whether this scheme is effective?
- 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 analyze this?
- Myntra, which is currently only online, wants to open an offline outlet. Using Myntra’s data, which city would you choose for the outlet?
-
Your Approach: For the Uber question, I considered A/B testing and user segmentation. For Flipkart, I looked at internal factors like inventory, pricing, and user behavior. For Myntra, I analyzed demographics, purchasing patterns, and logistics.
-
Outcome: Cleared the round and received positive feedback.
Preparation Tips:
- Practice SQL extensively, especially window functions and joins.
- Brush up on statistical concepts like hypothesis testing and A/B 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 could have practiced more real-world business scenarios. My advice to future candidates is to focus on practical problem-solving and clear communication.
Company Name: Swiggy
Position: Business Analyst
Application Process: Applied through an online process or referral (details not specified).
Interview Rounds:
- Round 1 - Technical Interview:
- Questions Asked: Questions were primarily focused on SQL and Advanced Excel.
- Your Approach: Prepared thoroughly for SQL and Excel concepts, ensuring clarity in explanations and practical applications.
- Outcome: The interview went very well, but unfortunately, the HR managing the process and the interviewer left the company shortly after. Despite multiple follow-ups, no further communication or response was received.
Conclusion:
The interview experience was positive initially, but the lack of follow-up due to internal changes at Swiggy was disappointing. For future candidates, it’s advisable to stay proactive in follow-ups and also be prepared for unforeseen delays in the hiring process.
Company Name: Swiggy
Position: Business Analyst
Application Process: The process took 1 month. The first round was resume shortlisting, followed by a HackerRank test link. The test included SQL queries (easy to medium difficulty) and a business case study. After clearing the test, the HR informed me about the next interview round, but the process was abruptly halted due to unprofessional handling.
Interview Rounds:
-
Round 1 - Resume Shortlisting:
-
Questions Asked: N/A (Resume-based shortlisting)
-
Your Approach: Ensured my resume highlighted relevant skills and experiences for the Business Analyst role.
-
Outcome: Cleared this round and proceeded to the next stage.
-
Round 2 - HackerRank Test:
-
Questions Asked: SQL queries (easy to medium difficulty) and a business case study.
-
Your Approach: Practiced SQL queries beforehand and reviewed case study frameworks.
-
Outcome: Cleared the test and was informed by HR about the next interview round.
-
Round 3 - HR Communication:
-
Questions Asked: N/A (HR was supposed to schedule the next round).
-
Your Approach: Followed up multiple times but received no response.
-
Outcome: The HR handling my process left the company, and the process was abandoned without any communication.
Conclusion:
Overall, the interview process started well but ended on a disappointing note due to poor communication and unprofessional behavior from Swiggy’s HR team. It’s frustrating when companies don’t respect candidates’ time and effort. My advice to future candidates is to be prepared for such uncertainties and not rely solely on one opportunity. Always keep applying and exploring other options.
Company Name: Swiggy
Position: Business Analyst
Location: [Location not specified]
Application Process: [Application process details not provided]
Interview Rounds:
- Round 1 - [Round Type not specified]:
- Questions Asked: [Questions not specified]
- Your Approach: [Approach not specified]
- Outcome: The interview process was described as quick, seamless, and quite positive, comparable to other top-tier companies. The TA POC, Rishitaa, was highly praised for her proactive communication before and after the interview.
Preparation Tips:
[No preparation tips provided]
Conclusion:
The overall experience was rated 4.5 out of 5 stars, highlighting the smooth and well-coordinated interview process. The candidate appreciated the TA’s efforts in ensuring a seamless experience.
Company Name: Swiggy
Position: Business Analyst
Application Process: Applied through an online portal.
Interview Rounds:
-
Round 1 - HackerRank SQL Round:
- Questions Asked: SQL queries focusing on joins, subqueries, and aggregations.
- Your Approach: Practiced SQL problems on HackerRank and LeetCode beforehand. Took time to understand the problem before writing the query.
- Outcome: Cleared this round.
-
Round 2 - SQL 1:1 Interview:
- Questions Asked: More complex SQL problems, including window functions and query optimization.
- Your Approach: Explained my thought process clearly and optimized queries where possible.
- Outcome: Cleared this round (though later told otherwise).
-
Round 3 - Statistics Round:
- Questions Asked: Probability, hypothesis testing, and basic statistical concepts.
- Your Approach: Revised core statistics topics and applied them to real-world scenarios.
- Outcome: Cleared this round.
-
Round 4 - Business Analytics Round:
- Questions Asked: Case studies on business problems, metrics analysis, and data-driven decision-making.
- Your Approach: Structured my answers using frameworks like STAR and focused on actionable insights.
- Outcome: Cleared this round.
-
Round 5 - Hiring Manager Round:
- Questions Asked: Behavioral questions, alignment with company values, and long-term goals.
- Your Approach: Prepared for behavioral questions using the STAR method and aligned my answers with Swiggy’s mission.
- Outcome: Cleared this round.
Conclusion:
Despite clearing all rounds, I was informed later that I didn’t pass Round 2, which was confusing and disappointing. The mismanagement in communication was unexpected from a company like Swiggy. My advice to future candidates is to clarify feedback immediately after each round to avoid such situations.
Company Name: Swiggy
Position: Business Analyst
Application Process: Applied through an online job portal.
Interview Rounds:
Preparation Tips:
- Brush up on SQL basics and practice writing queries.
- Revise statistical concepts and probability problems.
- Work on case studies to improve business analysis skills.
Conclusion:
Overall, the interview process was smooth but demanding. The SQL round was straightforward, while the business analysis round tested my problem-solving skills. I would advise future candidates to focus on both technical and analytical skills to ace the interview.
Company Name: Swiggy
Position: Business Analyst
Application Process: Applied through the company’s career portal. The process was quick, and I received interview details shortly after applying.
Interview Rounds:
-
Round 1 - SBA Round:
-
Questions Asked:
- Case study related to improving Swiggy’s delivery efficiency.
- How would you handle a situation where a customer complains about late delivery?
-
Your Approach:
- For the case study, I focused on data-driven solutions and suggested optimizing delivery routes using historical data.
- For the customer complaint scenario, I emphasized empathy and quick resolution.
-
Outcome: Cleared this round successfully.
-
Round 2 - LBA Round:
-
Questions Asked:
- How would you analyze the performance of a new feature launched by Swiggy?
- What metrics would you track to measure customer satisfaction?
-
Your Approach:
- I discussed A/B testing and cohort analysis for the new feature.
- For customer satisfaction, I suggested metrics like NPS, repeat order rate, and complaint resolution time.
-
Outcome: Advanced to the next round.
-
Round 3 - Manager Round:
-
Questions Asked:
- Describe a time when you had to work with a cross-functional team.
- How do you prioritize tasks when handling multiple projects?
-
Your Approach:
- Shared an example from my previous internship where I collaborated with tech and marketing teams.
- Explained my prioritization framework based on urgency and impact.
-
Outcome: Cleared this round as well.
-
Round 4 - HR Round:
-
Questions Asked:
- Why do you want to join Swiggy?
- What are your salary expectations?
-
Your Approach:
- Highlighted my interest in data-driven decision-making and Swiggy’s innovative culture.
- Provided a realistic salary range based on market research.
-
Outcome: Received positive feedback and an offer within 2 days.
Preparation Tips:
- Focus on case studies and data-driven problem-solving.
- Brush up on basic business metrics and analytics tools.
- Practice behavioral questions to articulate your experiences clearly.
Conclusion:
The entire process was smooth and well-organized. The interviewers were friendly and focused on problem-solving skills. I could have prepared more on specific Swiggy-related case studies, but overall, it was a great learning experience. My advice to future candidates is to be confident and showcase your analytical thinking clearly.
Company Name: Swiggy
Position: Business Analyst
Location: [Not specified]
Application Process: The application process began with a HackerRank test, followed by five rounds of interviews.
Interview Rounds:
-
Round 1 - Technical Round (SQL & Advanced Excel):
- Questions Asked: Moderate-level SQL queries and Excel-based questions.
- Your Approach: Focused on writing efficient SQL queries and demonstrating proficiency in Excel functions.
- Outcome: Successfully cleared the round.
-
Round 2 - Analytical Round:
- Questions Asked: Questions revolved around Swiggy’s day-to-day operations and analytical scenarios.
- Your Approach: Applied logical reasoning and structured thinking to address the operational challenges.
- Outcome: Advanced to the next round.
-
Round 3 - Problem-Solving Round:
- Questions Asked: Focused on past projects and experiences, including the types of projects I’ve worked on.
- Your Approach: Highlighted relevant projects and problem-solving methodologies.
- Outcome: Cleared the round.
-
Round 4 - Case Study Round:
- Questions Asked: Case studies related to business scenarios.
- Your Approach: Analyzed the cases systematically and proposed actionable solutions.
- Outcome: Progressed to the final round.
-
Round 5 - Director Round:
- Questions Asked: Questions about strengths, weaknesses, and interpersonal skills.
- Your Approach: Answered honestly, focusing on self-awareness and alignment with the role.
- Outcome: Successfully completed the interview process.
Preparation Tips:
- Practice SQL queries and Excel functions thoroughly.
- Familiarize yourself with Swiggy’s business model and operational challenges.
- Prepare case studies and problem-solving frameworks.
- Reflect on your past projects and be ready to discuss them in detail.
Conclusion:
The interview process was comprehensive and tested both technical and analytical skills. Preparing for SQL and case studies was particularly helpful. I would advise future candidates to focus on practical problem-solving and to understand Swiggy’s business deeply.
Company Name: Swiggy
Position: Business Analyst
Application Process: The process involved four rounds, starting with an assignment followed by three online interviews.
Interview Rounds:
-
Round 1 - Assignment Round:
- Questions Asked: SQL questions and a business case study.
- Your Approach: Focused on writing efficient SQL queries and analyzing the case study thoroughly to provide actionable insights.
- Outcome: Cleared the round successfully.
-
Round 2 - Online Interview (SQL & Statistics):
- Questions Asked: SQL queries and statistical concepts.
- Your Approach: Practiced SQL extensively beforehand and brushed up on key statistical concepts like distributions, hypothesis testing, and regression.
- Outcome: Performed well and advanced to the next round.
-
Round 3 - Online Interview (Business Case Study):
- Questions Asked: A detailed business case study to analyze.
- Your Approach: Structured the problem, identified key metrics, and proposed data-driven solutions.
- Outcome: Cleared the round with positive feedback.
-
Round 4 - Final Interview (Business Case Study & Fit):
- Questions Asked: Another business case study and fit questions about teamwork and problem-solving.
- Your Approach: Combined analytical skills with clear communication to present solutions and aligned responses with Swiggy’s business model.
- Outcome: Successfully cleared the round and received the offer.
Preparation Tips:
- Practice SQL queries extensively, especially joins, subqueries, and window functions.
- Revise statistical concepts like probability, distributions, and hypothesis testing.
- Work on case studies to improve problem-solving and structuring skills.
- Understand Swiggy’s business model and recent trends in the food delivery industry.
Conclusion:
The interview process was rigorous but well-structured. Practicing SQL and case studies beforehand was crucial. I could have improved by simulating more timed case studies to manage pressure better. For future candidates, focus on clarity in communication and aligning solutions with business goals.
Company Name: Swiggy
Position: Business Analyst
Location: [Location not specified]
Application Process: [Details not provided]
Interview Rounds:
- Round 1 - Technical & Business Understanding:
- Questions Asked:
- Coding questions
- Technical questions
- Business understanding
- SQL queries
- Project-related questions
- Statistics
- Business case
- Hiring manager questions
- “Why Swiggy?”
- SQL coding
- Your Approach:
- Prepared SQL and coding basics thoroughly.
- Focused on business case studies and statistics.
- Researched Swiggy’s business model to answer “Why Swiggy?” convincingly.
- Outcome: [Result not specified]
Preparation Tips:
- Brush up on SQL and coding fundamentals.
- Practice business case studies and statistics.
- Research the company’s business model and recent developments.
Conclusion:
The interview was comprehensive, covering technical, analytical, and business aspects. Preparing for SQL and business cases was particularly helpful. Would recommend focusing on these areas for future candidates.