Oracle | Associate Consultant | 2022 Grad
Anonymous User
3269

Oracle Interview Experience & Compensation for Associate Consultant FTE

Education: B.Tech(Electronics and Instrumentation) Tier 3
Compensation: 8.3lpa CTC (7.5lpa+77k bonus)

Description of the Process:

There was a total of 3 rounds of interviews. One online test and 2 technical interview rounds. 1 Aptitude Test, 2 Entirely Technical Interview all in one day. Due to covid-19 all the process below was conducted online on Zoom. Within 1 hour of the process completion we received the offer letter from Oracle.

**Online Round: **

Aptitude Test: (Total duration: 2 hours)

Test is section based and time based. Test is long and stressing but you can take breaks in between sections. Keep some time at the end to make a calculated or random guess (No Negative marking).
Imp. Topics for the test: AVL tree, Coding Flow charts, SQL queries, OS (Major topics like deadlocks, understand process and threads their scheduling algorithms), Database, OOPs (Do it well All major practices like encapsulation, Abstraction, Inheritance, etc).

Technical Interview Round 1:

2 LC easy questions, basic DSA questions, SQL queries, questions related to Project, OOPS concepts

Technical Interview Round 2: The interview was conducted on the Zoom, and it was around 30 mins. The interview started with a basic self-introduction and then the interviewer started with the technical questions.

SQL queries
Asked questions related to project,ML,Cloud
What is Inheritance? Write a code showing Multiple Inheritance
What is Polymorphism? What are the types of Polymorphism?
Write a code for Function Overloading,demonstrate Runtime Polymorphism.

Wanted to know if I can shift to SDE/MTS roles in Oracle internally after I join the company?Please any insights will be really helpful

Comments (2)