Hi all, I was recently interviewed at Oracle OCI for IC3 Position for which I got selected about 2 months ago in Feb 2023, but unfortunately due to hiring freeze my offer letter has never been relesed. So, I gave up on OCI and hence writing my interview experience here.
-
Technical Screening Round (In-Depth) :-
-
https://leetcode.com/problems/longest-substring-without-repeating-characters/
-
Where do you mention env changes in the helm chart
-
You have a table, write a query to output day wise total sales
**select sum(amount) from sales group by sale_date LIMIT 2** -
How does migration file looks like inside?
- How to modify migration file such that few rows contain one set of default value and few other rows contain another default value
- How does migration dependencies work…ex:- for 006_ini file only 005 dependency will be there or 001, 002, 003, 004 all will be there? (Ans :- only 005 will be there)
-
How do you write an endpoint for email service
-
How to you do load balancing…which algo?
-
Write a cron job syntax 0 * * * *
-
what states did you use in react? write syntax for usestate and how to you update the state?
-
Difference between props and state
-
How do you access DOM element in react
-
Write an onClick function
-
Write a promise
-
Write a axios POST request
-
How do you pass props from one component to another
-
How to list databases in settings.py file in django and can we declare multiple database instances?
-
What is Installed Apps in settings.py
-
How do you do Two-Factor authentication
-
psql commands for PostgreSQL
- List all tables in a database
- Connect to a database
-
Have you used celery? how does celery work internally?
-
Is axios asynchronous?
-
-
Round 1 :-
-
Projects Done / Tech Stack / K8s
-
Have you worked with Terraform
-
Tell me a time where you had to learn a new skill
-
What is your daily responsibilities include, how much coding / team managing?
-
What is your biggest professional achievement so far
-
Mutable vs immutable difference
-
When to use list and when to use dictionary and when to use tuples
-
How do you measure time taken for a function in python. Imagine you have 100’s of functions
-
shallowcopy vs deepcopy in python
-
Hackerank coding problem - find finest food outlets
-
-
Round 2 :-
-
What is the biggest obstacle you have faced?
-
What is the biggest professional achievement so far?
-
Architecture for QAHub
-
What is your daily responsibilities include, how much coding / team managing?
-
[System Design] Implement recommendation system for online book store
-
-
Round 3 :-
-
[First 30 minutes] - Grilled on every part of resume, got to know more about my roles responsibilities and contributions at current company.
-
[Last 30 minutes] - Hackerrank puzzle problem
-
-
Round 4 :-
-
What projects did you do in your current role?
-
Difference between var and let
-
Difference between Angular and React?
-
Is React MVC?
-
Code in JS to open a url
-
Code in JS to refresh page for every 30 seconds
-
Given 4x4 matrix, divide the matrix into 4 equal segments such that each segment is not a square or rectangle and they should not bisect
-
Ans :- It is not possible to divide a 4x4 matrix into 4 equal segments such that each segment is not a square or rectangle, as any partition of a 4x4 matrix into 4 equal parts must result in either 4 squares or 2 rectangles. This is due to the fact that a 4x4 matrix has an equal number of rows and columns, and thus, any partition into 4 equal segments must have either the same number of rows and columns in each segment, resulting in squares, or different numbers of rows and columns in each segment, resulting in rectangles.
-
data = 1010100
-
sort this data
-
write unittests
-
Difference between shallowcopy and deepcopy
-
Which module do you use for unittest
-
Store username and password in sessionstorage and get them and clear them after 5 minutes
-
data = "I Like Oracle and Oracle Likes You"
-
Count frequency of each word in above string
-
Since you are UI developer, do you have any personal blogs to show? I said Not completely ui but based on requirement, I act as full stack bla bla bla…..
-
-
Round 5 :-
-
Your react app is taking time to load, how would you troubleshoot it? What performance techniques do you follow? Lets say you have a webpage, how do you troubleshoot in it
Ans :- I said I will open the console and check the performance tab and see how much time the static files are taking and I will be using a CDN to get the static files faster.
Question :- Let’s say if CDN storing above 10 MB is costly, how would you handle it? I said we can use some kind of compression algorithms to reduce the size that is being transferred over network -
Lets say you have a CRM dashboard, where once user call gets connected, next step is fetch metadata like personal info, last 5 transactions, account details etc…. now when the customer agent says pls wait for a minute, your data is loading, its a waste of time for the end user. so how would you handle such scenario?
- Asynchronously precompute the data as soon as the user call gets connected and store it in a in-memory cache like Redis.
-
Tell me a situation where got a work which you did not like and yet you had to do it?
-
If there is only frontend work in the team, would you do it?
-
If there is a cool-off period and there is monitoring/support kind of work, will you take it as an opportunity and do it?
-
How to do you analyze SQL query which is taking lot of time to execute.
-
Design a system where you have to read log files and raise exceptions in it and create a Jira ticket in it.
- Ans :- edge case :- If there are same exceptions from multiple users, then should not create multiple tickets, instead we only have to raise 1 Jira ticket corresponding to it.
-
Have you used useCallback and useMemo ?
-