Ich habe mich auf Empfehlung eines Mitarbeiters beworben. Vorstellungsgespräch absolviert im Aug. 2021 bei Oracle (Chennai)
Vorstellungsgespräch
Breakout rooms in Zoom, individual one to one basis, first the HR will guide us with the process and then tech person will take the interview. Based on the results, I did not proceed to further rounds
Fragen im Vorstellungsgespräch [1]
Frage 1
What is alias? how is it different from actual name
Ich habe mich über einen Personalvermittler beworben. Der Vorgang dauerte 2 Monate. Vorstellungsgespräch absolviert im Nov. 2021 bei Oracle (Ciudad de Mexico)
Vorstellungsgespräch
Fueron 2 entrevistas con las reclutadoras me imagino que una junior y la otra senior, luego entrevista con el mánager del proyecto y 2 entrevistas técnicas finales con gente del proyecto (1 de la india y el otro de Filipinas), lamentablemente después de tanto tiempo invertido me hacen una propuesta salarial muchísimo menor al salario de la empresa en la cual laboro actualmente, lo cual me parece absurdo y una falta de respeto, ya que desde un inicio les hice saber mis pretensiones económicas, no se si pensaban que al final les iba a decir: "Si, está bien, me voy con ustedes por un 40% menos de lo que gano actualmente solamente por ser Oracle". Una rotunda decepción.
Fragen im Vorstellungsgespräch [1]
Frage 1
Preguntas diversas sobre mi experiencia y sobre desarrollo de queries en SQL, además de algunas preguntas de acertijos.
Ich habe mich über einen Personalvermittler beworben. Vorstellungsgespräch absolviert im März 2017 bei Oracle (Bengaluru)
Vorstellungsgespräch
Consisted of 3 Rounds
1.) Online Test
2.) Telephonic (2 Interviewer)
3.) F2F (2 Interviewer)
All interviews went very well, but after the 3rd round i did not hear back from HR.
no mails were answered about the status of interview
multiple hr's were involved, none responded.
So I called the HR who had scheduled my last interview and asked for an update and this was the answer i got "I dont recall you gave interview here !!!!!!! , let me check and get back to you !! )
Overall interview exp was good, but from the HR side they should at least have the professionalism to tell to a candidate if they are selected or not (at least not "I dont recall you gave interview here !!)
Fragen im Vorstellungsgespräch [1]
Frage 1
Round 1: Online Test (20 questions)
Basic PL/SQL Questions
Round 2: Telephonic (1 Hr)
tell me about urself
work u 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 index
what happens in backend when you create index
what will happen if you apply index on multiple column
plsql code tuning
what will you do if a query is working on your system and the same query is not working in clients system (Explain plan for both are same)
if your manager gives you work on friday which you have to complete it by monday and at the same time your parents are coming from your hometown what will you do?
PL/SQL Objects
types of SDLC model
tell about a situation when you have disagreement with your co-worker
how will you handle failure
questions on cursors, trigger (basic questions)
