I applied through a recruiter. The process took 2 months. I interviewed at Oracle (Bengaluru)
Interview
For Experienced professional there are direct technical round followed by Project Delivery Manger round and last HR round.
Technical round includes.
1. SQL
2. PL/SQL (Oracle)
3. Unix, Shell Scripting
4. Performance & Turnings
Personal Attitude:
1. Very good communication skills including excellent English
2. Ability to operate with limited support & supervision
3. Ability to priorities workloads and manage conflicting requests on time
4. Team Player
5. Professional and positive attitude
6. Go beyond stated objectives in taking initiatives to suggest process improvements
7. Ready to work in shifts, weekend at client location.
Interview questions [1]
Question 1
Technical round is bit difficult.
There is no telephonic round.
Directly F2F round and they asked me to write Oracle PL/SQL queries and discussed whether it will work or not.
If yes then explain in details.
standard process, multiple rounds, behavioral, technical, meeting with different members of the team, typical recruiter screening and then moving forward in the process, you should hear back within an appropriate amount of time, recruiter is good about giving you feedback
Interview questions [1]
Question 1
Tell me about a time you had to deal with a difficult client and how you handled it
3 rounds of interview. 2 technical and 1 managerial. Asked about the technical questions related to siebel crm order management journey workflows configuration and admin rcois apis product modelling. In-depth understanding was required
Two round one is technical interview where question related to project will be asked followed by manager round where few cases will asked and few questions about difficulty faced in current company
Interview questions [1]
Question 1
How will u write a code using different ways in Plsql
