I applied through a recruiter. I interviewed at Oracle in Jul 2017
Interview
It was a one day process with written and 2 technical interview. After clearing all the round after 3 days hr called to submit docs, there process is very very slow it tooks months for them just to release intended offer, still after 2 months they told it is in pending status after 2.5 months they told it is on Hold.
One suggestion don't just wait for their offer they will takes months and might not release one by saying that we have hiring freeze.
Oracle is the worst in recruitment and giving hikes. Please try for other better fortune 500 companies
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.