Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto un giorno. Ho sostenuto un colloquio presso HCLTech (Sholinganallur) nel mese di feb 2019
Colloquio
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.
Domande di colloquio [1]
Domanda 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.
Domande di colloquio [1]
Domanda 1
What is trigger, how many values a function returns.
Ho sostenuto un colloquio presso HCLTech (Chennai)
Colloquio
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?
Ho sostenuto un colloquio presso HCLTech (Bengaluru)
Colloquio
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.