Make My Trip Data Scientist interview questions & guide 2026

The questions below represent common patterns observed in Make My Trip interview loops. While the specific technical tasks may vary by team, the focus remains on your ability to combine rigorous statistical thinking with practical coding and product intuition.

Product-Sense & Metric Design

These questions test your ability to translate business goals into measurable KPIs and diagnose performance shifts.

• How would you design a metric to measure the success of a new personalized hotel recommendation feature?
• If the conversion rate on the flight booking page drops by 5% overnight, how would you go about diagnosing the root cause?

Success at Make My Trip requires a balanced approach. You must demonstrate both the technical depth to implement complex algorithms and the product maturity to understand why those algorithms matter to the business.

Technical Proficiency – You will be assessed on your ability to write clean, efficient code and perform robust statistical analysis. Focus on mastering SQL window functions, Python data structures, and the mathematical foundations of machine learning, such as the trade-offs between Gini impurity and entropy.

Product-Centric Analytical Thinking – Your ability to structure ambiguous problems is critical. When asked a case study question, articulate your assumptions clearly, define your success metrics early, and always connect your technical solution back to the user experience.

Communication & Influence – You will be working with diverse stakeholders. Practice explaining your technical decisions in simple, business-oriented terms. Demonstrating an ability to balance technical idealism with the reality of business constraints is a hallmark of a senior-level candidate.

The interview process at Make My Trip is designed to evaluate both the depth of your technical expertise and your ability to navigate ambiguous, real-world business problems. You should expect a rigorous, multi-stage process that typically begins with a screening round, followed by technical assessments, and culminates in deep-dive discussions with senior leadership.

The company values a balance of theoretical knowledge and practical application. You will likely face a mix of coding assessments, machine learning theory, and case study discussions. The pace is generally fast, and you should be prepared to discuss your past projects in significant detail, as interviewers will often use your resume as a starting point for deep-dive technical questions.

The timeline above reflects the typical progression from initial screening to final decision. Use this structure to calibrate your preparation, ensuring you have enough time to brush up on both your coding fundamentals and your ability to articulate the business impact of your previous work.

Experimentation & A/B Testing

This is a critical competency at Make My Trip. You must understand the full lifecycle of an experiment, from hypothesis generation to post-hoc analysis.

Be ready to go over:

• Statistical significance and power analysis.
• Experimentation pitfalls such as selection bias, novelty effects, and cannibalization.
• Metric drop diagnosis techniques when an experiment results in unexpected behavior.

Example scenarios:

• "How do you decide when to stop an A/B test?"
• "What would you do if your primary metric shows a positive result, but your secondary business metric shows a significant decrease?"

SQL & Data Engineering

You will be tested on your ability to manipulate large-scale datasets efficiently.

Be ready to go over:

• SQL window functions for time-series analysis and cohort tracking.
• Optimizing queries for large datasets.
• Handling missing data and outliers during pre-processing.

Example scenarios:

• "Calculate the retention rate of users who booked a flight in the last 30 days."

As a Data Scientist, your primary responsibility is to drive business value through data-driven insights and predictive modeling. You will work within cross-functional teams to build and deploy models that enhance personalization, such as recommendation engines for hotels or dynamic pricing for flight inventory.

Expect to spend a significant portion of your time on exploratory data analysis (EDA), where you will identify patterns that inform product strategy. You will also be responsible for maintaining the health of your models, which includes monitoring performance, retraining on fresh data, and debugging production issues. Collaboration is key; you will frequently translate technical findings into recommendations for product managers, ensuring that your work directly influences the product roadmap.

A strong candidate for this role possesses a blend of strong technical fundamentals and a pragmatic, business-first mindset.

• Must-have skills:

  • Proficiency in SQL (including advanced functions).
  • Strong command of Python for data analysis and modeling.
  • Deep understanding of A/B testing and statistical hypothesis testing.
  • Ability to communicate complex technical concepts to non-technical stakeholders.

• Nice-to-have skills:

  • Experience with large-scale distributed systems or cloud-based data platforms.
  • Prior experience in the e-commerce or travel domain.
  • Familiarity with MLOps practices for model deployment and monitoring.

Q: How difficult are the coding rounds? A: The coding rounds are generally medium to difficult. They focus on common data structures and algorithms, as well as practical SQL challenges. You should be comfortable with tree traversal, stack/queue operations, and complex SQL joins.

Q: What is the best way to prepare for the case study round? A: Focus on structure. Start by clarifying the goal, defining your success metrics, and then breaking down the problem into smaller, manageable components. Always consider the business impact.

Q: Does the company value theoretical knowledge or practical experience more? A: Make My Trip values both. You will be tested on the theory behind your models, but you must also be able to explain how you would apply those models in a real-world, high-traffic production environment.

Q: How long does the entire process usually take? A: The process can move relatively quickly, but it is thorough. Expect a few weeks from the initial screen to the final round, depending on scheduling availability.

• Own your projects: Be prepared to talk about every detail of the projects listed on your resume. If you used a specific algorithm, know why you chose it over alternatives.
• Focus on the "Why": When discussing your work, don't just explain what you did; explain why you did it and what the business outcome was.
• Clarify assumptions: In case study rounds, if a question seems ambiguous, ask clarifying questions before diving into a solution.
• Practice SQL: Do not underestimate the importance of SQL. Many candidates struggle with window functions under pressure.

The Data Scientist role at Make My Trip is a high-impact position that offers the chance to solve complex problems at a massive scale. By mastering the fundamentals of experimentation, SQL, and product-sense, you will be well-positioned to excel in the interview loop. Remember that the interviewers are looking for a partner who can bridge the gap between technical complexity and business growth.

For further practice, you can explore additional interview insights, practice questions, and preparation resources on Dataford. Stay focused, be confident in your technical foundations, and remember to approach every problem with a customer-centric mindset.

The salary module above provides insights into the compensation structure for this role, which typically includes a base salary, performance-based bonuses, and equity components. Use this data to benchmark your expectations and prepare for potential compensation discussions during the final stages of the process.