Me postulé en línea. El proceso tomó 1 semana. Acudí a una entrevista en CGI en jul 2023
Entrevista
Video conference for first technical round followed by HR / Management round. After shortlisting a candidate, they schedule the interview and share video conf link. As per my experience the interviewer didn't seem interested in exploring a candidate, he conducted the interview just like a school/college viva.
Me postulé a través de un reclutador. El proceso tomó 1 día. Acudí a una entrevista en CGI (Chennai) en ago 2016
Entrevista
There are 3 Rounds of Discussion Takes place .
1. Technical - SQL Skills
2. Technical - About your Project and Most of the Questions comes from your Resume
3. Manager Round - About your CTC and Expected CTC ..etc
4. HR round For Package Discussion - Via Telephonic ( Yet to Happen )
Preguntas de entrevista [1]
Pregunta 1
Q. Most questions about what could be the result from two table data presented before us .
Minus , Left outer Join ( Duplicate Twist ) , Union vs Union ALL , ROW_NUMBER () ,Rank () , DENSE_RANK() ..etc ,
Q.Which Architecture do you use in your Project ( STAR vs SnowFlake - Why SF is not Good ?)
Q. What is Surrogate Key
Q. How did you validate Data from Stage to EDW - Example
Q. What is your Validation Strategy on Large data set
Q. SCD Type - Example pls
