CGI Group Interview Questions, Process, and Tips

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...read more

The command to search a file like test.txt in Linux is 'grep'.

• Use the 'grep' command followed by the search term and the file name to search for a specific text in a file.

• For example, to search for the word 'hello' in a file named test.txt, you would use the command 'grep hello test.txt'.

Constraints are limitations or restrictions that affect the design, implementation, or operation of a system.

• Constraints can be related to time, budget, resources, technology, or regulations.

• They can impact the functionality, performance, scalability, or security of a system.

• Examples include budget constraints limiting the purchase of new hardware, time constraints for project deadlines, or regulatory constraints for d...read more

To get the value present at 80th row, 100th column, you can use the command 'awk' in Unix/Linux systems.

• Use the 'awk' command with the syntax 'awk 'NR==80 {print $100}' filename' to get the value at the specified row and column.

• Replace 'filename' with the actual file name where the data is stored.

• Ensure that the row and column numbers are adjusted based on the indexing starting from 1 in 'awk'.

A view in SQL is a virtual table based on the result-set of a SELECT statement.

• Views are used to simplify complex queries by storing them as virtual tables

• Views do not store data themselves, but display data from underlying tables

• Views can be used to restrict access to certain columns or rows of a table

• Views can be used to join multiple tables and present the data in a single table-like structure

Internal workflow for BFSI domain involves processes related to banking, financial services, and insurance.

• Customer onboarding and account setup

• Transaction processing and monitoring

• Risk management and compliance checks

• Customer support and issue resolution

• Data analysis and reporting

I am a dedicated and experienced Production Support Analyst with a strong background in troubleshooting and resolving technical issues.

• Over 5 years of experience in providing production support for various applications

• Proficient in analyzing system logs and identifying root causes of issues

• Skilled in collaborating with development teams to implement solutions and prevent future incidents

• Strong communication skills to e...read more

In the BFSI domain, an asset refers to any valuable item owned by an individual or organization that can be converted into cash.

• Assets can include cash, investments, real estate, equipment, and intellectual property.

• In the banking sector, assets can also refer to loans given out to customers.

• Assets are important for financial institutions as they represent the value of the organization and its ability to generate reven...read more