Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by CGI Group Team. If you also belong to the team, you can get access from here

CGI Group Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Clear (1)

CGI Group Senior Data Engineer Interview Questions, Process, and Tips

Updated 18 Dec 2024

Top CGI Group Senior Data Engineer Interview Questions and Answers

  • Q1. How do you utilize the enhanced optimization option in AWS Glue?
  • Q2. What are the best practices for optimizing querying in Amazon Redshift?
  • Q3. How to identify the root-cause if an executor is taking longer time compared to others

CGI Group Senior Data Engineer Interview Experiences

2 interviews found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. How do you utilize the enhanced optimization option in AWS Glue?
  • Ans. 

    Enhanced optimization in AWS Glue improves job performance by automatically adjusting resources based on workload

    • Enhanced optimization in AWS Glue automatically adjusts resources like DPUs based on workload

    • It helps improve job performance by optimizing resource allocation

    • Users can enable enhanced optimization in AWS Glue job settings

  • Answered by AI
  • Q2. What are the best practices for optimizing querying in Amazon Redshift?
  • Ans. 

    Optimizing querying in Amazon Redshift involves proper table design, distribution keys, sort keys, and query optimization techniques.

    • Use appropriate distribution keys to evenly distribute data across nodes for parallel processing.

    • Utilize sort keys to physically order data on disk, reducing the need for sorting during queries.

    • Avoid using SELECT * and instead specify only the columns needed to reduce data transfer.

    • Use AN...

  • Answered by AI
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • 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...

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • 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

Skills evaluated in this interview

Senior Data Engineer Interview Questions Asked at Other Companies

asked in 7 Eleven
Q1. Write a query to get the customer with the highest total order va ... read more
asked in 7 Eleven
Q2. There are 10 million records in the table and the schema does not ... read more
asked in 7 Eleven
Q3. How do you handle data pipeline when the schema information keeps ... read more
asked in 7 Eleven
Q4. Difference between Parquet and ORC file. Why industry uses parque ... read more
asked in 7 Eleven
Q5. What is Normalisation and Denormalisation? When do we use them? G ... read more

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops Concepts and Data Structure Questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Oops And Data Structure, Collection.

I applied via Campus Placement and was interviewed before Feb 2020. There were 6 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Was interviewed as fresher?
  • Q2. Written test conducted? with verbal ability test ? GD
  • Q3. How would u deal with a problematic situation when you are working in a team?
  • Q4. What are your plans about higher studies?

Interview Preparation Tips

Interview preparation tips for other job seekers - it was basic with apptiude test and attitiude test.

I applied via Company Website and was interviewed before Feb 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. They asked about dbms questions in the form of table formate
  • Q2. They asked code for some python program

Interview Preparation Tips

Interview preparation tips for other job seekers - Firstly they conducted computer based technical exam and then after qualifying that then we will go for face face interview and then lastly HR round will be held.

I applied via Campus Placement and was interviewed in Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. Wap of bubble sort
  • Ans. 

    Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements and swaps them if they are in the wrong order.

    • Start from the first element and compare it with the next element

    • If the next element is smaller, swap them

    • Repeat this process for all elements in the array

    • Continue this process until no more swaps are needed

  • Answered by AI
  • Q2. Wap of prime number
  • Ans. 

    A program to print all prime numbers

    • Take input from user for range of numbers

    • Loop through the range and check if each number is prime

    • Print the prime numbers

  • Answered by AI
  • Q3. What is hashmap?
  • Ans. 

    Hashmap is a data structure that stores key-value pairs and allows constant time access to values based on their keys.

    • Hashmap uses a hash function to map keys to indices in an array.

    • Collisions can occur when multiple keys map to the same index, which can be resolved using techniques like chaining or open addressing.

    • Examples of hashmap implementations include Java's HashMap class and Python's dict type.

  • Answered by AI
  • Q4. What is inheritance
  • Ans. 

    Inheritance is a mechanism in object-oriented programming where a new class is created by inheriting properties of an existing class.

    • Inheritance allows code reuse and promotes code organization.

    • The existing class is called the parent or superclass, and the new class is called the child or subclass.

    • The child class inherits all the properties and methods of the parent class and can also add new properties and methods.

    • For...

  • Answered by AI
  • Q5. Call by value and call by reference

Interview Preparation Tips

Interview preparation tips for other job seekers - Be yourself

Skills evaluated in this interview

I applied via Walk-in and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Introduction your self in interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview should be very easy and comfortable to the students. And be confident at the infront of interviewer

Interview Questionnaire 

1 Question

  • Q1. About my college projects and about my passion

I applied via Recruitment Consulltant and was interviewed before Apr 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

Standard Aptitude questions

Round 2 - Coding Test 

Based on strings and array

Round 3 - One-on-one 

(1 Question)

  • Q1. Background questions and technical questions related to problem solved

Interview Preparation Tips

Interview preparation tips for other job seekers - Mindtree is one of the best companies, i really miss working there.
It's more on your self development and your carrier.

Interview Questionnaire 

1 Question

  • Q1. A-Z in MySQL, programming languages(only concepts)
Contribute & help others!
anonymous
You can choose to be anonymous

CGI Group Interview FAQs

How many rounds are there in CGI Group Senior Data Engineer interview?
CGI Group interview process usually has 1-2 rounds. The most common rounds in the CGI Group interview process are Technical.
How to prepare for CGI Group Senior Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at CGI Group. The most common topics and skills that interviewers at CGI Group expect are Python, Analytics, CGI, Data Modeling and Data Warehousing.
What are the top questions asked in CGI Group Senior Data Engineer interview?

Some of the top questions asked at the CGI Group Senior Data Engineer interview -

  1. How do you utilize the enhanced optimization option in AWS Gl...read more
  2. What are the best practices for optimizing querying in Amazon Redshi...read more
  3. How to identify the root-cause if an executor is taking longer time compared to...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

CGI Group

No Interviews

INTERVIEWS

CGI Group

No Interviews

LIST OF COMPANIES

Discover companies

Find best workplace

INTERVIEWS

Novac Technology Solutions

No Interviews

DESIGNATION

SALARIES

Nowfloats Technologies

No Salaries

REVIEWS

Nowfloats Technologies

No Reviews

COMPANY BENEFITS

Nowfloats Technologies

No Benefits

Tell us how to improve this page.

CGI Group Senior Data Engineer Interview Process

based on 2 interviews

Interview experience

3.5
  
Good
View more
CGI Group Senior Data Engineer Salary
based on 22 salaries
₹8 L/yr - ₹26.6 L/yr
17% less than the average Senior Data Engineer Salary in India
View more details

CGI Group Senior Data Engineer Reviews and Ratings

based on 2 reviews

4.1/5

Rating in categories

3.0

Skill development

4.4

Work-life balance

3.7

Salary

3.9

Job security

4.0

Company culture

1.0

Promotions

3.1

Work satisfaction

Explore 2 Reviews and Ratings
Software Engineer
8.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
7.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Analyst
3.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Software Engineer
1.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Test Engineer
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare CGI Group with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview