I applied through college or university. The process took 2 days. I interviewed at Oracle (Pune) in Jul 2014
Interview
Asked both, analytical as well as coding questions...3 questions analytical and 2 questions based on coding. Good interviewer from Pune office. All part of campus hiring process
Bridge and flashlight problem
Who reaches 50 first is eliminated from game
McNuggets Problem
Bubble sort code
Thoery of hashmap and how to implement a search algorithm given same last names and varying first names
Mostly coding question focused, and some talking about personal experience and terms. Some technical design, you could have chosen any language to complete the coding questions. Questions were simple technical concepts that person came up with at the moment.
Interview questions [1]
Question 1
Something like searching in logs using maps and filter/find data
decent amount of DSA and System design were asked, and behavioral questions. so prepare leetcode level questions and good amount knowledge in sql, java and also mostly oracle sql. overall it was good
First online assessment. Then 2 interview rounds + 1 hr round. This was during campus placement. In interviews they mainly asked about dsa, os concepts, logical questions and some system design questions also.