CGI interview experience Real time questions & tips from candidates to crack your interview
Data Engineer
CGI
2 rounds | 2 Coding
problems
Selected Interview preparation journey
Application story
I posted for requesting referral for Big Data roles on fishbowl and one of the person from CGI was kind enough to help me out with it
Preparation
Duration: 2 months
Topics: Data structure and algorithm ,DBMS ,OOPS and Web Development
Tip 1 : Try to solve as much SQL questions.
Tip 2 : Learn how spark works and its architecture
Application process
Where: Other
Eligibility: No gap more than 1 year, A bachelor degree
Tip 1: Have an understanding of your current project
Tip 2: Try to drive the interview around your strong concepts
Interview rounds
01
Round
Easy
Face to Face
Duration30 minutes
Interview date8 Jun 2023
Coding problem1
Web problem/projects1
1. DBMS Questions
Given an employee table find the name of the employee who has the nth highest salary. (Practice)
2. Create Match List for IPL teams
Given a table with names of team for IPL create a table to depict all the matches for ex. CSK vs MI, MI vs SRH
02
Round
Easy
Face to Face
Duration45 mind
Interview date16 Jun 2023
Coding problem1
Web problem/projects1
1. Theory Questions
Difference between Partitioning and Bucketing. (Learn)
2. System Design
How would you create a data pipeline and what all components would you use to create a job which triggers on file upload on s3 and sends an email notification after completion
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
How do you remove whitespace from the start of a string?
Choose another skill to practice
Similar interview experiences
Software Testing Engineer
3 rounds | 16 problems
Interviewed by CGI
Selected 
1416 views
0 comments
0 upvotes
Senior Software Engineer
3 rounds | 16 problems
Interviewed by CGI
Selected 2718 views
0 comments
0 upvotes
Senior Test Engineer
3 rounds | 16 problems
Interviewed by CGI
Selected 1141 views
0 comments
0 upvotes
Senior Software Engineer
3 rounds | 17 problems
Interviewed by CGI
Selected 2288 views
0 comments
0 upvotes