Application Process: [Application process details not provided]
Interview Rounds:
Round 1 - Coding Test:
Questions Asked: [Details not provided]
Your Approach: The test was challenging but manageable. I focused on solving the problems efficiently within the given time.
Outcome: Passed the round.
Round 2 - Case Study:
Questions Asked: [Details not provided]
Your Approach: Analyzed the case thoroughly and presented a structured solution.
Outcome: Passed the round.
Round 3 - Coding Test:
Questions Asked: [Details not provided]
Your Approach: Similar to the first coding round, I prioritized accuracy and time management.
Outcome: Passed the round.
Round 4 - HR Round:
Questions Asked:
Introduction and current job.
Weakness and strength.
What makes you a good fit for the role?
Your Approach: Answered honestly, highlighting my strengths and how they align with the role.
Outcome: [Result not specified]
Preparation Tips:
Focus on coding skills and problem-solving for the technical rounds.
Practice case studies to improve analytical thinking.
Be prepared to discuss your strengths, weaknesses, and fit for the role in the HR round.
Conclusion:
The interview process was thorough and tested both technical and analytical skills. I felt well-prepared for the coding and case study rounds, but I could have practiced more for the HR round to articulate my answers better. For future candidates, I recommend balancing preparation between technical and soft skills.
Questions Asked: 60 questions in 60 minutes covering aptitude and logical reasoning.
Your Approach: Focused on solving questions quickly, practiced from Arun Sharma’s Quantitative Aptitude and Logical Reasoning for CAT. Joined a test series for timed performance analysis.
Outcome: Successfully cleared the round.
Round 2 - Group Discussion:
Questions Asked: General discussion on a given topic, listing problems and solutions.
Your Approach: Listed problems systematically, respected others’ views, and added value by thinking critically.
Outcome: The discussion went well, and the round was cleared.
Round 3 - HR Interview:
Questions Asked: General HR questions, some based on the CV, and a marketing-specific question.
Your Approach: Stayed spontaneous, humorous, and confident. Focused on clear communication and backed answers with strong reasoning.
Outcome: Cleared the round successfully.
Preparation Tips:
For aptitude tests: Practice from Arun Sharma’s Quantitative Aptitude and Logical Reasoning for CAT. Join a test series for timed practice.
For group discussions: Read extensively—follow Google News, newspapers, magazines, and Quora to stay updated on various topics.
For HR interviews: Improve communication skills, stay confident, and have sound knowledge about the industry and company.
Conclusion:
The overall interview experience was enriching. The key takeaways were the importance of time management in aptitude tests, active participation in group discussions, and confidence in HR interviews. Practicing extensively and staying updated on current affairs were crucial for success. For future candidates, focus on building strong analytical and communication skills, and always back your answers with logical reasoning.
Location: Indian Institute of Technology (IIT), Chennai
Application Process: I applied via campus placement at IIT Chennai before April 2023.
Interview Rounds:
Round 1 - Group Discussion Round:
Questions Asked: The topic was given to a group of 10 students.
Your Approach: I actively participated in the discussion, ensuring my points were clear and relevant to the topic. I also made sure to listen to others and build on their ideas.
Outcome: 10 students were shortlisted from this round, and I was one of them.
Round 2 - Technical Round:
Questions Asked:
Guesstimates and business case studies.
Estimate the number of Netflix users in Delhi.
Your Approach: For the guesstimates, I broke down the problem into smaller, manageable parts and used logical assumptions. For the Netflix question, I considered factors like population, internet penetration, and subscription trends.
Outcome: I was able to provide structured answers and moved to the next round.
Round 3 - HR Round:
Questions Asked:
Questions based on situational scenarios and reasons for joining this role.
Your Approach: I answered honestly, aligning my responses with my career goals and the role’s requirements. I also shared examples from my past experiences to support my answers.
Outcome: The round went well, and I felt confident about my responses.
Preparation Tips:
Practice guesstimates and case studies thoroughly.
Brush up on logical reasoning and problem-solving skills.
Be clear about your career goals and how they align with the role.
Conclusion:
Overall, the interview process was smooth and well-structured. The group discussion round was a great way to showcase teamwork, while the technical round tested analytical skills. The HR round was more about fit and motivation. I would advise future candidates to stay calm, think logically, and be genuine in their responses.
Application Process: Applied through the company’s career portal after seeing the job posting. The process involved submitting a resume and a brief cover letter highlighting relevant skills and experiences.
A simple problem-solving question related to data analysis.
Your Approach:
For SQL, I focused on writing efficient queries and explaining my thought process.
For Excel, I demonstrated how I would use functions to manipulate data.
For the problem-solving question, I broke it down into smaller steps and walked the interviewer through my reasoning.
Outcome: Cleared this round and moved to the next stage.
Round 2 - Data Handling Round:
Questions Asked:
Given a dataset, asked to clean and analyze it using SQL and Excel.
Questions on handling missing data and outliers.
Your Approach:
Used SQL to clean the data and Excel to visualize trends.
Explained my approach to handling missing data (imputation vs. removal).
Outcome: Successfully completed the task and advanced to the next round.
Round 3 - Problem Solving Round:
Questions Asked:
A business scenario where I had to optimize a process using data insights.
Questions on how I would prioritize tasks in a time-sensitive project.
Your Approach:
Used a structured approach (define, measure, analyze, improve, control) to tackle the scenario.
Highlighted the importance of stakeholder communication in prioritization.
Outcome: The interviewer seemed satisfied with my answers, and I moved forward.
Round 4 - Business Case Study:
Questions Asked:
Presented with a real-world business problem and asked to propose a data-driven solution.
Questions on how I would measure the success of my solution.
Your Approach:
Identified key metrics and proposed a step-by-step plan.
Emphasized the importance of aligning the solution with business goals.
Outcome: Cleared this round and proceeded to the final HR round.
Round 5 - HR Interview:
Questions Asked:
Tell me about yourself.
Why do you want to work at Flipkart?
How do you handle conflicts in a team?
Your Approach:
Kept my answers concise and aligned them with the company’s values.
Shared a personal anecdote for the conflict-resolution question.
Outcome: Received positive feedback and an offer letter shortly after.
Preparation Tips:
Brush up on SQL and Excel—practice writing complex queries and using advanced functions.
Work on case studies to improve problem-solving skills.
Mock interviews helped me get comfortable with the interview format.
Conclusion:
Overall, the interview process was rigorous but well-structured. I felt prepared because I focused on both technical and soft skills. My advice to future candidates is to practice real-world scenarios and be ready to explain your thought process clearly.
Application Process: Applied through a referral from a friend who works in the same role but in a different category.
Interview Rounds:
Round 1 - HR Interview:
Questions Asked:
Tell me about yourself.
Why do you want to work as a Business Analyst at Flipkart?
Describe a situation where you had to analyze data to solve a problem.
Your Approach: I kept my introduction concise and focused on my analytical skills and relevant experiences. For the problem-solving question, I used the STAR method to structure my answer.
Outcome: Passed this round and moved to the next stage.
How would you approach analyzing sales data for a specific category?
What metrics would you prioritize to measure business performance?
How do you handle ambiguity in data analysis?
Your Approach: I discussed my methodology for data analysis, emphasizing the importance of KPIs and stakeholder alignment. For the ambiguity question, I shared an example of a past project where I had to make assumptions and validate them iteratively.
Outcome: Cleared this round and was invited for a face-to-face interview.
Round 3 - Face-to-Face Interview:
Questions Asked:
Case study: Analyze a hypothetical scenario where a product category is underperforming and propose solutions.
How would you present your findings to senior management?
Behavioral questions about teamwork and conflict resolution.
Your Approach: For the case study, I structured my analysis using a framework (e.g., SWOT or PESTLE) and focused on actionable insights. For the presentation question, I highlighted the importance of clarity and data visualization.
Outcome: Successfully cleared this round and received the final offer via email.
Preparation Tips:
Brush up on case studies and data analysis frameworks.
Practice explaining your thought process clearly and concisely.
Be prepared for behavioral questions using the STAR method.
Conclusion:
Overall, the interview process was smooth and well-structured. The referral definitely helped, but thorough preparation was key. I could have practiced more case studies beforehand, but the experience was great, and I’m excited to join Flipkart!
For SUMIFS, I explained how it works with multiple criteria and provided an example of calculating commission payouts using master data and commission percentages.
For VLOOKUP, I described its use for looking up values in a table and how it can be combined with SUMIFS for calculations.
Outcome: [Result not provided]
Preparation Tips:
Focus on Advanced Excel, especially SUMIFS and VLOOKUP, as they are likely to be tested.
Be prepared for questions on commission payout calculations where you need to use SUMIFS and VLOOKUP together.
For SQL, review DDL, DML, and group queries.
Note that the role might lean more towards MIS tasks rather than strategic business analysis.
Conclusion:
The interview process was straightforward but lacked hospitality, and the interviewer was somewhat rude. The technical level was average or below average. If you’re looking for a strategic Business Analyst role, this might not be the right fit, but if you’re comfortable with MIS tasks, prepare accordingly.
Application Process: The interview process took place before November 2019 and consisted of 5 rounds, including technical, HR, assignment, and case study rounds.
Interview Rounds:
Round 1 - Technical Interview:
Questions Asked:
Visualize a Uber database of drivers and riders (users) and write a SQL query to get the top 100 drivers by city.
How do you optimize the listing of Restaurants on Swiggy?
What are the major differences between a Linear Regression and a Logistic Regression?
What is the Bias Variance trade-off, and name some models with high bias and low variance?
A car manufacturer has observed a decline in profits by 40% year over year. What would be the possible reasons for this?
If you have 100 unbiased coins and one of them is defective. You have a weighing balance to check the weight of the coins. What is the minimum number of times you need to weigh the coins to identify the defective coin?
Your Approach: For the SQL question, I focused on structuring the query to filter and rank drivers by city. For the optimization question, I discussed factors like user behavior, ratings, and location. For the regression questions, I highlighted key differences and practical applications. The case study questions required breaking down the problem into manageable parts and considering external factors like market trends and competition.
Outcome: Successfully cleared the round.
Round 2 - HR Interview:
Questions Asked: Not specified.
Your Approach: Focused on aligning my skills and experiences with the role and company culture.
Outcome: Cleared the round.
Round 3 - Assignment:
Questions Asked: Not specified.
Your Approach: Completed the assignment with a focus on analytical rigor and clarity.
Outcome: Cleared the round.
Round 4 - Case Study:
Questions Asked: Not specified.
Your Approach: Analyzed the case study from multiple angles, including data-driven insights and business impact.
Outcome: Cleared the round.
Round 5 - Final Interview:
Questions Asked: Not specified.
Your Approach: Combined technical and business perspectives to address the questions.
Outcome: Cleared the round.
Preparation Tips:
Prepare thoroughly for the projects you have worked on.
Practice case studies on varied businesses, focusing on problem-solving with an analytical approach.
Brush up on SQL, regression models, and optimization techniques.
Conclusion:
The interview process was rigorous but rewarding. I learned the importance of being well-prepared for both technical and case study rounds. Practicing diverse case studies and refining my analytical skills were key to my success. For future candidates, I recommend focusing on real-world applications of your skills and staying calm under pressure.
Application Process: The application process involved multiple rounds, including a test, group discussion, HR interview, and guesstimate interview. The details of how the application was initiated (e.g., campus placement, online application, referral) were not provided.
Interview Rounds:
Round 1 - Test:
Questions Asked: 60 questions in 60 minutes, covering quantitative aptitude and logical reasoning.
Your Approach: Focused on solving questions quickly and efficiently, prioritizing accuracy and speed. Practiced from Arun Sharma’s Quantitative Aptitude and Logical Reasoning for CAT.
Outcome: Successfully cleared the round by maintaining focus and managing time effectively.
Round 2 - Group Discussion:
Questions Asked: Topics not specified, but the discussion involved listing problems and brainstorming solutions.
Your Approach: Actively participated, respected others’ views, and added value by thinking critically and speaking concisely.
Outcome: The discussion went well, and the candidate contributed effectively.
Round 3 - HR Interview:
Questions Asked: General HR questions, some based on the CV, and a marketing-specific question.
Your Approach: Answered spontaneously with confidence and a touch of humor. Emphasized clear communication and industry knowledge.
Outcome: The interview was positive, with the candidate demonstrating strong communication skills and clarity of thought.
Round 4 - Guesstimate Interview:
Questions Asked: A commonly asked guesstimate problem (e.g., “Weight of an aircraft”).
Your Approach: Asked clarifying questions to understand the scenario, broke the problem into smaller sections, and solved each part individually.
Outcome: Successfully tackled the guesstimate by demonstrating structured thinking.
Preparation Tips:
Test: Practice from Arun Sharma’s Quantitative Aptitude and Logical Reasoning for CAT. Join a test series for timed practice.
Group Discussion: Read widely (Google News, Quora, newspapers) to stay informed and articulate.
HR Interview: Be spontaneous, confident, and well-informed about the industry and company.
Guesstimates: Practice using resources like “Case in Point” and Analytics Vidhya.
General: Participate in discussions, read extensively, and practice aptitude questions regularly.
Conclusion:
The overall experience was enriching, with each round testing different skills. The key takeaways were the importance of preparation, clear communication, and structured problem-solving. For future candidates, the advice is to stay focused, practice consistently, and approach each round with confidence. The journey was filled with learning and some fun moments, especially while preparing with friends. All the best!
Visualize a Uber database of drivers and riders (users) and write a SQL query to get the top 100 drivers by city.
How do you optimize the listing of Restaurants on Swiggy?
What are the major differences between a Linear Regression and a Logistic Regression?
What is the Bias Variance trade-off and name some models with high bias and low variance?
A car manufacturer has observed a decline in profits by 40% year over year. What would be the possible reasons for this?
If you have 100 unbiased coins and one of them is defective. You have a weighing balance to check the weight of the coins. What is the minimum number of times you need to weigh the coins to identify the defective coin?
Your Approach: [Not specified]
Outcome: [Not specified]
Round 2 - HR Interview:
Questions Asked: [Not specified]
Your Approach: [Not specified]
Outcome: [Not specified]
Round 3 - Assignment:
Questions Asked: [Not specified]
Your Approach: [Not specified]
Outcome: [Not specified]
Round 4 - Case Study:
Questions Asked: [Not specified]
Your Approach: [Not specified]
Outcome: [Not specified]
Round 5 - [Not specified]:
Questions Asked: [Not specified]
Your Approach: [Not specified]
Outcome: [Not specified]
Preparation Tips:
Prepare well for the projects you have worked on.
Practice case studies on varied businesses from a problem-solving perspective with an analytical approach.
Application Process: The application was straightforward, likely through campus placement or an online portal, though the specifics weren’t provided.
Interview Rounds:
Round 1 - Group Discussion (GD):
Questions Asked: General topics related to business scenarios or current affairs (specifics not mentioned).
Your Approach: Participated actively, shared relevant points, and ensured clarity in communication.
Outcome: Passed this round successfully.
Round 2 - Case and Puzzles:
Questions Asked: Case studies and puzzles to test analytical and problem-solving skills.
Your Approach: Broke down the cases logically, used structured thinking for puzzles, and communicated solutions clearly.
Outcome: Cleared this round as well.
Round 3 - CV-Based Questions:
Questions Asked: Detailed questions about past experiences, projects, and skills mentioned in the resume.
Your Approach: Highlighted relevant experiences, explained projects clearly, and linked them to the role’s requirements.
Outcome: Progressed to the next round.
Round 4 - HR Verification:
Questions Asked: Standard HR questions about background, expectations, and cultural fit.
Your Approach: Answered honestly, aligned responses with company values, and expressed enthusiasm for the role.
Outcome: Final verification completed successfully.
Preparation Tips:
Practice group discussions on diverse topics to improve articulation.
Solve case studies and puzzles regularly to sharpen analytical skills.
Be thorough with your resume and ready to explain any detail mentioned.
Conclusion:
The overall process was fair and well-structured. The key was staying calm, thinking logically, and communicating effectively. For future candidates, focus on clarity in answers and confidence in your approach.
Application Process: The candidate applied through the campus placement process.
Interview Rounds:
Round 1 - Test:
Questions Asked: 60 questions in 60 minutes covering aptitude and logical reasoning.
Your Approach: Focused on solving questions quickly and efficiently, prioritizing accuracy and speed. Practiced extensively from Arun Sharma’s Quantitative Aptitude and Logical Reasoning for CAT.
Outcome: Successfully cleared the round.
Round 2 - Group Discussion:
Questions Asked: Topics related to current issues or business scenarios.
Your Approach: Listed problems systematically, proposed solutions, and maintained respectful group dynamics. Added value by thinking critically and speaking concisely.
Outcome: Performed well in the discussion.
Round 3 - HR Interview:
Questions Asked: General HR questions, some based on the CV, and a marketing-specific question.
Your Approach: Answered spontaneously with confidence and a touch of humor. Focused on clear communication and backed responses with logical reasoning.
Outcome: Cleared the HR round successfully.
Round 4 - Guesstimate Interview:
Questions Asked: A commonly asked guesstimate problem (e.g., weight of an aircraft).
Your Approach: Asked clarifying questions, broke the problem into smaller sections, and solved each part individually.
Outcome: Successfully tackled the guesstimate.
Preparation Tips:
Aptitude: Practice from Arun Sharma’s Quantitative Aptitude and Logical Reasoning for CAT. Join a test series for timed practice.
Group Discussion: Read widely—Google News, Quora, newspapers, and magazines—to stay informed on diverse topics.
HR Interview: Improve communication skills by participating in discussions. Research the company and industry thoroughly.
Guesstimates: Use resources like “Case in Point” and Analytics Vidhya for practice.
Conclusion:
The overall experience was enriching. The key takeaways were the importance of preparation, clarity of thought, and confidence. Practicing under timed conditions and staying updated on current affairs were crucial. For future candidates, focus on one opportunity at a time, engage in critical discussions, and keep refining your skills. All the best!
Funny Moments: Preparing with friends led to many light-hearted and memorable moments.
Application Process: Received a call from the recruiter asking for basic details about my current job. This was followed by a series of interviews with team members.
Interview Rounds:
Round 1 - Recruiter Screening:
Questions Asked: Basic details about my current job.
Your Approach: Answered honestly and provided relevant details.
Outcome: Proceeded to the next rounds.
Round 2 - Team Member Interview 1:
Questions Asked: Not specified.
Your Approach: Engaged in a detailed discussion about my experience and skills.
Outcome: Moved to the next round.
Round 3 - Team Member Interview 2:
Questions Asked: Not specified.
Your Approach: Continued discussing my qualifications and fit for the role.
Outcome: Advanced further.
Round 4 - Team Member Interview 3:
Questions Asked: Not specified.
Your Approach: Maintained a professional and engaging conversation.
Outcome: Progressed to the next stage.
Round 5 - HRBP Round:
Questions Asked: Not specified.
Your Approach: Focused on aligning my goals with the company’s vision.
Outcome: Felt positive about the interaction.
Conclusion:
The interview process was smooth, and each round lasted around 35-40 minutes. However, after the final round, the recruiter stopped responding to calls and emails, which was very unprofessional. It was disappointing to be left without any feedback or closure, especially after investing time in the process. My advice to future candidates would be to follow up persistently and be prepared for such scenarios, as not all companies prioritize candidate communication.
Application Process: Applied through a referral from a friend who works in the same position but in a different category at Flipkart.
Interview Rounds:
Round 1 - HR Interview:
Questions Asked:
Tell me about yourself.
Why do you want to work as a Business Analyst at Flipkart?
Describe a situation where you analyzed data to solve a problem.
Your Approach: I focused on aligning my skills and experiences with the role requirements, emphasizing my analytical abilities and problem-solving skills.
Outcome: Passed this round and moved to the next stage.
How would you approach analyzing sales data for a specific category?
What tools or methodologies do you prefer for data analysis?
Can you explain a time when your analysis led to a significant business decision?
Your Approach: I structured my answers around real-world examples, highlighting my proficiency with tools like Excel and SQL, and my ability to derive actionable insights.
Outcome: Cleared this round and was invited for a face-to-face interview.
Round 3 - Face-to-Face Interview:
Questions Asked:
Walk me through a project where you used data to drive business growth.
How do you handle discrepancies in data?
What metrics would you track to measure the success of a new product launch?
Your Approach: I provided detailed examples, focusing on my analytical process and the impact of my work. I also discussed my familiarity with Flipkart’s business model.
Outcome: Successfully cleared this round.
Preparation Tips:
Brush up on SQL and Excel, as they are frequently used in the role.
Practice explaining your past projects clearly, focusing on the impact of your analysis.
Research Flipkart’s business model and recent trends in e-commerce.
Conclusion:
The interview process was thorough but well-structured. The referral helped me get noticed, but the technical rounds were challenging. I could have prepared more case studies beforehand. My advice to future candidates is to focus on practical examples and be ready to discuss how your skills align with Flipkart’s needs.
Application Process: Applied through campus placement. The process involved multiple rounds focusing on technical and problem-solving skills.
Interview Rounds:
Round 1 - Technical Screening:
Questions Asked:
SQL queries for data extraction and manipulation.
Excel functions and pivot tables.
Basic problem-solving questions.
Your Approach:
Prepared SQL queries beforehand and practiced common Excel functions.
Focused on understanding the problem before jumping to solutions.
Outcome: Cleared the round with positive feedback on SQL and Excel skills.
Round 2 - Data Handling:
Questions Asked:
Given a dataset, perform analysis using SQL and Excel.
Identify trends and provide insights.
Your Approach:
Structured the analysis by breaking it into smaller tasks.
Used SQL for data extraction and Excel for visualization.
Outcome: Successfully completed the task and moved to the next round.
Round 3 - Problem Solving:
Questions Asked:
Case study on optimizing a business process.
Hypothetical scenarios to test logical reasoning.
Your Approach:
Applied a step-by-step approach to the case study.
Used frameworks like SWOT analysis for the business scenario.
Outcome: Cleared the round with feedback on structured thinking.
Round 4 - Business Case Study:
Questions Asked:
Real-world business problem to solve.
Questions on how to improve Flipkart’s delivery efficiency.
Your Approach:
Researched Flipkart’s business model beforehand.
Proposed data-driven solutions.
Outcome: Final round cleared, received an offer.
Preparation Tips:
Practice SQL and Excel extensively.
Work on case studies to improve problem-solving skills.
Research the company’s business model and recent trends.
Conclusion:
The interview process was thorough and tested both technical and analytical skills. Preparing case studies and practicing SQL/Excel were key. Would recommend focusing on structured problem-solving and staying calm during the interviews.
Application Process: The application was through campus placements. The process began with an aptitude test, followed by multiple interview rounds to shortlist candidates at each stage.
Interview Rounds:
Round 1 - Aptitude Test:
Questions Asked: The test included quantitative aptitude, logical reasoning, and data interpretation questions.
Your Approach: I focused on accuracy and time management, ensuring I attempted all sections. I practiced with previous placement papers to get familiar with the pattern.
Outcome: Cleared the round and moved to the next stage.
Round 2 - Analytical Questioning:
Questions Asked: Questions revolved around problem-solving, data analysis, and business scenarios. For example, “How would you analyze sales data to identify trends?”
Your Approach: I structured my answers logically, breaking down the problem into smaller parts and explaining my thought process clearly.
Outcome: Successfully cleared this round.
Round 3 - Case Study (1st Round):
Questions Asked: A case study on optimizing delivery logistics for Flipkart. Questions included identifying bottlenecks and suggesting improvements.
Your Approach: I analyzed the case systematically, considering factors like cost, time, and customer satisfaction. I also proposed data-driven solutions.
Outcome: Advanced to the next round.
Round 4 - Case Study (2nd Round):
Questions Asked: Another case study, this time on customer retention strategies for Flipkart.
Your Approach: I focused on understanding customer behavior and suggested personalized marketing and loyalty programs.
Outcome: Cleared this round as well.
Round 5 - HR Round:
Questions Asked: Typical HR questions like “Tell me about yourself,” “Why Flipkart?” and situational questions like “How do you handle pressure?”
Your Approach: I kept my answers concise, highlighting my skills and aligning my responses with Flipkart’s values.
Outcome: Received positive feedback and was selected for the role.
Preparation Tips:
Practice aptitude tests and case studies regularly.
Brush up on business analytics concepts and problem-solving frameworks.
Stay updated with Flipkart’s business model and recent trends in e-commerce.
Conclusion:
The overall experience was challenging but rewarding. The key was staying calm and structured in my approach during each round. I could have practiced more case studies beforehand, but the preparation I did paid off. For future candidates, focus on clarity of thought and confidence in your answers. Good luck!
