I applied online. The process took 4 weeks. I interviewed at Oracle (Denver, CO) in Apr 2018
Interview
The interviews tested me on scala coding skills on a github exercise and then they called for an onsite interview which had 1 Hour Lunch, followed by three (1 hour interviews) by 2 members of the team including the development manager. They asked majorly algorithms questions and sql
Interview questions [1]
Question 1
In the 1 st round:
(a) Find count of longest increasing subsequence in the given array of integers in O(n) time complexity
(b) Find the list of prime numbers between 1 to n
(c) Find highest salary of an employee given 3 tables: Employee ( E_ID, D_ID,E_NAME), DEPARTMENT ( D_ID and D_NAME) and SALARY ( E_ID and Salary)
and highest salary of employee per department
In the 2nd round:
How will you design a system (using Restful Web Service and any other design algorithm) when there is a feed of events coming in for <Person> object type which queries a Server hub for a linux box. Each linux box has a specified limit on memory and CPU (not same for all) and you need to optimize each person with his/her usage and find the count of number of logins
In the 3rd round:
(a) Find the frequency of difference from the median for a given column in a database
(b) Find the count of palindromes given a String
I applied through a recruiter. I interviewed at Oracle (Seattle, WA)
Interview
Fairly easy tech screen. Loop was a bit of a mess. Coding portions required AI which was not mentioned ahead of time. One of the interviewers told me to find bugs in some code using AI, but accidentally pasted the solution instead of the buggy code which led to issues.
I applied through an employee referral. I interviewed at Oracle (Nashville, TN)
Interview
Standard coding screen followed by loop rounds.
Loop rounds -
1. System design - focused on the infra aspect more
2. Behavioral - turned into technical quickly and did some white boarding to explain how I cracked a problem.
3. Bartender - as they are all from platform team, most of their questions were targeted for infra position and that confused me.
Bias for action seemed very important for them than any other principle.
Coding - another leetcode medium and was easy to solve.
Interview questions [1]
Question 1
System design - Youtube using barebones infra instead of ootb services
The interviews were mostly medium level leetcode questions. Takes a lot longer than you would expect. About 3 months from beginning to end. The offer stage and background stage take the longest
