I applied through college or university. I interviewed at Oracle (Pittsburgh, PA) in Jul 2017
Interview
I applied through college and recieved a reply that I matched with a couple of teams. One of the teams was the Cloud and Silicon Team. I had one phone interview with two interviewers on the other side (one PM and one engineer). They asked me details about my projects and discussed multithreading/concurrency problems.
The second interviewer was based in Texas. He called me up and jumped on directly to a system design question where I had to design a banking transaction system that has services in New York, Tokyo and Bangalore. Each of them has a database at the location that only the server at the same location can access. Somehow, all the data in the three databases in always replicated. He wanted me to build a system somehow that would solve concurrency issues when a request from one user was recieved at all three servers at the same time.
Now, he placed a few constraints.
1. The servers cannot forward requests to each other.
2. They cannot access (or lock) each other's databases.
3. We cannot add more servers.
4. We are not allowed any global timestamp.
Basically, he added constraints as I gave the solution. When I had no answer left, he blurted something like "Nowadays, graduates have no idea about building systems". Then he moved on and said "Do you have any questions?". I responded "Sir, could you tell me the answer to the same question?".
Obviously, the guy had no answer. I'm glad I am not a part of his team.
decent amount of DSA and System design were asked, and behavioral questions. so prepare leetcode level questions and good amount knowledge in sql, java and also mostly oracle sql. overall it was good
First online assessment. Then 2 interview rounds + 1 hr round. This was during campus placement. In interviews they mainly asked about dsa, os concepts, logical questions and some system design questions also.
I applied through other source. I interviewed at Oracle (Seattle, WA)
Interview
i got a return offer from internship, and I had to do one additional technical interview because I was switching branch. He first asked me a OOP question, and then leetcode medium level question.
Interview questions [1]
Question 1
What is BST? Write a function that verifies if it is a BST.