I applied through college or university. The process took 2 days. I interviewed at Oracle in Apr 2007
Interview
The employer was very friendly and comforting during the interview. There were 4-5 1:1 interviews during the day, and each was about 30 minutes to an hour. It wasn't too technical as other software companies might be; it was more personal and casual. The culture was quite individual in that each one does their job without supervision on most days.
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.