motorq logo
Motorq· SDE+ML+ Data Analytics

MotorQ| SDE+ML+ Data Analytics| Chennai + Bay Area, USA| September 2020[offer]

Result
Offer
Location
Chennai, Bay Area, USA
Posted
2 Oct 2020
315 reads

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.

How it went

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.

Questions asked (3)

  1. 01

    Database Design and SQL Queries

    System Design

    I was asked to design a database for a given condition. Additionally, I discussed top SQL queries and range SQL queries.

  2. 02

    K Max Sum from Two Arrays

    Data Structures & Algorithms

    Given two arrays, I had to find the k maximum sums by picking one element from each array.

  3. 03

    Firestore, RDBMS Performance, and Indexing

    System Design

    The CTO asked me specific questions about Firestore, including its performance differences compared to Relational Databases, and about database indexing concepts.

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at Motorq recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

Be the first to share your thoughts and start the discussion!