I applied online. I interviewed at HCLTech (Madurai)
Interview
Applied to HCL Tech for PL/SQL developer position through naukri. No passed out year criteria was mentioned. Once after geting inside the campus I've been informed that this position is for recent batches.
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.
Interview questions [1]
Question 1
What is trigger, how many values a function returns.
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?
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.