The interview process consisted of three rounds:

• Online Test
• Telephonic Interview (2 interviewers)
• Face-to-face Interview (2 interviewers)

All interviews went very well. However, after the third round, I did not hear back from HR. My emails regarding the interview status went unanswered, and multiple HR representatives were involved, none of whom responded.

I eventually called the HR representative who had scheduled my last interview to ask for an update. Their response was, "I don't recall you gave an interview here! Let me check and get back to you."

Overall, the interview experience was good. However, the HR department should demonstrate more professionalism and inform candidates of their status, rather than responding with, "I don't recall you gave an interview here."

Round 1: Online Test (20 questions) Basic PL/SQL Questions

Round 2: Telephonic (1 Hr)

• Tell me about yourself
• Work you have done till now
• Cursors
• Triggers
• Indexes
• Pragma

Round 3: F2F (Technical and Managerial) (1 Hr 45 Mins) Interviewers were friendly.

• Why do we use an index?
• What happens in the backend when you create an index?
• What will happen if you apply an index on multiple columns?
• PL/SQL code tuning
• What will you do if a query is working on your system, and the same query is not working on the client's system (explain plan for both are the same)?
• If your manager gives you work on Friday which you have to complete by Monday, and at the same time, your parents are coming from your hometown, what will you do?
• PL/SQL Objects
• Types of SDLC models
• Tell about a situation when you had a disagreement with your co-worker.
• How will you handle failure?
• Questions on cursors, triggers (basic questions)