I applied through a recruiter. The process took 3 days. I interviewed at Oracle (Calcuta) in Apr 2017
Interview
I was contacted by a recruiter on LinkedIn on Wednesday night and the interview took place on Saturday morning after I had cleared their online tests. I had basically no time to prepare. I am a QA analyst but this interview was for a Developer position and the recruiter did not mention this to me eventually leading to a lot of embarrassment for me. During the interview I was taken to a separate room and there were 2 people who asked me technical questions. They also probed me about my academics and whether I had a lag year and if I have EVER failed in a subject. They were nice people- even though I could not answer most of the stuff they did not discourage me but gave hints trying to help me out. However when I asked one of them, "What is it like working in Oracle? ", they gave me a reply which made me feel bad- he said : (Quoting from memory) "In Oracle we are responsible for our own work. We don't deliver work to client somehow and then run away like service-based companies do". Now I have 4 years of experience in a service-based company and I assure you that is not how we function. I did not say this aloud but apart from this small incident, the interview was good. I learned a lot.
Interview questions [1]
Question 1
1. OOP concepts- inheritance, static keyword
2. Design classes and methods to implement a "Parking lot" problem
3. SQL queries for scenarios- Lead, Lag, Rank, group by, joins
4. Difference between analytical functions and aggregate functions
5. How can you swap values of 2 columns in a table using a single query?
6. What is the reason you are looking for a change of job?
1 technical phone screen covering basic networking and data structures, followed by a 4-round onsite loop focused heavily on Oracle Cloud Infrastructure (OCI) scale challenges. The rounds were split between low-level system execution, multi-tenant cloud architecture, and standard relational/non-relational database trade-offs. The interviewers kept drilling into network virtualization, hypervisors, and storage layers.
To prep, I needed to brush up on high-throughput cloud networking patterns and storage engine internals. I utilized Apex Interviewer to simulate full cloud infrastructure design problems.
Interview questions [1]
Question 1
Design a highly secure, multi-tenant virtual cloud network block storage migration system that allows live volume transfers between physical data centers without dropping active I/O operations.
Mostly coding question focused, and some talking about personal experience and terms. Some technical design, you could have chosen any language to complete the coding questions. Questions were simple technical concepts that person came up with at the moment.
Interview questions [1]
Question 1
Something like searching in logs using maps and filter/find data
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
