I interviewed for a Member of Technical Staff position at Oracle in Redwood, CA. I was contacted by a senior recruiter on LinkedIn, who found me through the Grace Hopper Celebration Spotlight. I was asked to apply to open positions in multiple organizations and then later asked for my top two preferences to schedule interviews.
The interview process consisted of a phone screen, two technical rounds, and a final round of interviews. The phone screen lasted 30 minutes and included behavioral questions and questions about my technical skills.
The first technical round was with the Oracle Application Development (OAD) team. The interview lasted one hour and involved writing a program that takes a set of dictionary words and fits them into a matrix of a given size, such that all the words in the matrix are readable. I struggled with this question and was not able to come up with a fully functional solution.
The second technical round was with the Oracle Application Cloud (OAC) team. This interview also lasted one hour and included the following Leetcode questions: Single Number, Reverse Linked List, and questions about my past projects and work experience.
After a week, I was informed that both teams wanted to move forward to the final round of interviews.
The final round consisted of three back-to-back interviews with each team, lasting one hour each. The first interview with the OAC team included two aptitude questions, some SQL-related questions, one Hashmap-based question, and questions about my past projects. The second interview with the OAC team included the following Leetcode questions: Add 2 numbers, Moving Average from Data Stream, and questions about my past projects. The third interview with the OAC team included basic questions about Machine Learning (as I am a TA for an ML class), implementing a sorted linked list, and questions about my past projects.
The final round with the OAD team consisted of three back-to-back interviews, lasting one hour each. The first interview included questions about my past projects. The second interview included the following Leetcode questions: Rotate Array, Design an instant messaging application (e.g., WhatsApp), and questions about my past projects. The third interview included designing a file system and questions about my past projects.
The system design questions were a bit unexpected for a new grad role, but I was able to handle them.
After a week, the recruiter asked me to rank the teams I would like to receive an offer from. I responded with my ranking and was verbally extended an offer from my first preference team two days later. I received the offer letter three days after that.
I have seen people mention solving 500-600 Leetcode questions before interviews, which honestly scared me. I recommend being consistent with practice instead, solving 1-2 questions every day and noting what you did right and wrong. I was also fortunate to have really nice interviewers who were genuinely interested in bringing me onto their teams (except for one interviewer).