CGI Group Change Manager Interview Questions and Answers

Aptitude questions as well as reasoning

2 coding questions from linear data structure

Q1. What is DML in SQL?
Ans. 
DML stands for Data Manipulation Language in SQL, used for managing data in a database.
• DML is used to insert, update, delete, and retrieve data in a database.

• Examples of DML statements include INSERT, UPDATE, DELETE, and SELECT.

• DML commands are used to interact with the data stored in tables.
Answered by AI
Add your answer
Q2. How can you print the array of numbers in reverse order?
Ans. 
To print an array of numbers in reverse order, iterate through the array starting from the last element and print each element.
• Iterate through the array starting from the last element to the first element.

• Print each element as you iterate through the array.

• Example: for (int i = array.length - 1; i >= 0; i--) { System.out.println(array[i]); }
Answered by AI
Add your answer

Q1. Where do you want to see your self in 5 years?
Ans. 
In 5 years, I see myself as a senior consultant leading a team of experts, working on high-impact projects and contributing significantly to the growth of the organization.
• Leading a team of experts

• Working on high-impact projects

• Contributing significantly to the growth of the organization
Answered by AI
Add your answer

Q1. What is your total experience into
Ans. 
I have over 5 years of experience in consulting, specializing in strategy development and operational efficiency.
• Led a project for a Fortune 500 company, improving their supply chain efficiency by 20%.

• Conducted market analysis for a startup, helping them secure $1M in funding.

• Facilitated workshops for clients to enhance team collaboration and productivity.
Answered by AI
Add your answer
Q2. What you have done differently
Ans. 
I implemented innovative strategies to enhance team collaboration and improve project outcomes.
• Introduced agile methodologies to streamline project management, resulting in a 20% increase in team efficiency.

• Developed a mentorship program that paired junior consultants with experienced team members, fostering knowledge sharing.

• Utilized data analytics to identify client needs more accurately, leading to tailored solution...read more
Answered by AI
Add your answer

There were 4 sections in the test namely VARC, LRDI, QUANTS and last one was specific to the commerce

The number of participants was around 9 or 10 given a topic discussion continued for 15 minutes

Maths questions and data interpretation

Q1. General questions
Add your answer
Q2. What is your motivation?
Add your answer
Q3. What is your hobby?
Add your answer
Q4. Why do you want to join us?
Add your answer
Q5. How do you see yourself in 5 years?
Add your answer

Q1. About my project
Add your answer
Q2. Complete my project related questions
Add your answer

Online questions were based on scenarios to write SQL queries. Also got few questions on Python as well for which I had only limited knowledge.

Q1. I'm listing some of the questions here which the interviewers (2 panel resources) asked me regarding Informatica ETL, Oracle DB and I might have missed some of them. What types of indexes are used on Orac...read more
Add your answer
Q2. What happens if Treat source row property as "Update" at session level but at target object "Delete" is checked?
Ans. 
The source row will be treated as an update, but the target object will be deleted.
• The session level property 'Treat source row as Update' will be applied to the source row.

• The target object will be deleted regardless of the update status of the source row.

• This can result in data loss if the source row contains important information.
Answered by AI
Add your answer
Q3. What are the different types of dimension tables?
Ans. 
Dimension tables are used in data warehousing to provide descriptive information about the data in fact tables.
• Slowly changing dimensions

• Junk dimensions

• Degenerate dimensions

• Role-playing dimensions

• Bridge dimensions
Answered by AI
Add your answer
Q4. What schema type was used in your previous project? And explain why it was used?
Ans. 
We used a relational schema in our previous project as it was suitable for the data structure and allowed for efficient querying.
• Relational schema was used as it allowed for efficient querying of data

• The data structure was suitable for a relational schema

• We were able to easily join tables to retrieve necessary data

• Examples include using SQL to query a database with multiple tables

• Normalization was used to reduce data r
Answered by AI
Add your answer
Q5. Difference between Joiner and Lookup transformations?
Ans. 
Joiner combines data from multiple sources based on a common key, while Lookup retrieves data from a reference table based on a matching key.
• Joiner is used to combine data from two or more sources based on a common key column.

• Lookup is used to retrieve data from a reference table based on a matching key column.

• Joiner can perform inner, outer, left, and right joins, while Lookup can only perform an inner join.

• Joiner can...read more
Answered by AI
Add your answer
Q6. Scenario: I have records in a flat file ending with ; character at the end of each them. How to load these records into DB based on this character? What property will be used in Informatica?
Add your answer
Q7. How version control happened in your previous project?
Ans. 
We used Git for version control in our previous project.
• We created a Git repository for the project.

• All team members were added as collaborators to the repository.

• We followed the Git flow branching model.

• We used pull requests for code review and merging.

• We used tags to mark important releases.

• We regularly pushed our changes to the remote repository.

• We used Git commands like commit, push, pull, merge, and rebase.

• We used...read more
Answered by AI
Add your answer
Q8. Which SCD type you worked on before and explain on that?
Ans. 
I have worked on SCD Type 2 before.
• SCD Type 2 is used to track historical changes in data.

• It creates a new record for each change and maintains a history of changes.

• It includes start and end dates for each record.

• Example: Tracking changes in employee salary over time.
Answered by AI
Add your answer

Q1. This round was taken by the project manager on a phone call. He asked me few basic fundamental questions related to my skills and the things which I worked on in my previous project. He also told me about ...read more
Add your answer

Q1. Just F2F discussion with HR finalising on the compensation structure, learning opportunities and the organisational benefits as an employee.
Add your answer

Q1. Basic flow, integrations
Add your answer

Q1. Detail process flows
Ans. 
Process flows detail the steps involved in completing a task or project.
• Identify the starting point and end goal

• Break down the process into smaller steps

• Determine the order of the steps

• Assign responsibilities for each step

• Identify potential roadblocks and solutions

• Review and refine the process as needed
Answered by AI
Add your answer