CGI Group Interview Questions, Process, and Tips

Q1. SQL Order of execution
Ans. 
SQL statements are executed in a specific order to ensure accurate results.
• SQL statements are executed in the following order: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

• The FROM clause specifies the tables involved in the query.

• The WHERE clause filters the rows based on specified conditions.

• The GROUP BY clause groups the rows based on specified columns.

• The HAVING clause filters the groups based on specified condi...read more
Answered by AI
Add your answer

Q1. How to identify the root-cause if an executor is taking longer time compared to others
Ans. 
Identifying root cause of slow executor compared to others
• Check resource utilization of the slow executor (CPU, memory, disk)

• Look for any specific tasks or stages that are taking longer on the slow executor

• Check for network latency or communication issues affecting the slow executor

• Monitor garbage collection and JVM metrics for potential bottlenecks

• Consider data skew or unbalanced data distribution causing slow perform
Answered by AI
Add your answer

Basis coding question

DSA coding question manily leetcode qustions

Q1. Salary discussion and why this company
Add your answer
Q2. What was previous organization role
Ans. 
I was a Software Developer at XYZ Company
• Developed and maintained software applications

• Collaborated with team members to design and implement new features

• Participated in code reviews and testing processes
Answered by AI
Add your answer

Q1. Advance networking BGP dmvpn flexvpn firewall
Add your answer

Q1. Informtica with date functions
Ans. 
Informatica is a popular ETL tool used for data integration and transformation. It has built-in functions to handle date operations.
• Informatica is a powerful ETL tool used for extracting, transforming, and loading data.

• It provides a variety of built-in functions for handling date operations such as date calculations, formatting, and conversions.

• Examples of date functions in Informatica include TO_DATE, TO_CHAR, ADD_TO_
Answered by AI
Add your answer

Q1. Basic React question
Add your answer
Q2. Few Javascript questions
Add your answer

Moderate difficulty level of the test

GD was conducted in a managed way

Moderate level of difficulty

Q1. Moderate difficulty of questions asked
Add your answer

Q1. Easy round with basics questions about yourself
Add your answer