I applied through college or university. I interviewed at HCL in Jan 2025
Interview
It was pool drive, nearly 3 to 4 colleges came and before shortlisting for interview we had a hacker rank test, followed by group discussion. After that we had 2 technical rounds of interviews on was of 30 minutes and other one was comparatively less time (approximately 10-15 minutes)
Interview questions [1]
Question 1
The questions were on the topics:
joints, view, materialistic View, how do apply union all on two tables(syntax), constrains, DDL, DML commands, indexing, trigger