Home » Flipkart – Business Analyst Interview Experience
Flipkart – Business Analyst Interview Experience
Position/Role
Experience: Business Analyst
Where Applied
Company: Flipkart
Application Method: Direct application on Flipkart’s website
Total Rounds
Business Case Study + Guesstimates
Technical Round
Hiring Manager Round
Every Round Experience
1. Business Case Study + Guesstimates
Format: Case Study and Problem-Solving Interview
Questions:
Domino’s is opening its first outlet in HSR Layout, Bengaluru. If we don’t provide delivery in x mins, we will provide y% off to the customers. Decide x and y numbers considering that you don’t have any historical data.
There are three boxes, one contains only apples, one contains only oranges, and one contains both apples and oranges. The boxes have been incorrectly labeled such that no label identifies the actual contents of the box it labels. Opening just one box, and without looking in the box, you take out one piece of fruit. By looking at the fruit, how can you immediately label all of the boxes correctly?
2. Technical Round
Format: Technical Skills Assessment
Questions:
Make a dataset for an Engineering College, what all tables do you think should be there, and write a query for that.
Name the toppers for each year (1st year of graduation/2nd year, etc.) for each department.
Can you calculate the pass percentage of each student?
Excel Assessment:
Tasks: Basic SUMIFs and Pivot Table questions.
3. Hiring Manager Round
Format: Interview with Hiring Manager
Questions:
Describe your past projects and experiences as a Business Analyst.
Assume, Friend Request Acceptance rate has drastically reduced from 20% to 10% last month on Facebook, how would you do RCA (Root Cause Analysis)? What would be your hypothesis? What would you monitor to prove that hypothesis?
