I applied online. The process took 1 week. I interviewed at CGI in July 2023
Interview
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.
I applied through a recruiter. The process took 1 day. I interviewed at CGI (Chennai) in Aug 2016
Interview
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 )
Interview questions [1]
Question 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