Oracle Financial Services Solutions Interview Experience (On-Campus)

OFSS visited our campus for the role of Associate Consultant.There were 4 rounds in all.Round 1(Online Test): This round had an Online test that consisted of 5 sections.First section contained quant, logical reasoning, programming fundamentals(data structures, trees mostly), another section consisted of OS, DBMS, CN, Computer Architecture(COA) ques which also had a few numerical which were of medium-high level. Next Section consisted of English, Comprehension, and the last section we had to write essays on given topics.The difficulty of questions were medium although quant and logical reasoning were the toughest of all. The test was for 2 hrs and one can take a break after completing one section.Round 2(Technical Interview 1 ): This round was Technical Interview 1 round where the interviewer asked me to tell me about myself and asked some ques related to my project.He then dug deep into my project and gave me different use cases.Further, he started asking me ques about what I had mentioned in my resume. OOPS concept, CyberSecurity, and since I had done my project using NoSql database(MongoDB), he asked me to differentiate between SQL and NoSQL databases, and why I used it.He then asked me to open notepad and write following codes:Show an example of inheritance in java.Reverse a string(psuedo code).Print your name in alphabetical order.How to use bootstrap to make your web-app mobile responsive?Round 3(Technical Interview 2): This round was Technical Interview 2 round in which the interviewer asked me about the current technological advancements and the ones which I had mentioned in my resume. He further asked me about the difference between NoSQL and SQL databases.He then threw some sample use cases to me likeWhy Netflix suggesting a movie to be different to what it suggests to you?Which companies SQL and NoSQL databases and why?What are the threats to the databases and how can one prevent and tackle a threat to the database?He was very much impressed by the answers that he got, and focussed on my confidence and adaptabality.Round 4(HR Interview): I was selected for the HR Interview and it had the following ques:Experience so far.If you have a friend and you don’t like him/her at all but is in your team how will you manage?Strengths and Weakness.Your lowest point and how did you overcome it.General practical use cases(answer what you feel is correct approach).Be confident, they do not expect that you know everything, they look at your approach and how do you answer a particular problem.Thank You geeksforgeeks !!Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready. To complete your preparation from learning a language to DS Algo and many more, please refer Complete Interview Preparation Course. In case you are prepared, test your skills using TCS, Wipro, Amazon. Google ,  E-Litmus and Microsoft Test Serieses.