I applied through university. The process took 1 day. I interviewed at Oracle (Surat) in Aug 2016
Interview
Oracle and OFSS had come for campus recruitment in August '16. There was a 1 and a half hour combined test for all profiles of Oracle India and OFSS consisting of everything from aptitude, reasoning, verbal to coding and technical etc. They had various criteria for shortlisting students for various profiles. For associate consultant, they weren't concerned at all about coding/technical.
Since I'm a mechanical engg, they asked me A LOT about the basics. The questions then shifted to GK and Current affairs and then towards SQL.
Interview questions [1]
Question 1
What is your favourite subject and questions related to it.
Cleared OFSS drive: online DSA + MCQs, two technical rounds with OOP and coding problems, project deep-dive, SQL questions, and HR; focused on clear thought process and implementation details.
OFSS interview: online coding (DSA) and concept MCQs, on-campus rounds asked OOP principles, live-coding (strings/linked lists), SQL and system questions, then detailed discussion of my projects and fixes.
OFSS selection: timed DSA challenge plus core CS MCQs, two tech rounds covering OOP, Java, SQL, and a coding problem; final round probed my projects, design choices, and debugging approach.
interview process is structured and technical, usually involving a recruiter screen, multiple coding rounds, and a "Bar Raiser." Expect deep dives into SQL, data structures, and system design but manly have stories ready a a whole bunch.
I applied through university. I interviewed at Oracle (Mumbai)
Interview
Position was in the consulting division. It was for fresh graduates
There were 3 rounds
First 2 technical
Technical rounds involved dsa plus sql queries and technical questions on databases
1 hr
standard behavioral questions