Candidatei-me online. O processo levou 1 semana. Fui entrevistado pela CGI em jul. de 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.
Candidatei-me por meio de recrutador(a). O processo levou 1 dia. Fui entrevistado pela CGI (Chennai) em ago. de 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 )
Perguntas de entrevista [1]
Pergunta 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
