I applied through university. The process took 2 weeks. I interviewed at HCLTech (Dehradun) in Jan 2025
Interview
1st round: oa (apti + coding)
2nd round: gd(easy only check your communication)
3rd round: tech interview ( if qualified this then 80% of your hiring chance
increase)
4th round: hr + tech
Interview questions [1]
Question 1
Give a condition related to database and u need to solve it by using pl/sql
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.