Oracle | Senior Application Engineer | Hyderabad | April 2025 [Offer]
- Location
- Hyderabad
- Posted
- 11 Jun 2025
Summary
I interviewed for the Senior Application Engineer role at Oracle, Hyderabad, in April 2025, and received an offer after four rounds, which I ultimately declined for a better opportunity.
How it went
Round 1 (In-person)
- Given two arrays, sort without extra space
A = [10, 2, 20, -1]
B = [1, 5, 25]
Output:
A = [-1, 1, 2, 5]
B = [10, 20, 25] - https://leetcode.com/problems/regular-expression-matching/description/
- Implement Singleton class
- Follow up: How do you prevent creating clones of the singleton class object?
Round 2 (In-person)
- Given an array, reorder such that even numbers are pushed to the left side of the array and odd numbers to the right
- Given two tables - employee and department. Wite SQL query to find the name of employee with max salary
- Follow-up 1: Wite SQL query to find the name of employee with second max salary (covering corner cases like multiple employees have max and second max salary)
- Follow-up 2: Write SQL query to print the max salary of each department
Round 3 (In-person with the Hiring Manager)
- Write code to add given number of days to a given date in string format without using date functions. Should Handle leap year case as well
Round 4 (Online meeting with the Vice President)
- Given the table employee_salary(eid, salary_credited, month)
- Write SQL query to find employees with salary greater than 10,00,000
- Write SQL query to find employees with total salary received so far greater than 50,00,000
- Difference between where and having clause
- Difference between mysql and postgreSQL
- Design movie recommendation app. Write some code for user registration module
- Where do you see yourself in 5 years?
- Why are you leaving your current organization?
Verdict: Selected
However, I declined the offer as I got a better offer
Compensation details: https://leetcode.com/discuss/post/6833191/oracle-senior-application-engineer-hyder-wqdh/
Questions asked (12)
- 01
Sort Two Arrays Without Extra Space
Data Structures & Algorithms
Given two arrays, sort without extra space
A = [10, 2, 20, -1]
B = [1, 5, 25]
Output:
A = [-1, 1, 2, 5]
B = [10, 20, 25] - 02
- 03
Implement Singleton Class with Clone Prevention
Data Structures & Algorithms
Implement Singleton class
Follow up: How do you prevent creating clones of the singleton class object?
- 04
Reorder Array: Even Left, Odd Right
Data Structures & Algorithms
Given an array, reorder such that even numbers are pushed to the left side of the array and odd numbers to the right
- 05
SQL Query: Max Salary Employee
Other
Given two tables - employee and department. Write SQL query to find the name of employee with max salary
Follow-up 1: Wite SQL query to find the name of employee with second max salary (covering corner cases like multiple employees have max and second max salary)
Follow-up 2: Write SQL query to print the max salary of each department
- 06
Add Days to Date String Without Date Functions
Data Structures & Algorithms
Write code to add given number of days to a given date in string format without using date functions. Should Handle leap year case as well
- 07
SQL Queries on Employee Salary Table
Other
Given the table employee_salary(eid, salary_credited, month)
Write SQL query to find employees with salary greater than 10,00,000
Write SQL query to find employees with total salary received so far greater than 50,00,000
- 08
Difference between WHERE and HAVING clause
Other
Difference between where and having clause
- 09
Difference between MySQL and PostgreSQL
Other
Difference between mysql and postgreSQL
- 10
Design Movie Recommendation App with User Registration
System Design
Design movie recommendation app. Write some code for user registration module
- 11
Where do you see yourself in 5 years?
Behavioral
Where do you see yourself in 5 years?
- 12
Why are you leaving your current organization?
Behavioral
Why are you leaving your current organization?