For me there were two phone interviews, one with the recruiter and one with the hiring manager. During the second interview, I was told there were two other candidates that were being interviewed that day as well but I received a call by the end of the week that I was getting an offer for the position.
I applied through college or university. The process took 5 weeks. I interviewed at Oracle
Interview
30-40 mins English and aptitude test for the assessment. Followed by tech interview regarding my resume and areas of SQL, PL/SQL, Java and bit about cloud computing. Next a round of interview with managers where they briefed me about job role.
it was as very organized and smooth process. the question were simple and related to the project and skills mentioned in the resume submitted.
and simple questions on sql and string concatenation
They asked about project code and dig more about project and hr question and behavioral question in 2nd round it depends on the interviewer and on ur resume they mainly focus on ur resume staffs