Oracle Member Technical Staff Interview Questions, Process, and Tips

Round: Test
Tips: You should be familiar with OOP concepts and a few concepts like binary tree. Also aptitude and quant questions (like in CAT). They will test your coding skills thoroughly during the test (only in the prog. language that you opted) and will question your logic and your approach to the problem. Be thorough with your coding basics.

Round: Technical Interview
Tips: The tech rounds focused mostly on coding. You can choose any programming language that you are comfortable with. They are not insistent that you know Java. I chose C++. The interviewers mainly look at how you approach the questions (the way you solve the question - if its the most efficient/fastest solution to the problem). They will also ask quite a lot of puzzles (the ones you can prepare from Heard on the street, 400 puzzles etc.) and a few CAT quant qns.

Round: HR Interview
Experience: HR round is very easy
Tips: basic qns that you will prepare for any company. Be sure to attend the PPT; the HR will surely ask you a few qns from it. Also know a bit about the company and the profile you are sitting for.

General Tips: The test is the only criteria for getting shortlisted to the interview round. There are certain Oracle profiles that are only open for CS and one which has a CG cutoff of 8.5. But for the App Dev profile there was no CG cutoff. your performance in the test is most important,because they generally do not entertain walkins during interview. Resume is not that important. Only HR team will have a look at it. If you have any coding experience (from any projects) or Java certification then its an added bonus. But its not mandatory.
1st year- concentrate on CGPA
2nd year - find out what you want(core or noncore). Do internships in starts ups or finance or consult companies if aiming for non-core. PORs are important
3rd year- internships.
4th year- start placement preparation very early. 
Work well on your project if you want to go for core.
College Name: IIT MADRAS