Oracle Analyst Interview Questions and Answers

Round: Test
Experience: The test was of easy to moderate difficulty level. There was no negative marking hence choosing the questions to maximize score was the best way. It was a speed based test and a few questions in each section were put to break your speed in the form of calculation based questions or slightly difficult ones. Decent preparation for CAT etc is more than sufficient. Verbal was very easy, quants and reasoning were moderate. I always thought that quants was my weakness, but this test was easier than expected.
Tips: 1) Choose questions in each section wisely because there is no negative marking. Leave the ones you think are time consuming and fill it at the last.
2) Make sure you allot equal time to all sections or if you have one section as your strength do it first. There can be chances of sectional cut off, I am not sure
3) Maximize your score by keeping your speed maintained
4) A decent preparation for CAT is more than enough. Verbal has 1 or 2 RCs which are very easy.
Duration: 60 minutes
Total Questions: 60

Round: Technical Interview
Experience: The first round was pretty easy I thought because the interviewer was pretty relaxed and was just trying to get to know me. She asked questions about every point in my resume. I could feel that you are the one who drive your interview the way you want to from the first question.
Tips: 1) PLEASE be HONEST with your resume. They will ask you about each and every point. They asked about EVERY internship I did, every conference, everything. So be honest and well versed with what you mention in your resume.

2) Do not get laid back if the interviewer is a little relaxed. The ones who did in my time, did not get shortlisted for next round.

3) Be aware of your answers, you can drive your own interview.

Round: Puzzle Interview
Experience: Ans 1 - Case studies on sports leagues in India - Indian Badminton League, Hockey India League and Standard Chartered Mumbai Marathon
Ans 2 - Guessestimate question. Gave a reason for answer, it was not even close for the first time because I could not estimate population of Marine Drive (venue of marathon) near to real value but my algorithm was correct, hence he moved to next question.
Ans 4 - I will not disappont the efforts put in me, I am sincere and passionate about my work.
Ans 5 - No I do not mean that.
Ans 6 - I would act as an asset for the company who would help in building other assets by helping and working together with my peers in Fractal

Tips: 1) Make sure you keep explaining your method at each step, this way even if values are wrong, they are interested in method.

2) Dont panic, you can ask them to give you 2 3 minutes to think

3) Be honest. Have presence of mind, understand when he is not happy with your response

4) The interviewer was continuously roaming around the room trying to distract me. So be focussed.

Round: HR Interview
Experience: Ans 1 - Do you intend to ask about their rights from society or freedom from home?
Ans 2 - According to me the societal restrictions are forced, but the family restrictions might be justified because I asked my father and he gave evidences from Vedas which was logical.
Ans 3 - Told her the facts
Ans 4 - Travelling, meeting new people and reading books
Ans 5 - both fiction and non fiction. Named a few titles and authors
Ans 6 - My Experiments with Truth - MK Gandhi, Like most of my peers, I made a negative conclusion about MK Gandhi.
Ans 7 - That truth must always prevail but it doesnt define truth.
Ans 8 - Ma'am, what we are taught and what we grow up with is our paradigm. Truth is what we accept after observing everything. For example I was curious why we should visit the temple and I researched about it, read a few texts and forme dmy opinion this i smy truth so it can be subjective.
Ans 9 - Gave the reason
Ans 10 - I think Fractal works on the same principle as I do that there should be a balance between everything in life. My seniors at fractal have talked extremely well about the work life balance and as you would see my profile is also a balance between sports, extra curriculars and academics

Tips: 1) I was confident and aware about what I was saying.
2) I gave openings for her to ask the next question like define truth, why temples etc.
3) Be honest and tell them waht you think. This round is just to check if you fit in their work culture or not.

General Tips: 2 things are very important for fractal -
1 - stay calm
2 - be honest. they can see through it.

Read about Fractal properly, use it in your answers. HR round will have one question - Do ask at least one question
Skill Tips: Make sure your resume is one page long only and is COMPLETELY TRUE.
Skills: Ability To Cope Up With Stress, Guesstimate Skills, Ability To Deal Diplomatically, Ability To Convince, Hone
College Name: NIT Nagpur
Motivation: It was an analyst job and the company has a very good work life culture.
Funny Moments: When in 1st round I was asked any difficult situation you handled, I told about my visit to Japan and how I did a presentation there in Class 10, my interviewer then began to tell me about her visit to Japan and how good Japanese people are
Also in last round, we had a healthy long discussion about what is truth, why women are denied a few things etc/ All HR interviews were 10 minutes long with normal questions like hobbies and general stuff but mine went on for 40 minutes and I did not even mind it.