Ho presentato la mia candidatura online. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso CGI nel mese di lug 2023
Colloquio
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.
Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto un giorno. Ho sostenuto un colloquio presso CGI (Chennai) nel mese di ago 2016
Colloquio
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 )
Domande di colloquio [1]
Domanda 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
