The whole hiring process was virtual. The pre-placement talk was held on Zoom in August 2020. It was a combined session of 3 colleges together- NIT Hamirpur, NIT Durgapur, and NIT Silchar. Around 400+ students of CSE, ECE, Electrical, and Mechanical Engineering attended the talk. The recruitment drive was held after a few days.
Round 1(Online Test): The test was held on its own platform for around 150 minutes. There were 5 sections and further subsections in each section. You can attempt the sections in any order. There was a time limit in each subsection. Once answered, you cannot navigate to the previous question.
- Section 1(Software Engineering Aptitude): It consisted of 46 questions to be solved in 60 minutes. It had various aptitude based 2-3 subsections with individual time limits each. Time is the key here.
- Section 2(Coding Skill (Basic): It had 10 MCQs to be answered in 20 minutes. There were 2 main codes in java on tree traversals and output-based 5-5 questions were asked on each code. Basic knowledge of AVL, binary trees, stacks, queues would be enough here.
- Section 3(Computer Science Knowledge): This section had 20 questions to be answered in 30 minutes. The questions were based on the basics of OS and DBMS. SQL queries, keywords used should be known.
- Section 4(Contextual Communication): It had 30 questions for 35 minutes. There were subsections-comprehension-based, grammar-based, sentence formation, vocabulary test- which word would replace the best, etc.
- Section 5(Communication): It had only 2 subjective questions to be answered within 7 minutes and the limit was 250 words each. They were
- What attracted you to work for Oracle?
- What are your biggest achievements to date?
The test was lengthy and tiring but of moderate difficulty. Good time management was required. There was no negative marking. Webcam monitoring was on while navigating through the questions.
73 students were shortlisted for the interview process held on the next day.
Round 2(Technical Interview): All shortlisted candidates were scheduled alphabetically (which I realized later) from 9 a.m. and I was scheduled for 2 p.m. That itself made me nervous. They provided us with some guidelines and instructions beforehand on how to appear for Zoom interviews. All students were firstly permitted in the main meeting room and then redirected to the breaking room for 1 to 1 interview. The worst part was the long waiting.
The interviewer quickly scanned through my resume and asked for my introduction. He then provided me a link to a code editor where I was asked to write the code in any preferred language. The question was- Given an array of elements. Print the element which occurs the maximum number of times. I quickly compiled it successfully using hashing and he tested it on a few test cases. He also asked about the complexity and some follow-up questions. He seemed content and moved on to further questions.
He asked about the projects in detail, the technologies, and frameworks used, etc. Some of them were- Explain the REST API architecture? And more in-depth questions on the same. Then, since I had written SQL in languages known, he asked questions on DBMS. Difference between MySQL and others and if I had worked on them? What is indexing? How is it implemented? Questions on BCNF and normalization. Then he moved on to transaction management. Suppose you are withdrawing money from your bank account, and I am depositing money into it at the same time. How is atomicity maintained during this? I had a long discussion on this on checkpoint mechanism, commit operation, various locking protocols, etc.
Then he asked some more questions on my resume- what software I have used, which versions and what did I do on them etc. In the end, he asked if I had any questions, to which I asked about their expectations from freshers for this role? This interview went on for 30-40 minutes. Then I was asked to leave the break room but not the meeting.
Round 3(HR interview): After waiting for about 2-3 hours in the zoom meeting with 15 others, I was re-directed to another break room for a 1 to 1 interview. While the interviewer looked through my resume, I gave my quick introduction. Then he inquired about my projects. I explained all of them sequentially in brief and one intern project which he seemed more interested in, in detail. He listened to it very interesting and was nodding in assurance which increased my confidence manifold. Then he asked about my extra-curricular, to which I explained all the clubs and societies I am part of in college, my hobbies, etc. He asked about my long-term goals- I gave him my well-prepared answer on why Oracle and career goals. The next he asked to tell me about my biggest achievement till now. I named a few and ended with-to secure a job at Oracle would be my next! He smiled a little and seemed impressed. He lastly asked if I had any questions for him, and I asked the same again- what skillset you expect from freshers like me? He explained to me very well about the training and project work later. Then I was asked to leave the break room.
I was back at the main meeting where the host told me that I was done for the day and can now leave the meeting. It was 6 p.m. and the results would be shared with the TPO.
Results were declared the next day and 23 people were selected.
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready. To complete your preparation from learning a language to DS Algo and many more, please refer Complete Interview Preparation Course. In case you are prepared, test your skills using TCS, Wipro, Amazon and Microsoft Test Serieses.