The process took 4 days. I interviewed at Oracle (Redwood City, CA) in June 2009
Interview
I was contacted by a manager after having submitted my resume for a specific position. I spoke with him about the position and about his team. A few days later I went in for an interview. The team members seemed to be very sharp and all seemed to get along very well. I was asked specific questions in a number of one-on-one interviews about PL/SQL syntax, using PL/SQL collections, using JDBC in a Java program to iterate through a result set, various considerations when tuning a SQL database, how indexes affect execution plans of SQL, why indexing is important and how B+-tree indexes work.
Round 1 DSA
Asked a basic sliding window question and a few questions related to Java, like what are imaginary functions and then asked me a few questions based on my resume and then dived into technical aspects of it.
Interview questions [1]
Question 1
It was something related to a sliding window, a medium-level LeetCode
Very slow process. Took 4 months to reply on one interview. Multiple follow up was unanswered. Four Interview round was all cleared despite that it took time to reply. Overall good experience.
Interview process contained 1 phone screen and a full loop consisting of 2 coding, 1 managerial system design and 1 behavioral by bar tender
The process was fast and smooth.