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 2025 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

CGI Group Database Architect Interview Questions and Answers

Updated 22 Jun 2021

CGI Group Database Architect Interview Experiences

1 interview found

I applied via Recruitment Consultant and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. Are you aware of DevOp? How to use in producing output for client?
  • Ans. 

    Yes, DevOps is a set of practices that combines software development and IT operations to deliver high-quality software faster.

    • DevOps is a culture and set of practices that emphasizes collaboration, automation, and monitoring throughout the software development lifecycle.

    • It involves integrating development, testing, deployment, and operations teams to streamline the software delivery process.

    • By using DevOps, database a...

  • Answered by AI
  • Q2. What is the application that is better than Spark in AWS?
  • Ans. 

    AWS Glue is an application that is better than Spark in AWS.

    • AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy to prepare and load data for analytics.

    • It provides a serverless environment for running ETL jobs and supports various data sources and destinations.

    • AWS Glue also offers automatic schema discovery, data cataloging, and data transformation capabilities.

    • It integrates well wi...

  • Answered by AI
  • Q3. How do you connect to to AWS as a developer?
  • Ans. 

    To connect to AWS as a developer, you can use the AWS Management Console, AWS CLI, or AWS SDKs.

    • Use the AWS Management Console to access AWS services through a web-based user interface.

    • Utilize the AWS Command Line Interface (CLI) to interact with AWS services using commands in the terminal.

    • Leverage AWS Software Development Kits (SDKs) to integrate AWS services into your applications.

    • For example, you can use the AWS SDK ...

  • Answered by AI
  • Q4. What is the security system of AWS access?
  • Ans. 

    AWS provides a comprehensive security system for access control.

    • AWS Identity and Access Management (IAM) allows you to manage access to AWS services and resources.

    • IAM enables you to create and manage users, groups, and roles, and assign permissions to them.

    • AWS provides various authentication methods like username/password, multi-factor authentication, and integration with external identity providers.

    • Access can be contr...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Sometimes the interviewer can be a glober - who really doesn't know what they are talking about. They will even ask you what they do not know. They can even ask you things that are NOT applicable and they will stand with it to show that they know better. Above all as a candidate for the role that you really want to go with, ensure that you are aware of what you say, be prepared for the interview as if you know nothing. Ensure that you are well informed on the line of task. Also be prepated to provide the interviewer one good project that you had already carried out based on the application required for the profile. Be calm always if the company recruit you, it is their luck as you always have ample opportunity with other company as well.

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
1w (edited)
a team lead
Why are women still asked such personal questions in interview?
I recently went for an interview… and honestly, m still trying to process what just happened. Instead of being asked about my skills, experience, or how I could add value to the company… the questions took a totally unexpected turn. The interviewer started asking things like When are you getting married? Are you engaged? And m sure, if I had said I was married, the next question would’ve been How long have you been married? What does my personal life have to do with the job m applying for? This is where I felt the gender discrimination hit hard. These types of questions are so casually thrown at women during interviews but are they ever asked to men? No one asks male candidates if they’re planning a wedding or how old their kids are. So why is it okay to ask women? Can we please stop normalising this kind of behaviour in interviews? Our careers shouldn’t be judged by our relationship status. Period.
Got a question about CGI Group?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Sep 2021. There were 4 interview rounds.

Round 1 - Aptitude Test 

Prepare normal for aptitude - maths, quant, analytic

Round 2 - Group Discussion 

My GD topic was Is internet good for students or not

Round 3 - Coding Test 

I didn't attempt this as I was noob back in third year Engg

Round 4 - HR 

(1 Question)

  • Q1. Basic questions can you relocate, tell me about ur GD and composition

Interview Preparation Tips

Interview preparation tips for other job seekers - Easy peasy give ur best. Prepare well. Hope u get the job. Phir tho google ka hi dream rhe gaya he mera.

Database Architect Interview Questions Asked at Other Companies

asked in CGI Group
Q1. Are you aware of DevOp? How to use in producing output for client ... read more
asked in CGI Group
Q2. What application is better than Spark in AWS?
asked in CGI Group
Q3. What is the security system for AWS access?
asked in CGI Group
Q4. As a developer, how do you connect to AWS?
asked in ValGenesis
Q5. How do you lift and shift on-prem databases into Azure?

I applied via Campus Placement and was interviewed in May 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Data srructures

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident revise data structures ,
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Dec 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

There are 2section of exam i.e English and Data structure

Round 3 - Mind analysis games 

(2 Questions)

  • Q1. First round interview is technical interview and managerial interviews which is not that tough. Do all the FaQ on your projects and if dont know any one of question answer then dont worry simply say it a...
  • Q2. 2nd round is HR interview .

Interview Preparation Tips

Interview preparation tips for other job seekers - In HR interview they ask about introduction, strength and weakness , willing to work on teams or not, some scenario based question

I applied via Company Website and was interviewed before Oct 2021. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Basic Aptitude with some difficult questions

Round 3 - Coding Test 

3 set of coding question were asked 1 easy ,1 medium ,1 hard

Round 4 - One-on-one 

(1 Question)

  • Q1. This was personal technical interview asking all related to my cv and the one they are looking for
Round 5 - HR 

(1 Question)

  • Q1. Basic personality questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare everything basic and from the CV and you will be good to go.Research about the company a bit that will add cherry on top.

I applied via Campus Placement and was interviewed before Nov 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Python and Java questions
  • Q2. Oops basic interview questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Easily we can Just Practice basic interview questions

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

Interview Questionnaire 

1 Question

  • Q1. About final year project

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good
Are these interview questions helpful?

I applied via Campus Placement and was interviewed before Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Related to final year project and basic programming.

Interview Preparation Tips

Interview preparation tips for other job seekers - I applied for pool campus drive before covid in feb 2019. The whole interview process have done in one day.

The first round was basic aptitude and essay writing the level of difficulty is average and this is also elimination round.

The second was pseudo coding round It has mcq based programing question like arrays, looping and some data structure question.

Depending on the score in coding round they split us into two groups infra and non infra. Infra for cloud and infrastructure related roles and non-infra for programming related role.

The third round was technical Hr. The level of the interview is average he asked basic questions in c and java like inheritance, Polymorphism, encapsulates etc.. and some final project related questions.

The last round was General Hr. He is very friendly and ask about some basic hr question. More importantly know something about the company before getting into this round.

I cleared the interview and got my LOI after 2 months.

Capgemini follows the pre joining course for fresher as ADAPT. It's very useful those are from non IT background.

Clearing ADAPT is not mandatory but you need to participate.

Due to pandemic I got the offer letter on Feb 2021 and now I have completed my training and looking for project.

Interview Questionnaire 

2 Questions

  • Q1. Difference between++I and I++
  • Ans. 

    ++I is a pre-increment operator that increments the value of I before using it, while I++ is a post-increment operator that increments the value of I after using it.

    • ++I increments the value of I and then uses the updated value in the expression.

    • I++ uses the current value of I in the expression and then increments it.

    • Both operators can be used with variables, arrays, or pointers.

  • Answered by AI
  • Q2. Local static variable

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Jan 2021. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. 1) Introduce yourself
  • Ans. 

    I am a passionate Software Engineer with a strong background in full-stack development and a love for solving complex problems.

    • Education: I hold a degree in Computer Science, where I developed a solid foundation in algorithms and data structures.

    • Experience: I have over 3 years of experience working with technologies like Java, Spring Boot, and React, building scalable web applications.

    • Projects: I led a team project to ...

  • Answered by AI
  • Q2. 2) OOPS concepts
  • Q3. 3) About Project
  • Q4. 4) Why cognizant
  • Ans. 

    Cognizant offers innovative solutions, a collaborative culture, and opportunities for growth in a dynamic tech environment.

    • Cognizant's commitment to innovation aligns with my passion for cutting-edge technology, as seen in their AI and cloud solutions.

    • The company's diverse projects across various industries provide a unique opportunity to broaden my skill set and experience.

    • Cognizant's emphasis on employee development ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview is completely based on basic concepts of c++

CGI Group Interview FAQs

How to prepare for CGI Group Database Architect 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 Coding, Computer science, DBMS, Database Administration and MS SQL.
What are the top questions asked in CGI Group Database Architect interview?

Some of the top questions asked at the CGI Group Database Architect interview -

  1. Are you aware of DevOp? How to use in producing output for clie...read more
  2. What is the application that is better than Spark in A...read more
  3. What is the security system of AWS acce...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Accenture Interview Questions
3.7
 • 8.7k Interviews
Wipro Interview Questions
3.7
 • 6.1k Interviews
Cognizant Interview Questions
3.7
 • 5.9k Interviews
Capgemini Interview Questions
3.7
 • 5.1k Interviews
Genpact Interview Questions
3.7
 • 3.4k Interviews
LTIMindtree Interview Questions
3.7
 • 3k Interviews
IBM Interview Questions
3.9
 • 2.5k Interviews
DXC Technology Interview Questions
3.6
 • 842 Interviews
Nagarro Interview Questions
3.9
 • 793 Interviews
View all
Software Engineer
8.4k salaries
unlock blur

₹5 L/yr - ₹12 L/yr

Senior Software Engineer
7.7k salaries
unlock blur

₹9 L/yr - ₹18.7 L/yr

Lead Analyst
3.3k salaries
unlock blur

₹15.2 L/yr - ₹26.3 L/yr

Associate Software Engineer
1.9k salaries
unlock blur

₹2.5 L/yr - ₹7 L/yr

Senior Test Engineer
1.3k salaries
unlock blur

₹9.7 L/yr - ₹17.7 L/yr

Explore more salaries
Compare CGI Group with

Accenture

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare

Capgemini

3.7
Compare
write
Share an Interview