Oracle Financial Software Services Interview experience | Associate Consultant | Full Time

College: Jaypee Institute of Information Technology, Noida sector-62

Role: Associate Consultant, On-Campus Recruitment, Batch 2025

Number of rounds: 3

• 1st round: Online assessment
• 2nd round: Technical interview
• 3rd round: Semi-technical/HR interview

1st round: Online assessment

Duration: 2hr (120mins)

Topics from which questions were asked:

• 1 Coding question (mine was based on String Subsequence)
• Aptitude (profit-loss, series, mathematics, data interpretation, comprehension etc.)
• OS (operating systems)
• Computer Networks
• Oracle's Software
• DBMS and SQL

2st round: Technical Interview

Duration: 25-30mins

Questions were basically asked from my resume, about my projects and follow up questions on that.

Questions that were asked:

• Introduce yourself.
• Questions about internship experience.
• To write Fibonacci code.
• Why i chose to learn MySQL only among all?
• Query was given to describe how to store in a MySQL database and some follow-up questions on that. How would i go about it in a NoSQL database, per say, MongoDB.
• Difference in XML and JSON object. And why we needed JSON?
• Financial questions: How does the process of loan works?
• How does a credit card work? What happens if a person doesn't pay the amount on time?

3st round: Semi-technical/HR interview

Duration: 15-20mins

Questions were being asked from my resume, from core subjects that i mentioned, about projects that i'd mentioned and hobbies.

Questions that were asked:

• Asked about a project that i had built (asked the functionality and its impact)
• My internship experience and what exactly my role was( i told how i worked on jira with my tech lead on parts of 2 projects and tasks were assigned as user stories on jira in sprints that were of 2weeks each)
• What is Jira?
• Draw ER diagram of a use case (student learning subjects) and was asked to explain it.
• Question on a core subject that i mentioned(statistics and probability): What is entropy? couldn't answer it.
• Do you have any idea about data warehouses? couldn't answer it.
• What is waterfall model? Give real life example of it.
• What is BlackBox testing?
• Difference between verification and validation?
• Where do you see yourself in 5 years?
• What are your hobbies?
• Do you know about Oracle's Flexcube? I had no idea.
• Do you have any questions for me? In this i asked more about the role and what we would be actually doing?

Pro-tip:

Just be confident while giving the answers.

Prepare your core subjects and projects well.

What the role is actually about?

It is actually a Project manager type role where you would be working with the product team as well as the client's.

There is a product team and a consulting team. The product team enhances or creates a product and we have to pitch it or basically interact with the client about the product that our team has built. Then, we have to give suggestions to the product team on the basis of the client interaction about the product modifications that are required.

Verdict: Selected.