I applied through college or university. I interviewed at Oracle (Bengaluru) in Aug 2024
Interview
It consisted of OT followed by 3 rounds (2 technical and 1 HR). All 3 rounds were elimination rounds. The interviewers were friendly, understanding and helpful. It was on-campus placements.
Interview questions [11]
Question 1
Given an array 1,2,3,4,5. Output 120,120,60,20,5 (Each element in the output is the product of all the elements starting from that index) Write code and time complexity.
SQL Query - given table student with attributes name, subject, and marks. Find the topper of each subject and return their name, subject and marks for that subject.
I did 6 interviews with 6 different people for a full-time role. After the last interview recruiter ghosted me for several weeks. Then the hiring manager reached out unexpectedly and said they can't offer a full time positions at this moment but they can offer a 6 month contract. It was not a trial period that would've transitioned to FT afterwards. They asked me to submit an application for the new role and start a new set of interviews. At the first interview for the new contract role, the interview showed up while it seemed he hasn't looked at my resume yet and asked a couple of question to which he didn't know the answer too. So he tasked me with doing research and finding answers to those questions and emailing him the result.
3 rounds of interview. first a written exam was conducted. computer based test. once you qualify cbt, a written test was conducted. then 2 rounds of interview happened. 2 technical and one hr.