Position: Technical Analyst at Oracle Financial Software Services (OFSS)
Date: Oct
Eligibility criteria:
- BE all branches/ B. Tech - specialization in CSE/ECE/EEE/IT
- CGPA 7 and above or Percentage 70 and above
- No Active Backlogs in any semester
The Recruitment process
The Recruitment consisted of 3 rounds:
- Aptitude test + Coding round
- Technical Interview
- Technical + HR Interview
Round 1: Aptitude test + Coding
- Platform: Hackerrank.
- Duration: 105 minutes.
- No. of questions: 10
- The 1st question was a coding question of medium level.
- The 2nd question was of API. A link to certain API was provided and we had to fetch the API and then do certain computations on the data.
- The 3rd question was of SQL where we had to write a SQL query on the question.
- The remaining 7 questions were technical MCQs which consisted of topics like OOPS, DBMS, C++, Java.
The level of the questions were moderate and were not available on the internet. I was able to solve the coding and API question along with the 7 MCQs. 22 students were shortlisted for the interviews.
The interviews were held 2 days after the first round.
Round 2: Technical Interview
- The round was completely online and was conducted on zoom.
- I was first asked to introduce myself.
- The interviewer then went through my resume and asked about one of my projects mentioned in it. I explained the project which was followed by questions about the project. The questions included why certain tech-stack was used, their benefits of them, and similar types.
- Next the interviewer asked me to explain another project and one by one asked about all the projects in the resume.
- The questions included what challenges I faced while making the projects, How did I manage conflicts among team members, etc.
- After this since I had mentioned a hackathon in my resume, the interviewer asked me about it and we discussed it like what had my team made, and how were the solutions of other teams.
- At last a coding question was asked which I could solve in my preferable languages, I choose python. The question was to print prime numbers in a given range.
- The further questions were on the code I had written, its time and space complexity and how could the code be made more efficient.
- This round lasted for around 50-55 mins and was mostly focused on my projects and other things I had mentioned in my resume.
Confidence is the key here, whichever question is asked answer it with confidence. Even if you don't know the answer to a particular question clarify it to the interviewer, and they will give hints to see if you can answer the question. Overall, the interview experience was positive. The interviewer was friendly and professional, and I felt like my answers were well-received.
After the first interview I was immediately called for the second interview.
Round 3: Technical + HR Interview
- Even this round was conducted on zoom.
- The interviewer asked me to introduced myself.
- The interviewer then asked me which DBMS softwares had I used, have I ever used Oracle Database. I made it clear to the interviewer that I have never used Oracle Database.
- The further questions were DBMS related like joins, difference between varies key, what are objects in sql etc.
- After that the interviewer asked me my preferable coding language and I replied python. The interviewe gave me a code to write : Given a string consisting of alphabets, numbers and special cases, split them and print the result
- I wrote the code and explained it, further the interviewer asked me some other techniques through which the problem can be solved and I gave 2-3 more ways to solve it and also explained the time and space complexity of all the approaches.
- When you write the code think loud about the approach you are using. The benefit of this is even if you are unable to solve the problem the interviewer will get know the logic of the code. In case you are thinking it wrong, the interviewer might give you hints to go in the proper directions.
- Next the interviewer started asking HR questions starting from my family background.
- The next question was What do I know about the role I am applying for. I explained the role and what kind of work will be giving to me. The answer to this question was giving in the preplacement talk of the company so do pay attention to the ppt as it might have answers to some of the questions.
- Further the interviewer asked if I had some questions, I asked about what skills should I gain which will help me after joining the company. I also the interviewer about his experience in oracle and lastly I asked him to give a feedback about me.
The results were announced on the same day, out of 22 students 7 were selected.
TIPS
- One of the things is Do pay attention to the preplacement talk where they tell about the company and the role, which will help in many questions like what do you know about the company or why this company etc.
- At the end of the interview do ask questions. It shows your enthusiasm for the job and also gives a good image of you.
- Many students have good coding skills but not often do they code with someone watching over them, which can make you nervous or even freeze on the spot. So for an interview do practice live coding.
- Prepare your resume well as the interviewer will always go through it and ask questions on it. Don't put anything in the resume you are not confident about.