It had three levels : technical interview, hr + technical interview and hr interview. Technical interview asked about domain knowledge and SQL queries and some puzzle questions. Hr+ technical asked about the project and whole about resume. And last round was just the confirmation round and was asked about relocation
I got into Oracle by Campus placement. There were 3 rounds of technical interviews. In each round i was asked technical and behavioral questions. Technical questions were related to data structures and algorithms.
Long interview process with little to no communication with a recruiter who never answered or was helpful. Led me on throughout the entire process telling me how I would be a great fit for the company and had me go through a final 7 hour round interview just to tell me weeks later that I did not get the job.
Interview questions [1]
Question 1
Using props in front of you right now come up with a story that has a plot, conflict, and a resolution.