I interviewed for an Application Engineer position at Oracle in /. The interview process consisted of a written round, four face-to-face interviews, and an HR round.
The written round was conducted on Oracle's platform and lasted 122 minutes. It included multiple-choice questions on software aptitude, English, coding skills, and technical skills such as OS, DBMS, OOAD, and CN. The questions were divided into smaller sections with a time limit for each.
The first face-to-face interview was a technical round lasting 45 minutes. The interviewer asked me to implement the next_permutation() function in C++ and then asked another candidate about an Excel sheet problem. After this round, another interviewer asked me two more coding questions: a product array puzzle and a question about finding the alphabet that doesn't occur in a given paragraph. The key to this round was to provide simple, quick, and optimal solutions in terms of time and space.
The second face-to-face interview was another technical round lasting two hours. The same interviewer asked me about the manhole puzzle, and after I provided several solutions, he changed the question, saying they were all incorrect. He then asked me to design a database that could calculate and predict the finishing date of a project using queries. After a lengthy discussion, he finally agreed to my solution. He revealed that he was satisfied with my solutions from the beginning, and the interview was intended to assess my ability to come up with multiple solutions under pressure.
The third face-to-face interview was a managerial round lasting 75 minutes. The interviewer was very friendly and helpful. He began by discussing my background, hometown, and family, and then moved on to my resume, asking detailed questions about my school, achievements, and projects. He then asked me technical questions about normalization with examples, followed by questions about why I chose Oracle and why I was interested in this specific role. He also asked some questions related to a presentation I had prepared. Finally, he gave me a design question where I had to create screenshots of an app for library management, covering all aspects and details, and design the backend tables in a normalized manner along with the functional dependencies. I worked on this for about 45-50 minutes, and he was satisfied with my solution.
The final interview was an HR round lasting 20-25 minutes. The HR representative was neither friendly nor strict. She asked about my background, family, hobbies, and why I chose Oracle. She also inquired about my location preference and the reason behind it. This was followed by a character test where she asked about my strengths and weaknesses. I was also asked some questions related to the presentation.
After a long wait, I received a job offer from Oracle.