Oracle got here to our school for on-campus hiring for batch 2023 during which they permit solely CSE, IT, and ECE department college students and they’re hiring for the position of affiliate advisor FTE.
There are 3 rounds for the choice course of and each spherical are elimination spherical.
- Written Spherical
- Technical Spherical
- HR Spherical
Spherical 1 Written Spherical (90 minutes): This spherical is performed on a hackerrank platform. there are 4 sections during which there are 2 coding questions, 1 REST API, 1 DBMS, and 5 MCQs (OS, Pseudocode, DBMS).
Issue: Straightforward to Medium
From 1200 college students solely 42 had been chosen for the interview spherical many of the college students had been eradicated primarily based on relaxation API questions. So, at the least attempt to remedy 2 Coding & SQL or 1 Coding, SQL & REST API.
Spherical 2 (Technical Spherical): Firstly, the Interviewer ask me to introduce myself after which about my initiatives which I discussed in my resume then she requested why you select this mission and from the place get the concept to do that mission I answered, after which she requested what are the algorithm’s you’ve got utilized in your initiatives. then she requested some OOPs ideas like defining Polymorphism, Inheritance after which she provides me 3 coding questions and asks me to share my display screen and code it. the primary query is to reverse a string utilizing totally different strategies, the second is a Binary search algorithm and the third one is from SQL to put in writing a question to fetch the wage of workers who’re working in a division the place the of workers is bigger than 3. I answered 2 coding questions however I’m not in a position to third one.
after this, she asks me in case you have any questions can ask I ask about her expertise in oracle. after this, she requested me to go away the assembly room and wait within the ready room. then a second interview spherical is performed.
Spherical 3 (HR Spherical): For some college students, it’s fully HR Spherical. However for me fully Technical spherical firstly interviewer ask me to introduce myself after which ask about my initiatives and what I be taught extra from these initiatives aside from my teachers and what are assets I used to be taught then he ask about API which I utilized in my mission. Then he some Fundamentals OOPs ideas, that’s all after which he asks in case you have any questions for me.
Observe: Be assured in each spherical of interviews and attempt to reply level to level for each query and be ready for all issues which you talked about in your resume, particularly initiatives.
Lastly, 18 college students had been chosen from our school.
Thank You. All The Finest.