Me postulé a través de una recomendación de un empleado. El proceso tomó 1 día. Acudí a una entrevista en HCLTech (Chennai) en nov 2014
Entrevista
A old colleague of mine helped me to arrange an interview for me. HR informed about the interview one day in advance. an experienced SQL guy took the interview and the entire discussion went smoothly.
The process went really smooth until the interview process got finished. But strangely, HR did not bothered to share the verdict details despite multiple followups.
Preguntas de entrevista [1]
Pregunta 1
01. How to analyse the Execution Tree of a Query Plan.
02. What are the ideal performance conditions to be taken care with logical reads & physical reads.
03. What are filtered indexes. What are advantages & disadvantages associated with it.
04. What is the prominence of cross apply while using Scalar values and Table valued functions.
05. What are the disadvantages associated with Common Table Expressions.
06. What do you know about the column stored indexes.
Me postulé a través de un reclutador. El proceso tomó 5 días. Acudí a una entrevista en HCLTech (Sídney) en feb 2015
Entrevista
My interview was fine, I am extremely experienced and they offered me the position the next day.
It was the onboarding process which blew my mind, and I turned down the job as a result.
This company apparently regards employees as chattel. They demanded copies of previous payslips, a wad of personal financial information, the names of my parents. To cap it off, they wanted me to sign a privacy waiver giving them FULL access to all my information at any previous job, including payroll information (!).
This was on top of the full police check, and wanting to know my student ID from university (!)
I have no idea what planet this company comes from, but they have a serious attitude problem towards employees.
Avoid, avoid, avoid.