I applied through college or university. The process took 1 week. I interviewed at Oracle (Redwood City, CA) in Nov 2011
Interview
Was emailed by the recruiter for an onsite invitation without any phone interviews.
Was told to pick from a set of short listed groups, mostly revolving around databases. Groups were selected by the recruiter from what they think matches my resume best. Some of the groups selected weren't really what I was interested in.
Out of the groups I selected I only met with 1 group, the recruiter added 2 more groups which I did not select to my set of interviews for the onsite.
Only did 3 interviews for my onsite, few technical questions. Interviewers were generally friendly and comfortable to talk to.
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.
