The candidate expressed frustration with the hiring process, highlighting concerns about the company’s treatment of employees and the lack of interview opportunities for those who contributed to the company’s growth. The experience was disappointing, and the candidate advises others to be cautious when considering opportunities with the company.
Application Process: Applied online for the position and was invited to take a SQL test along with a business question.
Interview Rounds:
Round 1 - Online Test:
Questions Asked: SQL questions of moderate difficulty and a business-related question.
Your Approach: Prepared for SQL queries and business case scenarios beforehand.
Outcome: Cleared the test and was informed by HR about moving forward to the interview round.
Round 2 - HR Communication:
Questions Asked: None, as the round was about scheduling the interview.
Your Approach: Confirmed availability for the interview.
Outcome: Received an automated email stating my candidature was no longer under consideration without any explanation. When contacted, the HR mentioned my experience didn’t match their requirements.
Conclusion:
The overall experience was disappointing and unprofessional. If my experience was an issue, it should have been addressed earlier in the process. My advice to future candidates is to clarify the role requirements thoroughly before investing time in the application process.
Application Process: The interview process was conducted in a single day, consisting of five intense rounds with 30-minute gaps between each round. Each round lasted approximately 45 minutes.
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked: The interviewer focused on technical aspects relevant to the Business Analyst role, including data analysis, problem-solving, and case studies.
Your Approach: I prepared thoroughly by revising key concepts and practicing case studies. I also made sure to articulate my thought process clearly.
Outcome: Passed to the next round.
Round 2 - Case Study Interview:
Questions Asked: Presented with a real-world business problem to analyze and provide solutions.
Your Approach: Broke down the problem systematically, asked clarifying questions, and proposed data-driven solutions.
Outcome: Successfully moved forward.
Round 3 - Behavioral Interview:
Questions Asked: Focused on past experiences, teamwork, and handling challenging situations.
Your Approach: Used the STAR method to structure my answers and provided specific examples.
Outcome: Advanced to the next round.
Round 4 - Technical Deep Dive:
Questions Asked: In-depth technical questions, including SQL queries and data modeling.
Your Approach: Demonstrated my technical skills and explained my reasoning step-by-step.
Outcome: Cleared the round.
Round 5 - HR Interview:
Questions Asked: Discussed career goals, cultural fit, and expectations from the role.
Your Approach: Kept my answers honest and aligned with the company’s values.
Outcome: Final round completed.
Preparation Tips:
Revise technical concepts thoroughly, especially data analysis and SQL.
Practice case studies and problem-solving under time constraints.
Prepare for behavioral questions using the STAR method.
Interact confidently with the interviewers and clarify doubts when needed.
Conclusion:
The entire process was intense but rewarding. I ensured I was well-prepared and gave my best in each round. My advice to future candidates is to practice rigorously, stay calm, and engage actively with the interviewers. Good luck!
Application Process: The interview process was smooth and streamlined.
Interview Rounds:
Round 1 - Online Technical Test:
Questions Asked: Easy to moderate SQL queries and a business case study (8+1).
Your Approach: Focused on writing efficient SQL queries and analyzing the case study logically.
Outcome: Cleared the round successfully.
Round 2 - SQL Technical Interview:
Questions Asked: Questions to test understanding of basic SQL concepts and their implementation.
Your Approach: Demonstrated a strong grasp of SQL fundamentals and problem-solving skills.
Outcome: Advanced to the next round.
Round 3 - Statistics Interview:
Questions Asked: Hypothesis testing case studies and basic statistics questions.
Your Approach: Applied statistical knowledge to solve the case studies and explained the reasoning clearly.
Outcome: Progressed further in the process.
Round 4 - Business Case Study:
Questions Asked: How to improve sales in a particular area and what metrics to track for a new feature in an e-commerce application.
Your Approach: Analyzed the problem systematically and suggested actionable metrics to measure impact.
Outcome: Cleared the round.
Round 5 - Hiring Manager Interview:
Questions Asked: Strengths and weaknesses, along with interpersonal questions.
Your Approach: Answered honestly and highlighted relevant skills and experiences.
Outcome: Final round completed.
Preparation Tips:
Brush up on SQL basics and practice writing queries.
Revise statistics, especially hypothesis testing and case studies.
Prepare for business case studies by practicing structured problem-solving.
Be ready to discuss your strengths and weaknesses in a constructive manner.
Conclusion:
The overall interview experience was positive and well-structured. The key was to stay calm and think logically during each round. Practicing SQL and case studies beforehand was very helpful. For future candidates, focus on clarity of thought and confidence in your answers.
Application Process: The process began with resume shortlisting, followed by an SQL Hackerrank test. The number of interview rounds varied depending on the candidate.
Interview Rounds:
Round 1 - SQL Hackerrank Test:
Questions Asked: SQL-based questions to test technical proficiency.
Your Approach: Prepared by practicing SQL queries on platforms like Hackerrank and LeetCode. Focused on joins, subqueries, and aggregations.
Outcome: Cleared the test and moved to the next round.
Round 2 - Technical Interview:
Questions Asked: Questions on SQL and data visualization tools.
Your Approach: Revised SQL concepts and brushed up on visualization tools like Tableau or Power BI. Demonstrated problem-solving skills by explaining queries step-by-step.
Outcome: Successfully cleared the round.
Preparation Tips:
Practice SQL extensively, especially joins, aggregations, and subqueries.
Familiarize yourself with data visualization tools like Tableau or Power BI.
Solve real-world business problems using SQL to understand practical applications.
Conclusion:
The interview process was smooth and focused on technical skills. Practicing SQL and visualization tools beforehand was crucial. For future candidates, I’d recommend dedicating time to hands-on practice and understanding business use cases for SQL queries.
Questions Asked: Comprehensive SQL-based test with questions of varying difficulty.
Your Approach: Focused on solving at least 4-5 questions to ensure passing.
Outcome: Successfully cleared the round.
Round 2 - Technical + Statistics Round:
Questions Asked: Basic SQL queries and logic questions, along with a statistics question.
Your Approach: Prepared by revising SQL fundamentals and basic statistical concepts.
Outcome: Advanced to the next round.
Round 3 - Problem Solving Round:
Questions Asked: Problem-solving questions where the interviewer was adamant about the answer rather than the approach or assumptions.
Your Approach: Tried to align answers with the interviewer’s expectations, though it was challenging due to their focus on specific answers.
Outcome: Cleared the round, but found it less about problem-solving skills and more about matching the interviewer’s expectations.
Round 4 - Hiring Manager Round:
Questions Asked: Standard hiring manager questions, with a focus on problem-solving. The interviewer expected specific answers and didn’t prioritize the candidate’s ability or approach.
Your Approach: Attempted to provide precise answers, though the lack of flexibility was frustrating.
Outcome: Cleared the round, but felt the process was rigid.
Preparation Tips:
Focus on mastering SQL queries of varying difficulty levels.
Brush up on basic statistical concepts.
Be prepared for problem-solving rounds where the interviewer may prioritize specific answers over your approach.
Conclusion:
The interview process was rigorous, with a strong emphasis on SQL and problem-solving. While the technical rounds were manageable, the problem-solving rounds were challenging due to the interviewers’ focus on specific answers rather than the thought process. Future candidates should prepare to align their answers closely with the interviewer’s expectations, even if it feels restrictive.
Application Process: Applied through an online portal. The process was straightforward, and the interviewer was punctual.
Interview Rounds:
Round 1 - Screening Interview:
Questions Asked:
Basic SQL queries and concepts.
Fundamental statistics questions.
A few business case scenarios to assess problem-solving skills.
Your Approach:
For SQL, I reviewed common queries and joins beforehand.
For statistics, I brushed up on basic concepts like mean, median, and standard deviation.
For business cases, I focused on structuring my answers logically.
Outcome: Cleared the round. The interviewer provided positive feedback on my problem-solving approach.
Round 2 - Technical Interview (Upcoming):
Details: This will be a 1-on-1 technical round, likely delving deeper into SQL, statistics, and business analysis.
Preparation Tips:
Revise SQL thoroughly, especially joins, subqueries, and window functions.
Brush up on basic statistical concepts and their applications in business.
Practice solving business cases to improve structured thinking.
Conclusion:
The first round was a smooth experience, and the interviewer was supportive. I feel confident about the upcoming technical round but plan to focus more on advanced SQL and case studies to ensure I’m fully prepared.
Application Process: The application process was streamlined, starting with an online assessment followed by technical and case study rounds. The team managed the process efficiently.
Interview Rounds:
Round 1 - HackerRank Assessment:
Questions Asked: The round included SQL queries and problem-solving questions.
Your Approach: Focused on writing efficient SQL queries and solving problems logically.
Outcome: Cleared the round successfully.
Round 2 - Technical SQL Interview:
Questions Asked: In-depth SQL queries, optimization techniques, and database-related questions.
Your Approach: Demonstrated strong SQL skills and explained optimization strategies clearly.
Outcome: Advanced to the next round.
Round 3 - Case Study and Behavioral Analysis:
Questions Asked: Case study on a business scenario, followed by behavioral questions like teamwork and problem-solving.
Your Approach: Analyzed the case methodically and answered behavioral questions with real-life examples.
Outcome: Performed well and received positive feedback.
Preparation Tips:
Practice SQL queries extensively, especially joins, subqueries, and optimization.
Brush up on case study frameworks for business scenarios.
Prepare for behavioral questions using the STAR method.
Conclusion:
The overall interview experience was smooth and well-organized. The technical rounds were challenging but fair, while the case study round tested practical application. I could have prepared more for behavioral questions to articulate my thoughts better. For future candidates, focus on SQL and case studies, and don’t overlook the behavioral aspect!
Application Process: [Application process details not provided]
Interview Rounds:
Round 1 - Technical Interview (SQL):
Questions Asked:
Define the lead and lag functions in SQL.
Provide examples of how lead and lag functions can be used to retrieve data from the next or previous rows in a result set.
Discuss scenarios where lead and lag functions are particularly useful, such as analyzing time-series data or detecting changes in values over consecutive rows.
Explain the purpose of the row number function in SQL.
Illustrate how the row number function can be used to assign a unique sequential integer to each row in a result set.
Discuss practical applications of the row number function, such as paging through large result sets or generating row-level identifiers.
Differentiate between the rank and dense rank functions in SQL.
Provide examples demonstrating how rank and dense rank functions assign ranks to rows based on specified criteria.
Discuss the differences in behavior between rank and dense rank functions, particularly in scenarios involving ties or duplicate values.
Your Approach:
For the lead and lag functions, I explained their definitions and provided examples using hypothetical datasets to show how they fetch data from adjacent rows. I also discussed their utility in time-series analysis.
For the row number function, I described its role in assigning unique identifiers and demonstrated its use in pagination.
For rank and dense rank, I highlighted the key differences, especially in handling ties, and gave examples to clarify the distinction.
Outcome: [Outcome not specified]
Preparation Tips:
Brush up on SQL window functions, especially lead, lag, row_number, rank, and dense_rank.
Practice writing queries to solve real-world problems like time-series analysis or ranking scenarios.
Understand the nuances between similar functions (e.g., rank vs. dense_rank) to explain them clearly.
Conclusion:
The interview was heavily focused on SQL window functions, which are crucial for a Business Analyst role. While I felt confident in explaining the concepts, I could have prepared more real-world examples to make my answers more impactful. For future candidates, I recommend practicing these functions thoroughly and being ready to apply them to practical scenarios.
Application Process: The application process involved multiple rounds of interviews conducted back-to-back in a single day. The entire process lasted around 6-7 hours and included an SBA round, LBA round, and managers’ round. The process was smooth and quick, and I received an offer within 2 days.
Interview Rounds:
Round 1 - SBA Round:
Questions Asked: [Details not provided]
Your Approach: [Details not provided]
Outcome: Passed to the next round
Round 2 - LBA Round:
Questions Asked: [Details not provided]
Your Approach: [Details not provided]
Outcome: Passed to the next round
Round 3 - Managers’ Round:
Questions Asked: [Details not provided]
Your Approach: [Details not provided]
Outcome: Passed and received an offer
Conclusion:
The overall experience was smooth and efficient, with the entire process completed in a single day. The interviewers were professional, and the feedback loop was quick, as I received an offer within 2 days. For future candidates, I would recommend being prepared for a long day of interviews and ensuring clarity in communication during each round.
Application Process: I applied for the position via LinkedIn and was interviewed before May 2020.
Interview Rounds:
Round 1 - Technical & Business Acumen:
Questions Asked: Questions covered SQL, Python, Statistics, and Business Case Studies/Metrics.
Your Approach: I focused on demonstrating my technical expertise in SQL and Python while also showcasing my ability to apply statistical knowledge to business problems. For the case studies, I emphasized problem-solving and logical reasoning.
Outcome: Successfully cleared the round.
(Additional rounds were conducted, but specific details were not provided.)
Preparation Tips:
Be proficient in SQL, Python, and Statistics.
Develop strong business acumen to differentiate yourself from other candidates. Focus on problem-solving skills and understanding business metrics.
Practice case studies to improve your ability to identify and solve business problems using technology.
Conclusion:
The interview process was rigorous but rewarding. What worked well for me was my technical expertise combined with a strong understanding of business problems. For future candidates, I’d recommend balancing technical skills with business knowledge to stand out in the role of a Business Analyst.
Application Process: I was interviewed at Swiggy’s Bangalore office. The process was quick, with three rounds completed in just 2 hours.
Interview Rounds:
Round 1 - SQL Round:
Questions Asked: The interviewer tested my SQL knowledge with queries related to data extraction, joins, and aggregations.
Your Approach: I approached the questions methodically, ensuring I understood the requirements before writing the queries. I also optimized my queries for performance where possible.
Outcome: I passed this round and moved on to the next.
Round 2 - Business Round:
Questions Asked: This round focused on business scenarios, such as analyzing metrics, understanding user behavior, and suggesting improvements for Swiggy’s services.
Your Approach: I used a structured approach, breaking down the problems into smaller parts and providing data-driven solutions. I also asked clarifying questions to ensure I addressed the core issues.
Outcome: The interviewer seemed satisfied with my responses, and I advanced to the final round.
Round 3 - Managerial Round:
Questions Asked: This round was more about my problem-solving skills, leadership potential, and how I would handle challenges in a managerial role.
Your Approach: I shared examples from my past experiences to demonstrate my ability to lead and solve problems under pressure. I also emphasized my adaptability and willingness to learn.
Outcome: The round went well, and the HR called me the next day to inform me that I was selected for the role.
Conclusion:
The entire interview process was smooth and well-organized. I felt prepared for the technical and business rounds, but the managerial round was a bit challenging. Overall, it was a great learning experience, and I’m excited to join Swiggy!
Application Process: The application process involved a one-day interview with five rounds, each lasting 45 minutes. There was a 30-minute gap between each round to allow for preparation and mental reset. The entire process was quite intense, so thorough preparation was key.
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked: The interviewer asked about my understanding of business analytics, data interpretation, and problem-solving skills. They also gave a case study to analyze.
Your Approach: I focused on structuring my answers clearly and logically, ensuring I addressed the case study with a step-by-step approach.
Outcome: Passed to the next round.
Round 2 - Case Study Interview:
Questions Asked: This round was entirely case-based, focusing on real-world business scenarios. I was asked to analyze data and propose solutions.
Your Approach: I used frameworks like SWOT and Porter’s Five Forces to break down the problem and present a structured solution.
Outcome: Advanced to the next round.
Round 3 - Behavioral Interview:
Questions Asked: Questions revolved around teamwork, conflict resolution, and handling pressure.
Your Approach: I shared specific examples from my past experiences, highlighting my problem-solving and interpersonal skills.
Outcome: Cleared this round successfully.
Round 4 - Technical Deep Dive:
Questions Asked: This round tested my technical knowledge in-depth, including SQL queries, data visualization, and statistical concepts.
Your Approach: I ensured I was thorough with my fundamentals and practiced explaining my thought process clearly.
Outcome: Moved to the final round.
Round 5 - HR Interview:
Questions Asked: The HR round focused on my motivation for joining Swiggy, career goals, and cultural fit.
Your Approach: I was honest and enthusiastic about my interest in the role and the company.
Outcome: Received positive feedback and an offer.
Preparation Tips:
Practice case studies and technical concepts thoroughly.
Be ready to explain your thought process clearly.
Prepare for behavioral questions with real-life examples.
Stay calm and composed during the intense interview process.
Conclusion:
The interview process at Swiggy was challenging but rewarding. Each round tested different skills, and the intensity required me to be on top of my game. Interacting confidently with the interviewers and staying prepared helped me succeed. My advice to future candidates is to practice well, stay confident, and give your best in every round. Good luck!
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 for the coding part and structured my case study answer 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 hypotheses for this, and what metrics will you check?
Your Approach: For the SQL questions, I used my knowledge of window functions and joins. For the hypothesis question, I framed it statistically and listed relevant metrics like adoption rate and transaction success rate.
Outcome: Cleared this round successfully.
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% discount to customers with a rating of 4.5 or above. How would you analyze whether this scheme is beneficial?
Flipkart’s sales this week were lower than last week, and there were no schemes run by competitors. What metrics will you check, and what framework will 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 statistical significance and customer segmentation. For Flipkart, I looked at internal factors like inventory or website issues. For Myntra, I analyzed data like customer density and purchasing patterns.
Outcome: Successfully cleared this round.
Preparation Tips:
Practice SQL extensively, especially window functions and joins.
Brush up on statistical concepts like hypothesis testing and metrics analysis.
Work on case studies to improve your problem-solving framework.
Conclusion:
The interview process was thorough and tested both technical and analytical skills. The key was to stay calm and think logically. For future candidates, I’d recommend practicing real-world case studies and being clear in your thought process during interviews.
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, experience, and why I wanted to join Swiggy.
Your Approach: I kept my answers concise and focused on my relevant skills and enthusiasm for the role.
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 highlighted key projects and achievements, ensuring alignment with the Business Analyst role.
Outcome: Successfully cleared 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 focused on logical structuring for problem-solving.
Outcome: Passed this round with positive feedback.
Round 4 - Manager Case Interview (1):
Questions Asked: A business case study to analyze and provide recommendations.
Your Approach: I broke down the problem, used frameworks, and justified my recommendations with data.
Outcome: Advanced to the next round.
Round 5 - Manager Case Interview (2):
Questions Asked: Another case study, more complex, focusing on Swiggy’s business model.
Your Approach: I applied industry knowledge and linked my solutions to Swiggy’s operations.
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 Swiggy’s values.
Outcome: Received a positive response and moved forward in the process.
Preparation Tips:
Brush up on SQL and data analysis concepts.
Practice case studies using frameworks like SWOT or Porter’s Five Forces.
Research Swiggy’s business model and recent trends in the food delivery industry.
Conclusion:
The interview process was well-structured and challenging. I felt prepared for the technical and case rounds, but I could have researched Swiggy’s recent initiatives more deeply. My advice to future candidates is to focus on both technical skills and business acumen, and to stay calm and structured during case interviews.
Application Process: I applied through the company website and was interviewed before June 2022.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: N/A (Resume screening round)
Your Approach: Ensured my resume was concise and highlighted relevant skills and experiences.
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 structured the case study logically.
Outcome: Cleared the round.
Round 3 - Technical Round 1:
Questions Asked: SQL and Statistics screening.
Your Approach: Prepared SQL concepts and basic statistics beforehand.
Outcome: Advanced to the next round.
Round 4 - Technical Round 2:
Questions Asked: Business case studies, guesstimates, and a little technical.
Your Approach: Used frameworks for case studies and practiced guesstimates.
Outcome: Cleared the round.
Round 5 - Hiring Manager Round:
Questions Asked: Complete profile screening, checking if the candidate is suited for the role, case studies, and guesstimates.
Your Approach: Aligned my responses with the role’s requirements and demonstrated problem-solving skills.
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: Answered honestly about my career goals and researched Swiggy’s values beforehand.
Outcome: Final selection.
Preparation Tips:
Focus on SQL and case studies for technical rounds.
Practice guesstimates and business case frameworks.
Align your answers with the company’s values and role requirements.
Conclusion:
The interview process was thorough and tested both technical and problem-solving skills. Preparing for SQL and case studies was crucial. I could have practiced more guesstimates to feel more confident. Overall, it was a great learning experience!
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 hypotheses for this, and what metrics will you check?
Your Approach: For the SQL questions, I ensured my queries were optimized. For the hypothesis question, I framed it statistically and listed relevant metrics like adoption rate and transaction success rate.
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 expand offline. Using Myntra’s data, which city would you choose to open an outlet?
Your Approach: For the Uber question, I considered A/B testing and customer segmentation. For Flipkart, I focused on internal metrics like traffic sources and conversion rates. For Myntra, I analyzed customer density and purchasing patterns.
Outcome: Successfully cleared the round.
Preparation Tips:
Practice SQL extensively, especially ranking functions and joins.
Familiarize yourself with hypothesis testing and metrics for business scenarios.
Work on case studies to improve analytical thinking.
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 the importance of practicing more real-world business scenarios. My advice to future candidates is to focus on practical applications of data analysis and be ready to think on your feet.
Application Process: Applied via the company website before June 2022.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: Resume screening to shortlist candidates.
Your Approach: Ensured my resume was concise, relevant, and free of unnecessary personal details.
Outcome: Cleared the round.
Round 2 - Coding Test:
Questions Asked: 8 SQL questions with increasing complexity and 1 case study.
Your Approach: Focused on solving SQL queries efficiently and structured the case study logically.
Outcome: Cleared the round.
Round 3 - Technical Round (Screening):
Questions Asked: SQL and statistics screening.
Your Approach: Prepared SQL concepts and basic statistics thoroughly.
Outcome: Cleared the round.
Round 4 - Technical Round (Case Studies):
Questions Asked: Business case studies, guesstimates, and some technical questions.
Your Approach: Practiced case studies and guesstimates beforehand and applied logical reasoning.
Outcome: Cleared the round.
Round 5 - Hiring Manager Round:
Questions Asked: Profile screening, suitability for the role, case studies, and guesstimates.
Your Approach: Highlighted my relevant skills and experience, and approached case studies methodically.
Outcome: Cleared the 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 my career goals and aligned them with Swiggy’s values.
Outcome: Cleared the round.
Preparation Tips:
Focus on SQL and statistics for the technical rounds.
Practice business case studies and guesstimates to improve logical reasoning.
Ensure your resume is tailored and free of irrelevant details.
Conclusion:
The interview process was thorough and tested both technical and analytical skills. Preparing case studies and SQL queries in advance helped me perform well. I would advise future candidates to focus on these areas and be clear about their career motivations when answering HR questions.
Application Process: The application process was swift and completed within 2 days. It consisted of 4 rounds, including a CV screening, a technical round, two 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 demonstrating my enthusiasm for the company.
Outcome: Passed to the next round.
Round 2 - CV Screening:
Questions Asked: Detailed discussion about my resume, past projects, and relevant experiences.
Your Approach: I highlighted key projects and how they prepared me for the Business Analyst role.
Outcome: Cleared this round and moved to the technical round.
Round 3 - Technical Round:
Questions Asked: Questions on SQL, data analysis, and problem-solving scenarios.
Your Approach: I used examples from my past work to explain my technical skills and thought process.
Outcome: Successfully passed this round.
Round 4 - Manager Case Interview (1):
Questions Asked: Case study on improving Swiggy’s delivery efficiency.
Your Approach: I structured my answer using a framework (e.g., problem definition, analysis, solution, and impact).
Outcome: Advanced to the next case interview round.
Round 5 - Manager Case Interview (2):
Questions Asked: Another case study, this time on customer retention strategies.
Your Approach: I focused on data-driven insights and actionable recommendations.
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 emphasized my alignment with Swiggy’s values.
Outcome: Received a positive response.
Preparation Tips:
Brush up on SQL and data analysis concepts.
Practice case studies using frameworks like MECE or SWOT.
Research Swiggy’s business model and recent trends in the food delivery industry.
Conclusion:
The interview process was well-structured and gave me a good understanding of Swiggy’s expectations. I could have prepared more case studies beforehand, but overall, it was a great learning experience. My advice to future candidates is to focus on both technical skills and business acumen, and to practice articulating their thoughts clearly during case interviews.
Application Process: The interview process was conducted in a single day, consisting of five intense rounds. Each round lasted approximately 45 minutes, with a 30-minute break between rounds. The entire process was highly interactive and required thorough preparation.
Interview Rounds:
Round 1 - Case Study/Problem Solving:
Questions Asked: The interviewer presented a business problem related to Swiggy’s operations and asked for a structured approach to solve it.
Your Approach: I broke down the problem into smaller components, analyzed the data provided, and proposed a solution with clear reasoning.
Outcome: The interviewer appreciated the structured approach and moved me to the next round.
Round 2 - Technical/Data Analysis:
Questions Asked: Questions revolved around SQL queries, data interpretation, and how to derive insights from a given dataset.
Your Approach: I wrote efficient SQL queries and explained my thought process behind each step. For data interpretation, I focused on actionable insights.
Outcome: The interviewer seemed satisfied with my technical skills, and I advanced to the next round.
Round 3 - Behavioral/HR:
Questions Asked: Questions about my past experiences, challenges faced, and how I handled teamwork and conflicts.
Your Approach: I shared specific examples from my previous roles, highlighting my problem-solving and collaboration skills.
Outcome: The interviewer found my responses genuine and moved me forward.
Round 4 - Business Strategy:
Questions Asked: A hypothetical scenario was given where I had to devise a strategy to improve Swiggy’s customer retention.
Your Approach: I outlined a multi-step strategy, including customer feedback analysis, loyalty programs, and personalized marketing.
Outcome: The interviewer engaged in a detailed discussion, and I progressed to the final round.
Round 5 - Leadership/Scenario-Based:
Questions Asked: A high-pressure scenario was presented where I had to make quick decisions as a leader.
Your Approach: I prioritized tasks, delegated responsibilities, and communicated a clear action plan.
Outcome: The interviewer appreciated my leadership approach, concluding the interview process.
Preparation Tips:
Practice case studies and business problem-solving regularly.
Brush up on SQL and data analysis techniques.
Prepare for behavioral questions with real-life examples.
Stay updated with Swiggy’s business model and industry trends.
Mock interviews can help simulate the intense environment.
Conclusion:
The entire interview process was challenging but rewarding. Each round tested different skills, from technical to strategic thinking. I could have prepared more case studies beforehand, but overall, I gave my best. My advice to future candidates is to stay calm, interact confidently with the interviewers, and practice extensively. Good luck!