Oracle Interview Experience | Senior Application Developer | Selected

Oracle Interview Experience - Senior Application Developer
The HR found the profile from Naukri. Received a call from HR for the onsite interviews.

Round 1 (onsite) -

1) Given a string, write a function to encode and decode it. The encode string should not be easily decoded by naked eyes.
2) Binary Tree Maximum Path Sum

Round 2 (onsite) -

1) Given a string of binary bits, find all the substrings which are repeating consecutively and the no of times its repeated. The repeating string length should be greater than 2.
eg:-
Given String - "010110111"
o/p -
101 -> 2
011 -> 2

2) Maximum Subarray

Round 3 (onsite) -

It more of a managerial round, the interviewer asked few questions related to my current work. He later gave me one question.
Given a date and the no of days, what will be the date after adding the given no of days. The days can be very large as well. He gave me days as 1000.
eg - 01/03/2025 , days = 20
o/p - 21/03/2025

Round 4 (virtual) -

This was a techno-managerial round.
He asked me questions related to my resume and few behavorial questions. He also asked 1 easy DSA question and 1 sql query.
DSA question -
Given the list of numbers, find the all possible combinations from given input which can have a target sum as 220.

SQL query -
Given a table:
(emp_id, date of salary, salary amount)
Find the employee who has until now received a total amount > 1000000

After couple of days received a call from HR and she confirmed that I am selected. Waiting for the offer letter :)