Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by MakeMyTrip Team. If you also belong to the team, you can get access from here

MakeMyTrip Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

MakeMyTrip Data Analyst Interview Questions and Answers

Updated 19 Sep 2024

MakeMyTrip Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 19 Sep 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
No response

I was interviewed in Aug 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Calculate no of rows after join
  • Ans. 

    Calculate the number of rows after joining two datasets.

    • Count the number of rows in each dataset

    • Perform the join operation

    • Count the number of rows in the resulting dataset

  • Answered by AI
  • Q2. Split person name in excel
  • Ans. 

    Use Excel's text to columns feature to split person names into separate columns.

    • Select the column containing the full names

    • Go to the Data tab and click on Text to Columns

    • Choose 'Delimited' and select the delimiter that separates the names (e.g. space)

    • Click Finish to split the names into separate columns

  • Answered by AI

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 10 Sep 2020

I applied via LinkedIn and was interviewed in Sep 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. How your work will increase our revenue? By sharing the data we can improve our services.
  • Ans. 

    Sharing data insights can help improve services and identify revenue opportunities.

    • Analyzing customer behavior can help identify areas for improvement

    • Identifying trends in sales data can help optimize pricing strategies

    • Using data to personalize marketing efforts can increase customer engagement

    • Predictive modeling can help identify potential revenue opportunities

    • Tracking key performance indicators can help optimize busi

  • Answered by AI
  • Q2. Do you believe in the overtime if yes then why? I don believe in the rare cases we should help our team mates

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay cool and be optimistic.

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.

Round 1 - Assignment 

Assignment contained multiple set of questions - python, data science, sql, statistics, data literacy , visualization . Test went on for 1 hour and results were given immediately.

It was a good test. Although I scored 65% , and did not make it, but still had a good experience.

Suggestion - prepare for timebound , basic problem solving.

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Sql, advance Excel formulas
Interview experience
2
Poor
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - One-on-one 

(7 Questions)

  • Q1. Explain Moving Average
  • Ans. 

    Moving Average is a statistical technique used to analyze data points by creating a series of averages of different subsets of the full data set.

    • Moving Average helps in smoothing out fluctuations in data to identify trends over time.

    • It is calculated by taking the average of a specific number of data points within a defined window.

    • For example, a 3-day moving average for stock prices would be the average of the stock pri...

  • Answered by AI
  • Q2. Explain Decorators
  • Ans. 

    Decorators in Python are functions that modify the behavior of other functions.

    • Decorators are denoted by the @ symbol followed by the decorator function name.

    • They allow you to add functionality to an existing function without modifying its code.

    • Common use cases include logging, timing, and authentication.

    • Example: @decorator_function def function_to_decorate(): pass

  • Answered by AI
  • Q3. Explain Object Oriented Programming
  • Ans. 

    Object Oriented Programming is a programming paradigm based on the concept of objects, which can contain data and code.

    • OOP focuses on creating objects that interact with each other to solve complex problems.

    • Objects have attributes (data) and methods (functions) that can manipulate the data.

    • Encapsulation, inheritance, and polymorphism are key principles of OOP.

    • Example: In a car simulation program, a 'Car' object can hav...

  • Answered by AI
  • Q4. Explain classes objects
  • Ans. 

    Classes are blueprints for creating objects in object-oriented programming.

    • Classes define the properties and behaviors of objects

    • Objects are instances of classes

    • Classes can inherit properties and behaviors from other classes

    • Classes can have constructors to initialize objects

    • Classes can have methods to perform actions

  • Answered by AI
  • Q5. Explain Functions
  • Ans. 

    Functions are blocks of code that perform a specific task and can be reused multiple times in a program.

    • Functions help in organizing code and making it more modular.

    • They can take input parameters and return output values.

    • Functions can be called multiple times from different parts of the program.

    • Examples: summing two numbers, finding the maximum value in a list.

  • Answered by AI
  • Q6. Pandas and Numpy
  • Q7. Swap L1 and L5 in a list
  • Ans. 

    Swap L1 and L5 in a list

    • Create a temporary variable to store the value of L1

    • Assign the value of L5 to L1

    • Assign the value of the temporary variable to L5

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Cleartrip Data Analyst interview:
  • Advanced Python
  • Advanced SQL
  • Advanced Excel
Interview preparation tips for other job seekers - The Job Description Listed Excel, SQL Data Visualization as key skills and python would be an add on. But all questions were asked on advanced python which may not be relevant for data analysis.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Duration - 1hr, Mostly questions are from Excel and SQL ( But a little knowledge of R and Python is very useful) .For me, it's knowing the concepts and answering no codes were ask to write.

Round 2 - One-on-one 

(1 Question)

  • Q1. Basic 1-on-1 round with your manager/ or any senior from the company
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Apr 2022. There were 8 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. They will ask about your profile and past experience.
Round 3 - Technical 

(1 Question)

  • Q1. A peer level colleague will ask some basic knowledge check questions
Round 4 - Coding Test 

This is literally a live coding test. For analytics expect SQL, python, R.

Round 5 - One-on-one 

(1 Question)

  • Q1. Interviewed by a manager of another team
Round 6 - One-on-one 

(1 Question)

  • Q1. Interviewed by dotted line reporting manager
Round 7 - One-on-one 

(1 Question)

  • Q1. Cross functional interview
Round 8 - One-on-one 

(1 Question)

  • Q1. Core Values Interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Know the core values, remember them, understand them and embody them. And being good at your advertised skills also helps.

Analyst Interview Questions & Answers

Airbnb user image Pornima Kolte

posted on 4 Mar 2024

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. How to sort ararat
  • Ans. 

    Ararat can be sorted alphabetically or numerically.

    • Sort alphabetically: Arrange in ascending order based on the letters in the word.

    • Sort numerically: Arrange in ascending order based on the numerical value of each character.

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself
Round 2 - One-on-one 

(1 Question)

  • Q1. About the industry

Interview Preparation Tips

Interview preparation tips for other job seekers - Have an idea about the travel industry before you go for the interview.

Analyst Interview Questions & Answers

Agoda user image Sharvaani Singh

posted on 9 Oct 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed before Oct 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

The test had 2 sql questions that you needed to solve and other general aptitude questions

Round 2 - HR 

(1 Question)

  • Q1. Case Study round : How will you solve an issue with low number of likes received on a tech platform
  • Ans. 

    To increase likes on a tech platform, I would focus on improving content quality, engaging with users, and utilizing data analytics.

    • Analyze user engagement data to understand preferences and trends

    • Create high-quality and relevant content to attract users

    • Engage with users through interactive posts, contests, and polls

    • Collaborate with influencers or partners to reach a wider audience

    • Utilize targeted advertising to promot

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. Case study round to understand how email marketing works

MakeMyTrip Interview FAQs

How many rounds are there in MakeMyTrip Data Analyst interview?
MakeMyTrip interview process usually has 1 rounds. The most common rounds in the MakeMyTrip interview process are Technical.
How to prepare for MakeMyTrip Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at MakeMyTrip. The most common topics and skills that interviewers at MakeMyTrip expect are Access, Data Analysis, Data Analytics, Data Management and Excel.
What are the top questions asked in MakeMyTrip Data Analyst interview?

Some of the top questions asked at the MakeMyTrip Data Analyst interview -

  1. How your work will increase our revenue? By sharing the data we can improve our...read more
  2. calculate no of rows after j...read more
  3. split person name in ex...read more

Tell us how to improve this page.

MakeMyTrip Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Oyo Rooms Interview Questions
3.3
 • 227 Interviews
BCD Travel Interview Questions
4.3
 • 111 Interviews
Expedia Group Interview Questions
3.8
 • 81 Interviews
Agoda Interview Questions
3.6
 • 62 Interviews
Thomas Cook Interview Questions
3.8
 • 44 Interviews
Yatra Interview Questions
3.4
 • 31 Interviews
Airbnb Interview Questions
3.8
 • 22 Interviews
Ixigo.com Interview Questions
3.7
 • 22 Interviews
Cleartrip Interview Questions
3.4
 • 18 Interviews
View all
MakeMyTrip Data Analyst Salary
based on 19 salaries
₹3 L/yr - ₹10 L/yr
At par with the average Data Analyst Salary in India
View more details

MakeMyTrip Data Analyst Reviews and Ratings

based on 5 reviews

3.5/5

Rating in categories

2.3

Skill development

3.8

Work-life balance

2.8

Salary

4.1

Job security

3.7

Company culture

2.5

Promotions

2.8

Work satisfaction

Explore 5 Reviews and Ratings
Senior Software Engineer
324 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
272 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Business Development Manager
226 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Holiday Expert
225 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Executive
210 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare MakeMyTrip with

Cleartrip

3.4
Compare

Yatra

3.4
Compare

Goibibo

4.3
Compare

Oyo Rooms

3.3
Compare
Did you find this page helpful?
Yes No
write
Share an Interview