Oracle Sneior Software Engineer interview questions

I was contacted by a manager after having submitted my resume for a specific position. I spoke with him about the position and about his team. A few days later I went in for an interview. The team members seemed to be very sharp and all seemed to get along very well. I was asked specific questions in a number of one-on-one interviews about PL/SQL syntax, using PL/SQL collections, using JDBC in a Java program to iterate through a result set, various considerations when tuning a SQL database, how indexes affect execution plans of SQL, why indexing is important and how B+-tree indexes work.

I was already an Oracle employee in Brazil and applied for jobs in different product development teams at Oracle HQ through internal iRecruitment (which is also available externally at http://irecruitment.oracle.com). Got contacted for some of those applications but my case required L1 visa sponsorship so not every 1st contact was fruitful. But for this particular one, there was green light for international transfers and I went through the interview phase which basically consisted of 4 formal phone interviews, with 4 different interviewers: 2 other software engineers, 1 product manager, and 1 director. Only the 2 engineers made very technical interviews, basically focused on Java and logic, that lasted for about 1 hour each and had a medium-high difficulty level. The other 2 interviews were more about to know my professional experience and objectives and also to let me know more about the job. After that, I got the positive feedback in about a week and then, in my case, the whole approval process for my job offer took more than a month and then, finally, I could start the real transfer process, which took a couple more months and now I'm here and quite happy so far.