I applied through college or university. The process took 1 day. I interviewed at Oracle Engineering Group
Interview
Questions w.r.t PL-SQL and JAVA were asked. The process took a day at max. You may also be asked questions w.r.t your previous experience. Nowadays, you could also be questioned on microservice as their product tech stack varies with the version.
Interview questions [1]
Question 1
OOPS in JAVA and a few regarding procedures and triggers in pl-sql.