CGI Data Engineer Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 34 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at CGI.
CGI
Data Engineer
Senior Easy Negative experience No offer 2 rounds
Interview process
Technical screen Recruiter call Phone screen
Interview formats
Technical Behavioral
The interview was initially planned to be fully in-person and completed on the same day. However, after the first round, they informed me that the L2 interviewer was unavailable, so the remaining rounds were moved to a virtual format. Two days later, I had the L2 round, which was somewhat of a review. The interviewer asked technical and HR questions. They repeatedly inquired about my current and expected salary, and if I was open to negotiation. I confirmed I was. I suspect there was a budget issue, and felt it was a waste of my time as they should have clarified budget constraints beforehand. It was a very poor experience.
Confirmed questions5 questions
- Can you describe your projects?
- Do you have answers to some basic technical questions?
- Could you tell us about your current compensation?
CGI
Data Engineer
Entry Average Positive experience Decline offer 2 rounds
Interview process
Recruiter call Technical screen
Interview formats
Technical Coding Behavioral
The interview was focused on scenario-based questions. They asked about Databricks and ADLS concepts with delta implementation, and I had to go deep into Azure Data Factory and IR. They also checked my understanding of Spark, and had me do some SQL and PySpark coding with complex logic.
Confirmed questions6 questions
- What motivates you to join us?
- Can you elaborate on your experience with Databricks and ADLS, specifically concerning delta implementation?
- Could you detail your knowledge of Azure Data Factory and Integration Runtimes?
CGI
Data Engineer
Mid Difficult Positive experience No offer 5 rounds
Interview process
Recruiter call Technical screen Technical screen Onsite Offer
Interview formats
Behavioral Technical Coding
At GCI Rabat, the interview process for a Data Engineer position usually starts with a CV pre-selection by HR. Then, a quick call to check your motivation, general skills, and salary expectations. After that, there's a technical test covering SQL, Python, ETL, and Big Data concepts. If you pass the test, a senior engineer will interview you to assess your knowledge of data pipelines, Spark, data models, and problem-solving logic. Finally, a manager will have a chat to make sure you're a good fit for the role and the team. If everything checks out, they'll send a job offer, and then onboarding begins.
Confirmed questions1 question
- Can you walk me through a Data project you worked on and what your exact role was?
CGI Data Engineer Interview Questions
Quoted word for word from CGI interview reports.
“What's the difference between a connected lookup and an unconnected lookup?”
Read reports →“What is the difference between Spark and Hadoop MapReduce in terms of performance and execution model?”
Read reports →“Can you write an SQL query to get the top 5 best-selling products per month?”
Read reports →“Can you explain basic pyspark syntax and how to convert it to sql?”
Read reports →“Could you explain what SCD Type 2 is?”
Read report →“Can you provide an example of a left join using SQL?”
Read report →“Can you elaborate on the differences between bucketing and partitioning?”
Read report →“How would you find the 3rd highest salary using both SQL and PySpark? What if there are fewer than 3 salaries?”
Read report →“Could you describe how memory management is handled in Spark?”
Read report →Formats, difficulty and experience
Across all 34 CGI interview reports.