Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 5 giorni. Ho sostenuto un colloquio presso HCLTech (Sydney) nel mese di feb 2015
Colloquio
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.
Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto un giorno. Ho sostenuto un colloquio presso HCLTech (Chennai) nel mese di nov 2014
Colloquio
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.
Domande di colloquio [1]
Domanda 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.