I applied through university. The process took 1 day. I interviewed at Oracle (Coimbatore) in July 2015
Interview
Initially, Online test was conducted ( 4 sections - Aptitude, Computer science, Logical and puzzle ) related questions and difficulty level was above average.Results came 3 days later and out of 700 students 97 got shortlisted from our college and they said that next set of interview process will go through in another college. So, Finally they shortlisted around 250 students (3 colleges including us). Again next there was logical reasoning written test where 4 questions were given and that questions has to be solved in 30 minutes and they mainly checked explanation part in how student have approached the problem and not for the correct solution. After that 100 students were shortlisted from 250 and the next round was paper coding round.They mainly checked logic part and 57 students were totally shortlisted for final set of technical interviews.
Interview questions [1]
Question 1
How does Bit Torrent works? Protocol?
Zigzag traversal of a binary tree
SQL queries
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.