i
MakeMyTrip
Filter interviews by
Search for an element in a sorted rotated array
Use binary search to find the pivot point where the array is rotated
Then perform binary search on the appropriate half of the array to find the element
Handle cases where the element is not found in the array
System DEsign design spotify
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...
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
I applied via Company Website and was interviewed before Sep 2023. There were 3 interview rounds.
Normal Easy Medium Leet Code QUestion
Design a system similar to Gmail for sending and receiving emails.
Use distributed systems for scalability and reliability
Implement features like search, filters, labels, and attachments
Utilize a database for storing emails and user data
Include security measures like encryption and authentication
A singleton class is a class that can only have one instance created throughout the application.
Ensure the constructor is private to prevent external instantiation.
Provide a static method to access the single instance.
Use lazy initialization to create the instance only when needed.
Top trending discussions
I appeared for an interview before Jan 2021.
Round duration - 60 minutes
Round difficulty - Easy
Two coding questions were given in the first round to be solved in 60 minutes.
Given an array A
containing 'N' integers and an integer m
, rearrange the elements of the array such that the differences between the array elements and m
are sor...
Rearrange array elements based on their differences from a given integer.
Calculate the differences between each element and the given integer.
Sort the elements based on their differences while maintaining the original order for elements with the same difference.
Implement a function to rearrange the array elements as per the given criteria.
Given an arbitrary binary tree, a node of the tree, and an integer 'K', find all nodes that are at a distance K from the specified node, and return a list of th...
The task is to find all nodes in a binary tree that are at a distance K from a given node.
Traverse the binary tree to find the given node
From the given node, perform a depth-first search to find all nodes at distance K
Use a list to store the values of the nodes at distance K
Return the list of values in any order
Round duration - 60 minutes
Round difficulty - Easy
This was a technical round with questions based on DSA, DBMS, Computer Networking and project based questions.
Ninja is tasked with printing a triangle pattern based on a given number 'N' for any test case.
N = 4
1
232
34545
4567654
The pat...
Print a triangle pattern of numbers based on a given number 'N'.
Iterate through each row and print the numbers accordingly
Use spaces to center-align the numbers in each row
Increment the numbers in each row as per the pattern
Web server serves static content over HTTP, while application server runs dynamic content and business logic.
Web server handles HTTP requests and responses, serving static content like HTML, images, and CSS.
Application server executes business logic, runs dynamic content, and interacts with databases.
Web server examples include Apache, Nginx, while application server examples include Tomcat, JBoss.
Web server focuses on...
The internet is a global network of interconnected computers that communicate using standardized protocols.
The internet is made up of a vast number of interconnected networks of computers.
Data is transmitted over the internet using protocols such as TCP/IP.
Websites are hosted on servers connected to the internet, and users access them using web browsers.
Internet Service Providers (ISPs) provide access to the internet f...
SQL query to find the nth highest salary
Use the 'SELECT DISTINCT' statement to get unique salary values
Order the salaries in descending order using 'ORDER BY' clause
Use 'LIMIT' and 'OFFSET' to get the nth highest salary
Round duration - 30 minutes
Round difficulty - Easy
Typical HR round with behavioral problems.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via Campus Placement and was interviewed before Dec 2015. There were 5 interview rounds.
Reverse a linked list
Iteratively swap the next and previous pointers of each node
Use three pointers to keep track of the current, previous, and next nodes
Update the head pointer to the last node after reversing
I appreciate the company's commitment to innovation and employee development.
Strong focus on innovation in software development
Opportunities for professional growth and development
Positive company culture and work environment
I am impressed by the company's innovative projects and collaborative work environment.
Impressed by innovative projects
Desire to work in a collaborative environment
Excited about potential for growth and learning opportunities
I appeared for an interview in Sep 2016.
Web server handles HTTP requests and responses, while application server executes application logic.
Web server serves static content like HTML, CSS, JS files
Application server executes dynamic code like Java, Python, Ruby
Web server communicates with client, application server communicates with database
Examples of web servers: Apache, Nginx, IIS
Examples of application servers: Tomcat, JBoss, WebSphere
I applied via Referral and was interviewed in May 2020. There were 9 interview rounds.
based on 3 interviews
Interview experience
based on 17 reviews
Rating in categories
Senior Software Engineer
323
salaries
| ₹12 L/yr - ₹33 L/yr |
Assistant Manager
278
salaries
| ₹4.8 L/yr - ₹20 L/yr |
Software Engineer
239
salaries
| ₹7.9 L/yr - ₹27 L/yr |
Holiday Expert
226
salaries
| ₹1 L/yr - ₹8.1 L/yr |
Senior Business Development Manager
223
salaries
| ₹5 L/yr - ₹12 L/yr |
Cleartrip
Amazon
Flipkart
Udaan