SDE - 1

Interview Experience: First Round: The interviewer began with a coding problem: finding the longest substring without repeating characters. After solving the problem, I was asked to optimize my solution further. Following that, we discussed some basic SQL queries, including row-based operations and MongoDB pipeline stages. The interviewer also inquired about the differences between SQL and MySQL, delving into their key distinctions and use cases. Second Round: The second round started with questions about my previous work experience, particularly focusing on how I optimized database queries in my last role. The discussion then shifted to a high-level design question, where I was asked to create a database schema along with the required APIs. Additionally, I was tested on SQL concepts, including various types of joins, the purpose and functioning of indexing, and the underlying algorithms used in indexing, as well as their significance in query optimization.

I had the opportunity to interview with Spyne through a referral from Coding Ninjas, which helped me connect directly with their hiring team and showcase my skills during the process.

I was rejected for the role at Spyne despite answering all the interview questions, which suggests that there may have been other factors, such as a better-suited candidate or specific experience requirements, that influenced their decision. This experience motivates me to continue improving for future opportunities.