I applied through a recruiter. The process took 1 day. I interviewed at HCLTech (Sholinganallur) in Feb 2019
Interview
I attended Oracle PL/SQL scheduled interview (but it was like walk -in) at HCL shols campus. I arrived the campus at 10:30 am and gave the resume to corresponding HR. For 20+ seats, they interviewed more than 150+ persons. There was totally 4 panels ( 2 for 1st round and 2 for 2nd round). I was waiting for my turn. I am not sure on what basis they picked up the resume for interview as i gave my resume on morning. Meanwhile they interviewed so many and took more than 30 people. Finally they called me at 5: 30 PM. I was totally frustrated and for namesake they questioned us( some 15 people) and ended by 5.45 PM. Just for 15 min interview i was staying for the whole day.
Will NEVER NEVER attend any interview at HCL.
Interview questions [1]
Question 1
sql loader. How to truncate partition. error in extenal table. some scenario based external table and partition.
and some query
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.