Filter interviews by
I applied via campus placement at Dehradun Institute of Technology, Dehradun and was interviewed in Oct 2022. There were 5 interview rounds.
Duration : - 1 Hour
Platform : - Hackerrank
Topics : - REST API, SQL and DSA
To create a table in SQL, use the CREATE TABLE statement and define its elements.
Use CREATE TABLE statement followed by table name
Define columns with data types and constraints
Add primary key constraint to uniquely identify each row
Example: CREATE TABLE customers (id INT PRIMARY KEY, name VARCHAR(50), email VARCHAR(50))
JOIN operation is used to combine rows from two or more tables based on a related column between them.
JOIN can be used with different types like INNER, LEFT, RIGHT, FULL OUTER, etc.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
JOIN can be used to fetch data from multiple tables in a single query.
Bubble sort repeatedly swaps adjacent elements if they are in wrong order.
Bubble sort has a time complexity of O(n^2).
It is not efficient for large datasets.
Optimizations include adding a flag to check if any swaps were made in a pass and stopping if none were made.
Another optimization is to keep track of the last swapped index and only iterate up to that index in the next pass.
Balanced Parenthesis using Stack is a problem to check if the given expression has balanced parentheses or not.
Create an empty stack
Traverse the expression string and for each character, check if it is an opening parenthesis
If it is an opening parenthesis, push it onto the stack
If it is a closing parenthesis, check if the stack is empty or if the top element of the stack is the corresponding opening parenthesis
If the s...
Finding the Kth largest element in an array.
Sort the array in descending order and return the Kth element.
Use a max heap to find the Kth largest element.
Use quickselect algorithm to find the Kth largest element.
OFSS is a leading consulting firm with a strong track record. I am better than others because of my skills, experience, and dedication.
OFSS is a well-established and reputable consulting firm with a proven track record of success.
I have a strong skill set and relevant experience that make me a valuable asset to OFSS.
I am dedicated and committed to delivering high-quality results for clients.
I have a track record of exc...
I am fit for this role because of my strong analytical skills, ability to work in a team, and experience in consulting.
Strong analytical skills: I have a proven track record of analyzing complex problems and providing effective solutions.
Ability to work in a team: I excel in collaborating with diverse teams to achieve common goals.
Experience in consulting: I have previously worked as a consultant, gaining valuable expe...
I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.
It was easy only, simple queue and array questions
I applied via campus placement at BNM Institute of Technology, Bangalore and was interviewed in Sep 2024. There were 3 interview rounds.
HackerRank coding assessment.
A prime number is a number greater than 1 that has no positive divisors other than 1 and itself.
Check if the number is greater than 1.
Iterate from 2 to the square root of the number and check if it divides the number evenly.
If no divisor is found, the number is prime.
Swap two numbers without using two variables
Use arithmetic operations like addition and subtraction
Example: Swap 3 and 5 - 3 = 3 + 5, 5 = 8 - 5, 3 = 8 - 3
What people are saying about Oracle Financial Services Software
I applied via Company Website and was interviewed in Aug 2024. There were 3 interview rounds.
Basic Aptitude OOPs DBMS
SDLC life cycle is a process used by software development teams to design, develop, and test high-quality software.
SDLC stands for Software Development Life Cycle
It includes phases like planning, analysis, design, implementation, testing, and maintenance
Each phase has specific goals and deliverables to ensure the successful completion of the project
Examples of SDLC models include Waterfall, Agile, and DevOps
OOPs stands for Object-Oriented Programming concepts which include encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation: Bundling data and methods that operate on the data into a single unit (object).
Inheritance: Ability of a class to inherit properties and behavior from another class.
Polymorphism: Ability to present the same interface for different data types.
Abstraction: Hiding the complex implemen...
I applied via campus placement at Narsee Monjee Institute Of Management Studies (NMIMS) and was interviewed in Aug 2024. There were 2 interview rounds.
It was easy. It contained basic question around core CS topics. It also contained 1 coding questions around strings. Whereas some of my friends got a difficult question around DP.
Code to count the number of occurrences of each alphabet in a string using HashMap and triggers.
Create a HashMap to store the count of each alphabet in the string.
Iterate through the string and update the count in the HashMap.
Handle both uppercase and lowercase alphabets by converting them to a consistent case.
Use triggers to update the HashMap whenever a new alphabet is encountered.
Get interview-ready with Top Oracle Financial Services Software Interview Questions
I applied via Campus Placement and was interviewed in Sep 2024. There was 1 interview round.
Fibonacci sequence pseudocode
Start with two variables set to 0 and 1
Loop through desired number of times, adding previous two numbers to get next number
Store each number in an array
Palindrome pseudocode for array of strings
Iterate through each string in the array
For each string, compare the characters from start to end and end to start
If all characters match, it is a palindrome
Aptitude questions plus 1 coding question on graph.
OOP concepts refer to the principles of Object-Oriented Programming, including encapsulation, inheritance, and polymorphism.
Encapsulation: bundling data and methods that operate on the data into a single unit (object)
Inheritance: allows a class to inherit properties and behavior from another class
Polymorphism: the ability for objects of different classes to respond to the same method call in different ways
Use SQL query with ORDER BY and LIMIT to find 4th highest salary
Use ORDER BY clause to sort salaries in descending order
Use LIMIT 1 OFFSET 3 to get the 4th highest salary
Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 3
I applied via Campus Placement and was interviewed in Apr 2024. There were 3 interview rounds.
I applied via Campus Placement
DML commands are Data Manipulation Language commands used to manage data in a database.
DML commands include INSERT, UPDATE, DELETE, and SELECT.
INSERT is used to add new rows of data into a table.
UPDATE is used to modify existing data in a table.
DELETE is used to remove rows of data from a table.
SELECT is used to retrieve data from a database.
DDL commands are Data Definition Language commands used to define, modify, and delete database objects.
DDL stands for Data Definition Language
Common DDL commands include CREATE, ALTER, and DROP
CREATE is used to create new database objects like tables
ALTER is used to modify existing database objects
DROP is used to delete database objects
I applied via campus placement at Siddaganga Institute of Technology (SIT) and was interviewed before Jan 2024. There were 2 interview rounds.
There will be a DSA based question followed by a SQL query related question, along with MCQ's
The duration of Oracle Financial Services Software Associate Consultant interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 30 interviews
3 Interview rounds
based on 152 reviews
Rating in categories
Senior Consultant
1.3k
salaries
| ₹5.8 L/yr - ₹21 L/yr |
Staff Consultant
1.1k
salaries
| ₹4.5 L/yr - ₹13.6 L/yr |
Associate Consultant
1.1k
salaries
| ₹3.2 L/yr - ₹10 L/yr |
Principal Consultant
717
salaries
| ₹10 L/yr - ₹29 L/yr |
Application Developer
492
salaries
| ₹6 L/yr - ₹23 L/yr |
Oracle
TCS
Infosys
Wipro