Make My Trip Business Analyst interview questions & guide 2026

The following categories represent the patterns observed in recent interview cycles. While specific questions may vary depending on the team and the seniority of the role, you should focus on developing a consistent methodology for tackling both technical and business-oriented problems.

Technical Proficiency: SQL and Python

These questions test your ability to manipulate data efficiently and write clean, functional code to solve analytical problems.

• How to calculate retention in SQL.
• Write a script to filter and aggregate user activity logs.

Preparation for Make My Trip should be structured around three pillars: technical execution, business intuition, and clear communication. You are expected to demonstrate not just that you can write code, but that you understand the business context of the data you are handling.

Technical Competency – You must be comfortable writing SQL queries under pressure and demonstrating proficiency in Python for data analysis. Interviewers look for clean, efficient code that follows best practices, rather than just "getting the right answer."

Analytical Thinking – This is the ability to break down ambiguous business problems into smaller, solvable components. Be ready to articulate your assumptions clearly, especially when dealing with pricing or market strategy cases.

Communication and Influence – Your value as a Business Analyst lies in your ability to drive change through data. You will be evaluated on your ability to synthesize complex findings into simple, actionable insights for your team.

The interview process at Make My Trip is designed to evaluate both your technical depth and your ability to fit into a data-driven culture. While the number of rounds can vary, you should generally expect a series of technical assessments followed by deep-dive discussions on your past work and potential case studies. The process is professional and structured, with a strong emphasis on practical problem-solving.

This timeline provides a snapshot of the typical progression from initial screening to final assessment. Use this visual to manage your preparation, ensuring you have enough time to brush up on both your coding skills and your case-study methodology before reaching the later, more conversational rounds.

Data Manipulation and Querying

This area is foundational. You are expected to demonstrate mastery of SQL, particularly regarding window functions and aggregations.

Be ready to go over:

• Advanced SQL – Using common table expressions (CTEs) and window functions for retention and cohort analysis.
• Data Integrity – How to clean and validate data before beginning an analysis.

As a Business Analyst, your daily work will revolve around extracting insights from vast amounts of travel and transactional data. You will spend a significant portion of your time querying databases to track key performance indicators (KPIs) and identifying trends that inform product roadmaps.

Collaboration is a core component of this role. You will often work alongside product managers to design A/B tests or evaluate the performance of new features on the Make My Trip platform. You are not just a reporter of data; you are an advisor who uses evidence to guide the direction of the business, ensuring that every strategic move is backed by data.

A competitive candidate for the Business Analyst role should possess a strong technical background paired with the soft skills necessary to influence stakeholders.

• Must-have skills:
  • Proficiency in SQL (including complex joins and analytical functions).
  • Practical experience with Python for data manipulation and analysis.
  • Strong logical and analytical reasoning capabilities.
  • Ability to present data insights clearly to non-technical audiences.
• Nice-to-have skills:
  • Experience in the travel or e-commerce industry.
  • Familiarity with A/B testing methodologies and statistical significance.
  • Understanding of machine learning concepts relevant to business forecasting.

Q: How long does the interview process typically take? The process usually spans a few weeks. It involves an online test or initial screen followed by several rounds of technical and business interviews.

Q: What is the most common reason candidates fail the technical round? Candidates often fail by focusing only on the syntax of their code while ignoring the efficiency or the business logic behind the query. Always explain your thought process while you work.

Q: Is the culture at Make My Trip highly competitive? It is a fast-paced environment where results matter. Successful candidates are those who are proactive, curious, and comfortable working in a collaborative, data-driven setting.

• Structure your answers: Use frameworks like the STAR method for behavioral questions and a structured approach for case studies (e.g., clarify the goal, state assumptions, analyze, conclude).
• Be ready for feedback: Some interviewers at Make My Trip are known for being transparent and providing constructive feedback; view this as an opportunity to learn.
• Know your resume: Be prepared to discuss every project you list in detail. If you mention a model, you should be able to explain exactly how you validated it.

Preparing for the Business Analyst role at Make My Trip requires a balanced focus on your technical toolkit and your ability to apply that knowledge to real-world business challenges. By mastering SQL and Python, and practicing how you communicate your analytical process, you will position yourself as a strong candidate capable of driving real impact.

The compensation data above provides a general range for this role. Use this to set your expectations regarding the level of seniority and the total rewards package, keeping in mind that actual offers are influenced by your specific experience and the requirements of the hiring team.

For additional practice, you can explore more interview insights, practice questions, and preparation resources on Dataford. With a structured plan and consistent practice, you are well on your way to success.