Candidates report Myntra Business Analyst interviews built around Excel business cases, SQL, project walkthroughs and a hiring-manager or HR conversation. Here is what two reported experiences suggest you should prepare.
$18K
Avg. Base Comp
$23K
Avg. Total Comp
4 rounds
Typical Rounds
4 days
Process Length
Two candidate reports describe Myntra's Business Analyst interviews, and both put Excel and business reasoning at the center. One candidate reports four rounds completed within four days: a project problem-solving round, an Excel round, a SQL technical round and an HR round with the potential manager. That candidate received an offer.
The Excel round in that account was a business scenario. Given a category with five brands and their top-line and bottom-line numbers, the candidate was asked how to reach growth goals. The candidate says it was about the logic and approach more than complex formulas, so practice structuring a growth answer from category-level financials.
The SQL round was described as advanced, covering window functions and joins. Basic queries alone may not be enough preparation. Expect to explain your CV projects too, including your own contribution and the outcome.
The other candidate, who did not receive an offer, describes a hiring-manager round that moved quickly into a live Excel exercise. Data was given verbally and the candidate had to build formulas with IF, SUM and AVERAGE, including a days-on-hand style calculation. A question on how a marketplace works and its business model followed. That candidate found the pacing rushed, so narrating your approach as you work may help. Practice timed spreadsheet exercises, supply chain and marketplace basics, and a clear story for why Myntra. Only two reports are available, so treat the round order as indicative.
Synthesized from 2 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Myntra process.
I made sure to ask HR upfront what type of round I'd be facing—technical or behavioral—so I could prepare accordingly. My first round was with the Hiring Manager, and after a quick self-introduction, she shifted into an Excel test. She had me open a spreadsheet, then fed me data verbally that I had to input and work with. The real challenge wasn't just plugging numbers into cells; I needed to construct formulas using IF, SUM, and AVERAGE functions to solve the problem she set. She asked me to calculate DOH (days on hand, I assume), and it required combining multiple functions rather than a single straightforward formula. The pacing felt rushed—she clearly had limited time—so I made sure to call out my key strengths and approach clearly rather than working silently. After that, I got a question about the marketplace: what it is, how it works, and my understanding of the business model. I tried to connect it back to my experience and show I'd thought about supply chain and seller dynamics, but I sensed the conversation didn't land the way I'd hoped. The whole process felt disorganized on their end—the interviewer seemed distracted and under time pressure—which made it hard to gauge how well I was actually doing in the moment. I never heard back with an offer.
Prep tip from this candidate
Master Excel formulas—especially nested IF, SUM, and AVERAGE—and practice calculating operational metrics like DOH under time pressure. Also, prepare a concise explanation of how marketplace business models work and be ready to discuss demand management and supply chain decisions, as those came up repeatedly.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Myntra
Select the 2nd highest salary in the engineering department
| Question | |
|---|---|
| Declining Applicants | |
| International e-Commerce Warehouse | |
| Simple Explanations | |
| Empty Neighborhoods | |
| Customer Orders | |
| Rolling Bank Transactions | |
| Comments Histogram | |
| Closest SAT Scores | |
| Subscription Overlap | |
| Month Over Month | |
| Button AB Test | |
| Top Three Salaries | |
| Prime to N | |
| Monthly Customer Report | |
| Paired Products | |
| Upsell Transactions | |
| Top 3 Users | |
| P-value to a Layman | |
| Recurring Character | |
| Longest Streak Users | |
| Jars and Coins | |
| Compute Deviation | |
| Retailer Data Warehouse | |
| Experiment Validity | |
| Download Facts | |
| Bagging vs Boosting | |
| Weekly Aggregation | |
| Daily Retention Summary | |
| Average Quantity |
Synthesized from candidate reports. Individual experiences may vary.
One candidate reports starting with a project-focused round. They walked through a project, their specific role and the outcome, and interviewers dug into the details and impact. Be ready to explain your own contribution and the results of each CV project.
Candidates report Excel being tested in a business context. One was asked how to achieve growth goals for a category of five brands given top- and bottom-line numbers, with emphasis on approach. Another, in a hiring-manager round, built formulas with IF, SUM and AVERAGE for a days-on-hand style calculation while data was read out verbally.
One candidate reports an advanced SQL round covering window functions, joins and related concepts. That suggests you should drill beyond basic queries, though this comes from a single account and the exact format may vary by team.
The candidate who received an offer describes a final HR round with the potential manager, held the same day as the SQL round. It was behavioral, covering why they wanted to join Myntra and how they would fit a fast-paced environment. Another candidate was also asked about the marketplace business model and supply chain understanding in a manager-led conversation.
