Oracle | Senior Application Developer | June

I applied for a Senior Application Developer position at Oracle through Naukri.

Hackerrank OA

I completed a Hackerrank Online Assessment. The questions were similar to those found on Leetcode.

Round 1 (On-site)

My on-site interview was divided into two parts. The first part focused on Java Core, Data Structures and Algorithms (DSA), Math Puzzles, and previous work experience. The second part was entirely dedicated to Database Management and SQL queries. The questions included:

Java Core:

• How does immutability work in Java?
• How to create an immutable class?
• Can a class be static? If yes, then where can it be used?
• Difference between C++ and Java.
• How does string addition work in Java? (s1 = s1+s2)
• In which case does the finally block not execute?

DSA:

• Get the Longest Valid Parentheses sequence. Example: For the string "((())()()", the answer would be 8, which corresponds to "(())()()"

Math Puzzles:

• Last Palindrome Date (gfg puzzle)
• Three boxes have two balls inside. One with two green, one with two red and one with 1 red & 1 green. All the boxes are labelled as GG, RR and RG. What if I change all the labels to be incorrect, like GG labelled box will never have 2 green balls, it would either have 2 red balls or 1 green and 1 red ball. Now we have to take out one ball from any of the box of our choice and have to tell what are the right labels for all of the boxes.
• Door Puzzle (Classic puzzle on gfg)

DB and SQL:

• There were some questions on Hibernate on how it works?
• Queries on Cartesian Product, Full Join, left Join.
• Lazy Loading in Spring Boot
• @Transaction Management in Hibernate.
• Some questions on Indexing.
• Primary Key vs Unique Key
• Having vs Where clause
• Normalization upto 3NF
• Read and Write locking in DB.

Round 2 (Online)

After the on-site round, an online interview was scheduled where the interviewer asked me questions about my previous projects. This round lasted for 45 minutes. The interviewer seemed to be trying to determine if I had in-depth knowledge of my projects. The technical interviewer asked for my salary expectations instead of the recruiter. He was very interested in knowing my exact current compensation and was not willing to accept a range of numbers (I found this to be unusual).

Result

The interviewer from the second round mentioned that I would receive feedback within 3-4 days. However, it has been two weeks without any communication from the recruiter. I have reached out several times but have not received any response.