The interview consisted of 5 rounds: 3 telephonic and 2 F2F.

1. The first round was telephonic and covered basic Java, SQL, and puzzles.
2. The second round was F2F and lasted approximately 1.5 hours. It focused on Java Collections, programming, and algorithms related to sorting and searching.
3. The third round was a US call with the recruiting manager and was managerial in nature, asking questions like "Why Oracle?" and "Why are you leaving your previous company?"
4. The fourth round was another US call, this time with the Director of Development. Questions included "Why IT?", "Why Oracle?", and from a technical perspective, "What is the most challenging problem you have solved in your project and how did you resolve it?" There were also some questions regarding multi-threading.
5. The final round was F2F in Oracle Bangalore, lasting about 1 hour. It covered J2EE architecture and project details. They explained their proprietary architecture and asked how it could be applied to my project. This round aimed to assess adaptability to their environment and architecture.

The total duration of the interview process was about 1.5 months.

The final HR round was regarding compensation.

What is the worst scenario you have encountered in your project, and how did you resolve it? The questionnaire continued for a long time based on the responses given.