PL/SQL Developer applicants have rated the interview process at HCLTech with 2.5 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 50% positive. To compare, the company-average is 60.6% positive. This is according to Glassdoor user ratings.
Candidates applying for PL/SQL Developer roles take an average of 1 day to get hired, when considering 2 user submitted interviews for this role. To compare, the hiring process at HCLTech overall takes an average of 17 days.
Common stages of the interview process at HCLTech as a PL/SQL Developer according to 2 Glassdoor interviews include:
Background check: 20%
One on one interview: 20%
Group panel interview: 20%
Skills test: 20%
Presentation: 20%
Here are the most commonly searched roles for interview reports -
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.
Interview questions [1]
Question 1
What is trigger, how many values a function returns.
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.