I applied to Oracle through Naukri and a recruiter reached out to me via email. I was informed that a total of four rounds would be conducted on the same day and prepared accordingly.
Round 1 Coding I was asked to solve these two problems:
Round 2 Technical Interview I was asked to explain my approach and reasoning for both coding problems. I was also given a slight modification to one of the problems, but I don't recall the details. After that, I was presented with this problem: There are two data sets consisting of random numbers from 1 to 50K in one array and 1 to 60K in another array. I have only an array of size 10 and need to sort both arrays (50K + 60K) resulting in an array of 110K elements in ascending order. I suggested using a sliding window to sort the elements, but I wasn't sure how to implement it or if the approach was correct. I explained that I could sort the 50K and 60K arrays in-place using quicksort and combine them using the logic of mergesort. I discussed both sorting algorithms with the interviewer. He acknowledged that it was okay if I didn't know the solution to this problem and we moved on. Next, he asked a few questions about SQL using a sample Employee table. He asked questions involving joins, subqueries, filtering with the WHERE clause, and grouping by the primary key.
Round 3 Manager Round The manager round was more of a discussion than an HR interview. He asked me a few questions based on my previous experience as a full-stack developer at another company. He inquired about my team and asked for instances where I faced a challenge and overcame it. He mentioned beforehand that he would ask seven template questions, which revolved around general HR topics. The next 45 minutes or so were spent explaining how Oracle is developing products globally, covering multiple languages, scaling for billions of users, and emphasizing the importance of inclusive design. It wasn't a stressful round for me. Existing employees had told me that system design would be included, but perhaps due to my limited IT experience (one year), it was omitted. Finally, he asked for my expected CTC, and I stated 10LPA. The role was Applications Developer 3. I later researched the current salary for AD3 and regretted giving such a low number. I considered asking for a higher number in the next round.
Round 4 Director's Round Only two questions were asked in this round:
Before he could finish the interview, I interrupted him and asked if I could change my expected CTC to 17LPA. He agreed. We said our goodbyes and parted ways.
I was later contacted by the manager and informed that I was selected. The application needed to go through six levels of approval, from him to the board of directors. I waited.
After about a month, I called him to inquire about the status and was told that my application had reached four levels and the final two were pending. Fifteen days later, I called him again. He told me that I was about to receive the offer letter in two days, but they had implemented a hiring freeze and were told to hold offers and cancel pending interviews. He assured me that he would re-apply when the freeze ended.
Fast forward to December , I received a call from the manager informing me that he was re-applying and it might take time to receive an offer. I waited, and in the second week of January , I received the offer letter. It was an anxious wait of about 3.5 months to get the offer letter. However, I had joined a startup company in the meantime and worked there for three months. I quit after receiving this offer letter and am set to join Oracle by the end of this month. Always be aware of your situation and make your decisions accordingly.
Role: Applications Engineer (Applications Developer 3 was the initial role when applying, and this offer letter also had the same name. Perhaps in Oracle, both roles are similar.) CTC: 17LPA + 4LPA relocation bonus Joining Kit: MacBook Pro + Accessories Benefits: Flexible Benefit Plan - meaning YOU can choose how much goes into HRA, TA, Superannuation, Insurance, etc.
So be patient, and Oracle will deliver its promise! :)