MakeMyTrip Business Analyst interview questions & guide 2026

The following questions reflect patterns observed in recent MakeMyTrip interview cycles. While the specific data points may change, the underlying focus remains on analytical rigor, business intuition, and technical execution.

Technical & Analytical Proficiency

These questions evaluate your ability to manipulate data and your knowledge of foundational analytical tools.

• Write a SQL query to identify the top 5 customers by booking frequency in the last quarter.
• How would you handle missing data in a large dataset of user search queries?

Preparation should focus on mastering the "why" behind your "how." MakeMyTrip interviewers look for candidates who can demonstrate a structured approach to problem-solving.

• Analytical Rigor: You must demonstrate proficiency in SQL and Python. Expect to be tested on your ability to write clean, efficient code that solves real-world data extraction and transformation problems.
• Problem-Solving Ability: When presented with a business case, define your assumptions clearly. Use a structured framework (like the MECE approach) to break down the problem into smaller, manageable components.
• Product & Business Acumen: Understand the MakeMyTrip business model. Be prepared to discuss KPIs like CAC (Customer Acquisition Cost), LTV (Lifetime Value), and Conversion Rate in the context of the travel industry.
• Leadership & Ownership: You will be evaluated on your ability to drive projects to completion. Highlight instances where you didn't just report data but influenced a tangible business outcome.

The interview process at MakeMyTrip is structured to assess your technical depth, your ability to handle business ambiguity, and your alignment with the company’s culture of ownership. Most candidates encounter a mix of screening rounds, technical assessments, and leadership interviews. The pace is generally consistent, and you can expect a high level of professionalism throughout the process.

The evaluation is rigorous, focusing on your ability to think on your feet. You will move from technical screens, where your coding and data manipulation skills are tested, to business case rounds, where your ability to think like a product owner is scrutinized. The final stages typically involve leadership, focusing on how you navigate organizational challenges and influence stakeholders.

The visual timeline above illustrates the standard progression from initial screening to the final leadership review. Use this to pace your study—prioritize technical fundamentals early on, while reserving time to refine your structured communication for the later business and leadership rounds.

Technical Execution

This area is non-negotiable. You are expected to be fluent in SQL and Python for data analysis. Strong performance involves writing optimized, readable code that handles edge cases.

• SQL Mastery: Aggregations, window functions, and subqueries.
• Python for Data: Pandas, NumPy, and basic visualization libraries.
• Advanced concepts: Understanding database indexing and query optimization for large-scale datasets.

Business Case & Product Thinking

This tests your ability to think like an owner. You are expected to demonstrate a deep understanding of user behavior and the travel market.

• Funnel Analysis: Identifying bottlenecks in the user journey.
• A/B Testing: Designing experiments and interpreting statistical significance.
• Pricing Strategy: Understanding elasticity and demand-based pricing.

As a Business Analyst, you will be the bridge between raw data and strategic initiatives. You will spend your day querying large datasets to extract insights that inform product features or marketing campaigns. You will work alongside Product Managers to define success metrics for new releases, ensuring that every product change is measurable.

Collaboration is central to this role. You will often present your findings to cross-functional teams, requiring you to simplify complex data into clear, persuasive narratives. Whether it is optimizing the flight search experience or analyzing the performance of a new hotel discount, your work will be central to maintaining MakeMyTrip's competitive edge.

A strong candidate for this role possesses a blend of technical expertise and business maturity. While technical skills are the baseline, your ability to communicate those findings is what secures the offer.

• Must-have skills:
  • Proficiency in SQL (advanced queries).
  • Experience with Python or R for data analysis.
  • Strong command of Excel for modeling and reporting.
  • Proven ability to build and maintain Dashboards (e.g., Tableau, PowerBI).
• Nice-to-have skills:
  • Prior experience in the e-commerce or travel-tech domain.
  • Knowledge of basic Machine Learning concepts for predictive modeling.

Q: How much time should I spend preparing for coding vs. business cases? A: Allocate about 40% of your time to coding (SQL/Python) and 60% to practicing business case structures and understanding industry-specific KPIs.

Q: Are the technical rounds strictly theoretical? A: No, they are highly practical. Expect to write code on a whiteboard or a shared document that solves actual business problems, such as calculating retention rates from a raw user log.

Q: What is the best way to handle a question I don't know the answer to? A: Be honest about your knowledge gap, but demonstrate your thought process. Explain how you would go about finding the answer or what data you would need to reach a conclusion.

Q: What is the culture like at MakeMyTrip? A: It is fast-paced and data-obsessed. You are expected to take ownership of your tasks and be prepared to defend your analytical findings in front of senior stakeholders.

• Structure your answers: Use the STAR method (Situation, Task, Action, Result) for behavioral questions and a structured framework for business cases.
• Think aloud: When solving a case, narrate your thought process. Interviewers want to see how you structure your logic, not just that you reached the right answer.
• Know the product: Use the MakeMyTrip app/website extensively before the interview. Identify features you like and areas where you see potential for data-driven improvement.
• Be ready for pushback: In business case rounds, interviewers may challenge your assumptions. Stay calm, acknowledge their point, and explain why you chose your specific approach.

The Business Analyst role at MakeMyTrip is a challenging, high-visibility position that offers a unique vantage point into the travel-tech industry. By mastering the technical requirements of SQL and Python while simultaneously sharpening your ability to structure ambiguous business problems, you will be well-positioned to succeed.

Approach your preparation with a focus on logical structure and business impact. Remember that your interviewers are looking for a partner who can help them make better, faster decisions. For additional insights and practice material, continue exploring resources on Dataford. You have the capability to succeed—stay focused, practice your structure, and approach each round with confidence.

The salary module provides an overview of typical compensation bands for this role. Use this to benchmark your expectations and ensure you are prepared for salary discussions during the final HR round by focusing on the total value you bring to the organization.