Summary
I successfully secured an internship offer for the SDE+ML+Data Analytics role at MotorQ after navigating through a rigorous interview process that included an online assessment, two technical rounds, and a final discussion with the CTO.
Full Experience
I was shortlisted for the online assessment along with 200 other candidates out of an initial pool of 300. The online assessment consisted of three coding questions: one easy and two medium, which I had 1.5 hours to complete. I managed to solve 2.5 questions, finding the third one quite challenging, as only one student could fully complete it. Following this, only 6 out of 200 students were shortlisted for the interview rounds.
My first technical interview was conducted virtually using Microsoft Teams and Visual Studio Code's Live Plugin for collaborative coding. During this round, I was asked to design a database based on a specific set of conditions and also discussed various top SQL queries and range SQL queries.
The second technical interview began with a deep dive into the projects listed on my resume. Following this, I was presented with two Data Structures and Algorithms (DSA) problems, along with questions on fundamental DSA concepts and DBMS theory. One of the DSA questions involved determining the k maximum sums achievable by picking one element from each of two given arrays.
After these two rounds, only 3 students were shortlisted for the final CTO round. My interview with the CTO focused on assessing my compatibility with their organization. We discussed my projects extensively, and I answered specific questions regarding Firestore, its performance differences compared to relational databases, and database indexing. Towards the end, I was asked about my availability for the internship and given an opportunity to ask my own questions. Ultimately, I was one of the 1 out of 300 students selected for the internship at MotorQ for this specific profile.
Interview Questions (3)
I was asked to design a database for a given condition. Additionally, I discussed top SQL queries and range SQL queries.
Given two arrays, I had to find the k maximum sums by picking one element from each array.
The CTO asked me specific questions about Firestore, including its performance differences compared to Relational Databases, and about database indexing concepts.