i
CGI Group
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Clear (1)
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
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
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...
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...
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
I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Feb 2020. There were 6 interview rounds.
I applied via Company Website and was interviewed before Feb 2020. There was 1 interview round.
I applied via Campus Placement and was interviewed in Oct 2020. There were 4 interview rounds.
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
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
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.
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...
I applied via Walk-in and was interviewed in Mar 2021. There was 1 interview round.
I applied via Recruitment Consulltant and was interviewed before Apr 2021. There were 3 interview rounds.
Standard Aptitude questions
Based on strings and array
Some of the top questions asked at the CGI Group Senior Data Engineer interview -
based on 2 interviews
Interview experience
based on 2 reviews
Rating in categories
Software Engineer
8.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
7.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Analyst
3.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Software Engineer
1.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Test Engineer
1.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech