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 for Experienced

Updated 19 Sep 2024

MakeMyTrip Data Analyst Interview Experiences for Experienced

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 appeared for an interview 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 for Experienced

asked in Samsung
Q1. How to Work with dynamic data, how to remove duplicate data or fi ... read more
asked in Morningstar
Q2. What are the elements which are present in all the financial stat ... read more
Q3. What is a Brownian motion? Properties of Brownian motion?
Q4. What is a Martingale? What are Markov Processes? Is Martingale a ... read more
asked in PhonePe
Q5. Different types of Joins in SQL and what are the outputs when you ... read more

Interview questions from similar companies

I applied via Company Website and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Salary and designation

Interview Preparation Tips

Interview preparation tips for other job seekers - 1

I applied via Company Website and was interviewed in Oct 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. I went as a fresher for the job. They asked me technical skills and good cummication skills.
  • Q2. I am interested to do in it

Interview Preparation Tips

Interview preparation tips for other job seekers - I am bathula suresh yadav from medchal
I am pursuing my graduation final year (bcom
Computer)
I have technical skills and good at computer knowledge
I have good cummication skills
Thanking you
Yours careingly

I applied via Naukri.com and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Sql questions based on group by , windows functions , functions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident. Understand the role very clearly.

I applied via Walk-in and was interviewed before Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Some general knowledge question regarding shoping and what is justdial

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good

I applied via Walk-in and was interviewed before May 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Introducing your self

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident

I appeared for an interview before Nov 2019.

Interview Questionnaire 

4 Questions

  • Q1. How do you know about this company?
  • Q2. I have research about this company from various ways and collect a good bunch of information and decided to hire job from this company.
  • Q3. In which skill you are fit to perfect?
  • Q4. Well, iam a quick learner i grab new things at early stage i like to learn new things and perfection is my desire i try to get learn fast and getting knowledge is my aim.

Data Analyst Interview Questions & Answers

Meesho user image Abhilasa Barman

posted on 26 Dec 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

I was asked a medium-level SQL question that involved the RANK function.

Interview experience
1
Bad
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Job Portal and was interviewed in Jun 2023. There were 3 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 - Aptitude Test 

Aptitude test is a way for employers to assess a candidate's abilities through a variety of different testing formats. Aptitude tests will test your ability to perform tasks and react to situations at work. This includes: problem-solving.

Round 3 - One-on-one 

(2 Questions)

  • Q1. Tell me something about yourself. How did you hear about this position? Why do you want to work here?
  • Ans. Hi thank you for giving me this opportunity to introduce my self lakshmi r am basically from doddballapur i graduate in b. Com from banglore north university
  • Answered Anonymously
  • Q2. What is your greatest strength? What are your strengths and weaknesses? What do you know about this company/organization?

MakeMyTrip Interview FAQs

How many rounds are there in MakeMyTrip Data Analyst interview for experienced candidates?
MakeMyTrip interview process for experienced candidates usually has 1 rounds. The most common rounds in the MakeMyTrip interview process for experienced candidates are Technical.
How to prepare for MakeMyTrip Data Analyst interview for experienced candidates?
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 for experienced candidates?

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

  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 for Experienced

based on 1 interview

Interview experience

3
  
Average
View more
MakeMyTrip Data Analyst Salary
based on 19 salaries
₹4 L/yr - ₹8 L/yr
7% more than 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
327 salaries
unlock blur

₹12 L/yr - ₹34.2 L/yr

Assistant Manager
277 salaries
unlock blur

₹4.8 L/yr - ₹20 L/yr

Software Engineer
240 salaries
unlock blur

₹7 L/yr - ₹27 L/yr

Holiday Expert
226 salaries
unlock blur

₹1 L/yr - ₹8.1 L/yr

Senior Business Development Manager
224 salaries
unlock blur

₹5 L/yr - ₹12 L/yr

Explore more salaries
Compare MakeMyTrip with

Cleartrip

3.5
Compare

Amazon

4.0
Compare

Flipkart

3.9
Compare

Udaan

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