Oracle Interview Expertise for Affiliate Guide (On-Campus)

Oracle got here to our faculty for on-campus hiring for batch 2023 through which they permit solely CSE, IT, and ECE department college students and they’re hiring for the function of affiliate marketing consultant 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 carried out on a hackerrank platform. there are 4 sections through which there are 2 coding questions, 1 REST API, 1 DBMS, and 5 MCQs (OS, Pseudocode, DBMS).

Problem: Straightforward to Medium 

From 1200 college students solely 42 had been chosen for the interview spherical a lot of the college students had been eradicated based mostly on relaxation API questions. So, not less than 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 venture and from the place get the concept to do that venture 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 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 write down a question to fetch the wage of workers who’re working in a division the place the of workers is larger than 3. I answered 2 coding questions however I’m not in a position to third one.

after this, she asks me when you’ve got any questions can ask I ask about her expertise in oracle. after this, she requested me to depart the assembly room and wait within the ready room. then a second interview spherical is carried out.

Spherical 3 (HR Spherical): For some college students, it’s utterly HR Spherical. However for me utterly Technical spherical firstly interviewer ask me to introduce myself after which ask about my initiatives and what I study extra from these initiatives other than my teachers and what are sources I used to study then he ask about API which I utilized in my venture. Then he some Fundamentals OOPs ideas, that’s all after which he asks when you’ve got any questions for me.

Notice: 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 faculty.

Thank You. All The Greatest.