MakeMyTrip Interview Questions, Process, and Tips

System DEsign design spotify

Q1. Design Spotify in depth
Ans. 
Spotify is a music streaming service that allows users to listen to a wide variety of songs and create personalized playlists.
• Spotify uses algorithms to recommend music based on user preferences and listening history.

• Users can create playlists, follow artists, and share music with friends.

• Spotify offers both free and premium subscription options with additional features like offline listening and ad-free music.

• The plat...read more
Answered by AI
Add your answer
Q2. Db design in depth for spotify
Ans. 
Designing a database for Spotify involves creating tables for users, songs, playlists, and interactions.
• Create tables for users, songs, playlists, interactions

• Use relational database management system like MySQL or PostgreSQL

• Implement indexes for faster query performance

• Normalize data to reduce redundancy

• Consider sharding for scalability
Answered by AI
Add your answer

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
Add your answer
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
Add your answer

Product Design question

Q1. Favourite App critique
Ans. 
My favorite app is Instagram, but I believe it can improve its algorithm for showing posts.
• Instagram's algorithm sometimes shows posts out of order, leading to missed content

• The explore page could be more personalized based on user interests

• There are concerns about the impact of the app on mental health due to the focus on likes and followers
Answered by AI
Add your answer

Q1. Leetcode Candy problem , Hard
Add your answer
Q2. Find the min steps to convert string a to b, you can use deletion, insertion and replace any number of times.
Ans. 
Use dynamic programming to find the minimum steps to convert string a to b by deletion, insertion, or replacement.
• Create a 2D array to store the minimum steps required to convert substrings of a to substrings of b.

• Initialize the array with base cases for empty strings and iterate through the rest of the array to fill in the values based on previous calculations.

• The final value in the bottom right corner of the array wi...read more
Answered by AI
Add your answer

2 questions - 1 was on map and other on graph

Q1. Elevator system design
Ans. 
Designing an elevator system involves considering factors like capacity, speed, efficiency, and safety.
• Consider the number of floors in the building and the expected traffic flow to determine the number of elevators needed.

• Choose between different elevator types such as hydraulic, traction, or machine-room-less based on building requirements.

• Implement a control system to optimize elevator movement and reduce wait times...read more
Answered by AI
Add your answer

First round was a coding question with html, css, javascript to create 5 clickable boxes, change it's colors on click and update count