1st round - Online test (Aptitude,Pseudocode,Puzzles)
2nd - Group Discussion
3rd - Technical round
What is rank and dense rank?
What is pivot?
Write query to show the second largest salary?
What are window functions?
I had 2 online interviews in which after describing my experience I had technical questions regarding SQL and PL/SQL. Camera was on on both sides. The whole recruiting process lasted 1 month. Too much waiting time but it was worth it.
Perguntas de entrevista [1]
Pergunta 1
What is trigger, how many values a function returns.
Fiz uma entrevista na empresa HCLTech (Bengaluru).
Entrevista
Easy process and be calm to explore yourself. Then whatever question asked for you just tell relevant answer for that. Finally good communication is needed, so expose very fluent English for that interview process.