Oracle || MTS || New Grad 2023 || India || On Campus [Offer]
Summary
I successfully interviewed for a MTS New Grad role at Oracle's Bangalore office through an on-campus selection process in August 2022, ultimately receiving an offer for a full-time position.
Full Experience
Hiring Process
The hiring process consisted of an Online Assessment followed by three interview rounds: a Project + DSA round, a dedicated DSA round, and finally an HR round. All interview rounds took place on the same day.
Round 1: Online Assessment (90 minutes)
This round had a coding problem, a SQL problem, an API implementation problem, and six MCQs. The coding problem was a LeetCode medium, the SQL problem was easy, and the API implementation was fairly basic. The MCQs were very easy. I managed to complete this round in about an hour. After this assessment, selected candidates were invited for the interview rounds.
Round 2: Project + DSA Interview 1 (30-40 minutes)
This round began with a basic introduction. The interviewer immediately started discussing my projects. We delved into topics like authentication, NodeJS, REST APIs, PassportJS, and the differences between SQL and NoSQL databases. I was asked to write code for connecting to MongoDB. I honestly told him that I usually copy such code from documentation, and he laughed and skipped the question. Afterwards, I was given a problem which was a variation of string matching. I mentioned algorithms like KMP and Rabin Karp, but the interviewer asked me to write only the brute force solution. I felt this round went pretty well for me.
Round 3: DSA Round 2 (30-40 minutes)
This round also started with an introduction. The interviewer quickly opened HackerRank and presented a problem involving a priority queue. I came up with the brute force solution within a minute and optimized it in another minute. I then coded and ran the solution very quickly. The interviewer asked if I had any questions for him, and when I asked if this was the end of the round, he confirmed it. This round concluded within a surprisingly short five minutes!
Round 4: HR Round (40-50 minutes)
This was definitely the highlight of my day. The HR interviewer was incredibly friendly and highly interactive. This round didn't focus on CS fundamentals or DSA; instead, it involved scenario-based questioning designed to understand my thinking process. I was asked many situation-based questions, and I recall making up a lot of stories on the spot to answer them. The interviewer seemed very pleased with my responses, and we shared many laughs, almost like we were old friends. I never imagined an interview could be this enjoyable and easy.
Result
I was selected for a full-time role as a Member of Technical Staff (MTS) in the server technology team.
Interview Questions (2)
Write Code for MongoDB Connection
The interviewer asked me to write code for connecting to MongoDB. I explained that I typically copy such boilerplate code from documentation, which prompted the interviewer to skip the question.
Variation of String Matching Problem
I was presented with a problem that was described as a variation of a string matching problem. Although I was familiar with algorithms like KMP and Rabin Karp for string matching, the interviewer specifically requested a brute force implementation.