Status: SSE & Tech lead, BTech CS from Tier 1
Position: IC3 at Oracle OCI
Location: Bangalore, India
Round 1 - HLD/LLD Round [60 min]
Design a Parking lot but it needs to be similar to Uber etc. As in one can see the available parking spaces in different parking lots to them according to their current location.
Some features included were -
a) Early booking can be done.
b) Geofencing should be enabled to show user the nearest parking lot with all the available spaces in it.
c) Specific places needs to be allotted for disabled person.
d) Handling of traffic at peak times. [Load balancers, optimised algoriths was expected]
e) If traffic is high and disabled parking is available, how will you do that?
f) How will you verify the correct customer who has booked is entering.
g) Create everything automated in parking lot.
h) Which databases should be used? Why?
The LLD was also expected. The interviewer can change the Functional requirements on the go. So try to create solutions with little bit of flexibility to introduce new changes.
Round 2- Hiring Manager
Talked about his team and what all the products they work on in details. What can I expect to work on after joining. Apart from this detail description of the recent project I did. Whole HLD, Problem statement, Success rates of the api's, how did I improve the efficiency of the system etc.
Other questions asked -
- How you choose database for your projects .[CAP Theorem based database selection was expected].
- ACID property? Explain Isolation and Durability.
- How do you manage projects which is very big and that can't be done in a certain period of time. How will you deal with such issues.
- Languages you have worked on?
- Why changing company?
Some other behavioural questions were also asked.
Round 3- DSA / Project discussion Round
- Explain current project. [Discuss using STAR methodology].
- https://leetcode.com/problems/valid-parentheses/
- https://leetcode.com/problems/longest-valid-parentheses/
- Also discussed some behavioural questions at the end.
Round 4 - DSA / HLD / Behavioural Round
a) What all microservices is there in your current project.
b) Describe the full flow of the process.
c) Some behavioural question on leading team and handling issues.
d) You have a sequence of string and a map -
Ex - [A, A2, A3, #ifdef FOO, B, B2,#ifndef BAR, C, #endif, D, #endif, E]
map - > {FOO = true, BAR = true}
The sequence of the strings needs to be printed according to the if condition. Whenever a ifdef is found, retrieve the value from the Map and if its true print the value inside it. IF #ifndef is found negate the value obtained from the map and then print accordingly. #endif is closing of the previous if block.
For example the ans -> A, A2, A3, B, B2, D, E
(C is not printed because ifndef was false).
Implemented stack for storing the flag for each if case and got the solution running.
Round 5 - DSA / System Design / Behavioural Round
- How do you decide the tech stack of any application you start working on?
- CAP theorem?
- ACID -> Isolation?
- Coding question ->
- You have two strings logs = "cabedlsbcald" and password = "abc".
- Find the number of substring where the permutation of password is available.
- Here, ans is 2 as "cab"[0 to 2 index] and "bca"[7 to 9 index].
- Solved using Sliding window approach.
One thing I have observed that OCI expects working solution even if its not the most optimal solution. Write some working solution first (if you have less time ) and then move on to the optimised solution.
If you dont have working solution, you might be penalised (or maybe not, since my interviewers were quite focused on running solution. Hence that might become the case).
Other experiences -
Flipkart - https://leetcode.com/discuss/interview-experience/1817457/flipkart-sde2-bangalore-feb-2022-offer/
Quizizz - https://leetcode.com/discuss/interview-experience/1785584/Quizizz-or-SDE2-or-Bangalore-or-Feb-2022-Offer
Compensation details - https://leetcode.com/discuss/compensation/1895309/Oracle-OCI-or-IC2-or-Bangalore