CGI Interview Questions

CGI Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(41)
Data Structures & Algorithms
(37)
SQL
(21)
Probability
(17)
Statistics
(13)

CGI Interview Questions

Practice for the CGI interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Easy

Given a table of transactions, write a query to find the average quantity of each product purchased per transaction each year.

The output should include the year, product_id, and average quantity of the product purchased per transaction that year. The output table should be sorted by year and product_id in ascending order. The value for avg_quantity should be rounded to two decimal places.

Example:

Input: transactions table

Columns Type
id INTEGER
user_id INTEGER
created_at DATETIME
product_id INTEGER
quantity INTEGER

Output:

Columns Type
year INTEGER
product_id INTEGER
avg_quantity DECIMAL
Data Structures & Algorithms
Medium
Data Structures & Algorithms
Easy
Loading pricing options

View all Cgi questions

Challenge

Check your skills...
How prepared are you for working at Cgi?

CGI Salaries by Position

$89K
$148K
Marketing Analyst
Median: $120K
Mean (Average): $117K
Data points: 5
$81K
$138K
Data Engineer
Median: $92K
Mean (Average): $100K
Data points: 10
$60K
$169K
Software Engineer
Median: $90K
Mean (Average): $98K
Data points: 1,469
$62K
$119K
Data Scientist
Median: $68K
Mean (Average): $78K
Data points: 6
$54K
$104K
Business Analyst
Median: $74K
Mean (Average): $75K
Data points: 101
$51K
$112K
ML Engineer
Median: $67K
Mean (Average): $71K
Data points: 36
Product Manager*
$60K
Product Manager
Median: $60K
Mean (Average): $60K
Data points: 1

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Marketing Analyst role pays the most with a $117,113 base salary while the Product Manager role on average pays the least with a $59,700 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.