Motive interview experience
Summary
I interviewed for a Senior Software Engineer role at Motive and, despite my strong performance in both the Data Structures & Algorithms and High-Level Design rounds, I ultimately received a rejection.
Full Experience
Round 1: Data Structures & Algorithms
In this round, I was presented with the problem of finding an element within a rotated sorted array. Fortunately, I had encountered this specific problem before on LeetCode, which allowed me to solve it successfully.
Round 2: High-Level Design (HLD)
The HLD round began with a request to discuss a project I was particularly proud of. This led to a natural conversation, including basic questions about my choices regarding databases for that project.
Following this, I was given a task to design the table schema for a system similar to BookMyShow. I proceeded to create a comprehensive and normalized schema, detailing entities such as artists, movies, theatres, halls, shows, users, bookings, and cities, meticulously defining primary and foreign keys for each. I believe I presented a very thorough design.
Despite what I felt was a strong performance in both rounds, it was disheartening to receive a rejection email.
Interview Questions (3)
I was asked to talk about a project that I'm proud of. This was a conversation with basic questions on choice of database.
I was asked to design a table schema for a platform similar to BookMyShow. I created a very vivid and normalized schema showing artists, movies, theatres, halls, shows, users, bookings, cities with primary and foreign keys.