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 Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. What is collections
  • Q2. What are the new features in java 8
  • Ans. 

    Java 8 introduces lambda expressions, functional interfaces, streams, and default methods.

    • Lambda expressions allow functional programming in Java

    • Functional interfaces enable the use of lambda expressions

    • Streams provide a concise way to perform operations on collections

    • Default methods allow interfaces to have implementation

    • Date and Time API improvements

    • Nashorn JavaScript engine

  • Answered by AI
  • Q3. What is the use of spring boot
  • Q4. What is JPA
  • Ans. 

    JPA stands for Java Persistence API, a specification for object-relational mapping in Java applications.

    • JPA is used to map Java objects to relational database tables.

    • It provides a set of annotations to define the mapping between Java classes and database tables.

    • JPA also supports querying data using the Java Persistence Query Language (JPQL).

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It will be easy interview

Skills evaluated in this interview

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 Recruitment Consultant and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic javascript and nodejs questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep your basics clear

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.

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 Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Basic question on testing, selenium, java, sql, agile, topics from resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare with whatever written in resume

Interview Questionnaire 

1 Question

  • Q1. Aptitude, coding
Are these interview questions helpful?

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself ?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and share your technical knowledge

Interview Questionnaire 

1 Question

  • Q1. Mainframe questions, some direct and some scenario based.

Interview Preparation Tips

Interview preparation tips for other job seekers - It was a good experience. Interview process was smoothly. There were 3 rounds.
1. Technical ( lasted for 1 hour)
2. Techno manageria( 30 mins)
3. HR(30 mins)

Project based questions and scenario based questions were asked.
Hike was also good.

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

Interview Questionnaire 

4 Questions

  • Q1. Best sorting although and its working they asked
  • Q2. Write a program to replace the character with another character in java.
  • Ans. 

    A program to replace a character with another character in Java.

    • Create a string variable with the original text

    • Use the replace() method to replace the character with another character

    • Print the new string with the replaced character

  • Answered by AI
  • Q3. SQL queries on order by, group by, and it's difference they asked.
  • Q4. Project management experience they asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepare on the basis concepts and be perfect on your resume they are not expecting much from you as you are a fresher.

Skills evaluated in this interview

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.8 L/yr

Lead Analyst
3.3k salaries
unlock blur

₹15.2 L/yr - ₹26.5 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.8 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