Oracle Interview Experience for ASE & Associate Application Developer (On-Campus) 2023

Greetings, fellow readers! I am a final-year Computer Science and engineering student at NIT Durgapur (2020-2024). Today, I am thrilled to share my Full-Time interview experience with Oracle.

Oracle conducted a campus recruitment drive at our college in the month of August 2023, offering opportunities for an Associate Software Engineer (ASE) and Associate Application Developer role in the CGBU (Communication Global Business Unit) [location: Gurgaon, Bangalore, Hyderabad]. The process consists of four stages Online Assessment + 3 Technical Round’s /2 Technical Round’s + HR Round.

ROUND 1: Online Assessment (OA) :

There are a total of 22 questions which are divided into 4 Sections.

• 1 Coding Question
• 10 Aptitude MCQ’s
• 10 English MCQs (Basic Vocabulary and Comprehension)
• 1 REST API

Pre-Placement Talk:

Those shortlisted from the OA were invited for the on-campus interviews on August 7, 2023. The day began with a pre-placement talk to introduce Oracle and provide insights into the roles they were offering.

ROUND 2: Technical Interview (60 Mins) :

• The Interviewer was friendly, Interactive and he was 10 years Experienced. He started with a basic Introduction of himself and then mine. After that he asked me to explain the logic of Merge two Sorted Arrays then he asked to me write the code.
• He asked which Data Structures are known to you. And he gave me the choice between String and LinkedList. I chose a linked list then he asked me to explain the logic of Delete Nth Node from the Last Node of a LinkedList. I Explained the Brute-Force approach after that he asked me to explain the optimized approach. In the beginning, I didn’t get an idea of the optimized approach so he asked me to write the code for brute-force so I started coding meanwhile I was thinking of the optimized approach after that I explained the Fast and Slow pointer approach.

In this round, he mainly tested how much clarity I had. Like the approach that was explained by me is same as I was coding or not?

ROUND 3: Technical Interview (60 Mins) :

• In this round, the Interviewer was a manager and he has experience of 14 years. This round mainly focused on technical and a little bit of HR questions.
• He asked which programming language he was comfortable with, I Said CPP. Then he asked do you know Singleton Class [Design Patterns], I said no.
• Then asked me what is Run Time Polymorphism. What is Virtual Function? What are the contents of Virtual Table? I explained Run Time Polymorphism and Virtual Function by writing code then he asked me from which line the virtual table would be called.
• What is Dead Lock? What is Multi-threading?
• Then he asked to Implement a Stack Using LinkedList.
• Then he gave me Course Table and Student Table and asked me to write the SQL query which will return the top two Courses which are enrolled by the highest number of students in Notepad. Here he didn’t give the Student-Course relation table so I asked him sir you didn’t give this table. Then he asked me that is it needed. I said yes as If there is no relation how can we say. Then he said okay take that Student-Course table and do the queries.
• At last, he asked me HR questions like What are your Strengths and Weaknesses? What is your biggest failure?

Summary:

VERDICT: Not Selected

The interviews went well and It was also my First Interview in FTE but the thing is I didn’t learn Web-Development In-Depth so I don’t have FULL-Stack projects but I have projects on Socket Programming and one SQL. Like what I understand from this Interview experience is that we must have projects that are known to most people like Development etc…

My Suggestion is that we have to give our level best performance for every opportunity which we get and regardless of the result we have to learn and Improve ourselves from everything As We Are Not Perfect People.