Status: 4th Year, ECE from Tier 2 Private
Position: Associate Consultant at Oracle Finance
Location: Pune/Bengaluru India
Date: 27th August 2024

Online Assessment (90 min):

• General Aptitude
• Basic questions of OS,DBMS,CN
• 1 DSA question (medium dp)
  submitted the paper under 40 minutes to get shortlisted for the next round

On Campus Interview (3 rounds):

• Round 1 (45 minutes):

  1. Resume related questions. pointed out keywords and internship experiences and asked about the same, asked me to explain each of my project with their real world application.
  2. Gave two basic DSA problems to write on a piece of paper, one in c++ and one in python as both languages were mentioned in my resume.
  3. Asked me to write certian sub-queries and join queries to test by SQL knowledge, gave a problem statement and told me to draw an ER diagram for same.
  4. Lastly he asked about basics of real world finance, credits scores, collateral, financial institutions responsible for overlook of certain aspects of economy.

• Round 2 (50 minutes):

  1. Asked about SDLC, and LLD of projects i mentioned in my resume, interviewer was adamant on getting the correct keyword as answer from myself.
  2. Asked about OOPs in JAVA, gave some basic scenarios of OOPs implementation in real world and asked to write thier code.
  3. Asked me to solve Logical Reasoning and Intermediate Math questions with pen paper.
  4. Asked Behavioural questions, regarding why i want to join, why oracle, your experience while working with teams, higher study plans.

• Round 3 (5 minutes):

  1. HR round, general interaction with HR responsible for the drive, asked about location prefernce, higher study plans, salary breakdown and date of joining.