top of page

Oracle

Pankaj Goyal

Member of Technical Staff (Server Tech)

NIT Warangal

Branch:

Electrical and Electronics Engineering

Session:

2022-2023

Offer obtained:  

FTE

Description of role:

NA

Job/Intern location:

NA

Eligible Branches:

All branches

Eligibility Criteria:

7 CGPA ( No Active Backlogs)

Selection Procedure:

Round-1 OT
Round-2 Technical
Round-3 Technical
Round-4 Technical + HR round

Description of Online test:

3 questions were asked:
1st question - DP (coding)
2nd question - REST API (Data Fetch + coding)
3rd question - SQL query

Description of Technical Interview:

The topics asked in the technical interview were Dynamic Programming, dfs, bfs, linked list, recursion, priority queue and trees.

Addition of two numbers in linked list with linked list creation (full code).
Loop in linked list.
Calculate the angle between the hour hand and minute hand in watch.
ACID properties in DBMS.
Basics concepts of DBMS and OOPs.

In the last Technical, they asked about every term mentioned in my resume (skills, tech stacks, projects, courses, certificates).

Description of HR Round:

Why do you want to join Oracle?
After joining Oracle, what are your goals?
Where do you see yourself in the coming 5 years?
They asked about my internship experience ( about my work, team, techstacks, culture, project, etc)
And some general questions.

Preparation Strategy:

Be consistent in Competitive Programming and DSA.
Hands on experience over Dp, trees and graphs especially.
Learn some CS fundamentals (OOPs, DBMS, SQL, OS, CN) also (it's easier anyway)
Add some projects in your resume and also have good knowledge on that (Don't just clone the git repository).

Competitive Programming(CP) is a must for clearing OTs.
CP + DSA is a must for clearing interviews.

Resources:

Problem solving on leetcode, Codeforces.
Contests on codeforces, codechef atcoder and leetcode.
OOP- Javatpoint.
DBMS- sanchit jain playlist on YouTube.
SQL - Hackerrank and YouTube Playlists.
OS - GFG and YouTube playlists.
CN - GFG and YouTube playlists.
Interview bit (would recommend for last 2-3 months DSA preparation)

Additional info for our viewers:

They don't expect us to know everything which is asked, so keep the only things you know completely in your resume.
Be confident and don't get stressed during interviews. Confidence really makes a big difference.
They especially focus on how you think, so think out loud also how you write the code and explain your logic so write clearly and don't make any typing mistakes.

There are times when things don't go according to you.
Not getting shortlisted for companies.
Not being able to clear online tests or interviews.
You may feel frustrated but failing is an important part in the journey.
Knowing what failure looks like will help us appreciate the success when we get it.
So be patient until you reach what you want and continue to work hard even after failures.
We just need to keep believing in ourselves for our own sake.

bottom of page