Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
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
4.0

based on 4.6k Reviews

Play video Play video Video summary

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

CGI Group ETL Tester Interview Questions and Answers

Updated 9 Oct 2024

CGI Group ETL Tester Interview Experiences

2 interviews found

ETL Tester Interview Questions & Answers

user image Jegadeeswari.m

posted on 9 Oct 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Types of schema
  • Ans. 

    Types of schema include star schema, snowflake schema, and fact constellation schema.

    • Star schema: central fact table connected to dimension tables in a star-like structure.

    • Snowflake schema: normalized form of star schema with dimension tables further normalized.

    • Fact constellation schema: multiple fact tables share dimension tables.

    • Answered by AI
    Add your answer

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 5 Jun 2024

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. About your project
    • Add your answer
  • Q2. About project architecture
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - be thorough with the transformations

ETL Tester Interview Questions Asked at Other Companies

asked in Cognizant
Q1. If we have 200 staging tables, 40 dimensions tables and 20 facts ... read more
View answers (3)
asked in Cognizant
Q2. 2.Difference between Union and union all,drop and Truncate,star s ... read more
View answers (2)
asked in EPAM Systems
Q3. What is the difference between Test Plan and Test strategy
View answer (1)
asked in Cognizant
Q4. Which type of Validation you will do at Landing and staging area.
View answers (2)
asked in Infosys
Q5. How do you get data integrity between source and destination, how ... read more
View answer (1)
View All

Interview questions from similar companies

Consultant Interview Questions & Answers

Capgemini user image Anonymous

posted on 8 May 2021

I applied via Recruitment Consultant and was interviewed before May 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Related tklo subjected domain .........
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good

Consultant Interview Questions & Answers

Capgemini user image Anonymous

posted on 8 Jul 2021

Interview Questionnaire 

1 Question

  • Q1. Intro and basic Mainframe interview questions related to Cobol, JCL, VSAM, DB2 etc.
    • Add your answer

Consultant Interview Questions & Answers

Capgemini user image Anonymous

posted on 8 Jul 2021

Interview Questionnaire 

1 Question

  • Q1. Types Software testings
  • Ans. 

    Types of software testing include functional, performance, security, usability, and compatibility testing.

    • Functional testing ensures that the software meets the specified requirements.

    • Performance testing checks the software's speed, scalability, and stability under various loads.

    • Security testing identifies vulnerabilities and ensures that the software is secure.

    • Usability testing evaluates the software's user-friendline...

    • Answered by AI
    Add your answer

Skills evaluated in this interview

Consultant Interview Questions & Answers

Capgemini user image Anonymous

posted on 13 Jul 2021

I applied via Naukri.com and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. I have been asked the questions related to Mulesoft
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview experience was really good...HR was supportive throughout the process

Consultant Interview Questions & Answers

Cognizant user image Anonymous

posted on 7 Apr 2021

I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic work related, real time problems, inner concept of tools.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough on what you are doing, even if its just 1 tool.. questions can be random.

Consultant Interview Questions & Answers

Capgemini user image Anonymous

posted on 29 Jun 2021

I applied via Company Website and was interviewed in Dec 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Solid Principal, error handling techniques, oops and basics of c#
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best

Consultant Interview Questions & Answers

Capgemini user image Anonymous

posted on 16 Jul 2021

I applied via Naukri.com and was interviewed in Jan 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Related to Functional testing
    • Add your answer
  • Q2. General Discussion
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Try hard and never loose hope. Prepare well on your technical skills and attend interview without fail. Hardwork never fails. All the best for your future.

Consultant Interview Questions & Answers

Capgemini user image Anonymous

posted on 9 Jul 2022

I applied via Naukri.com and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Basic SQL questions, Basic ASP.NET
    • Add your answer
Round 2 - Assignment 

AMCAT English assignment test

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare common basics questions based on your profile
More about working at CGI Group

CGI Group Interview FAQs

How many rounds are there in CGI Group ETL Tester interview?
CGI Group interview process usually has 1 rounds. The most common rounds in the CGI Group interview process are Technical.
How to prepare for CGI Group ETL Tester 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 ETL Testing, SQL, CGI, Python and Agile Testing.

Tell us how to improve this page.

CGI Group Interviews By Designations

Interview Questions for Popular Designations

CGI Group ETL Tester Interview Process

based on 2 interviews

Interview experience

3
  
Average
View more

ETL Tester Interview Questions from Similar Companies

Infosys ETL Tester Interview Questions
3.6
 • 12 Interviews
Cognizant ETL Tester Interview Questions
3.7
 • 8 Interviews
LTIMindtree ETL Tester Interview Questions
3.8
 • 7 Interviews
Accenture ETL Tester Interview Questions
3.8
 • 6 Interviews
Capgemini ETL Tester Interview Questions
3.7
 • 6 Interviews
TCS ETL Tester Interview Questions
3.7
 • 5 Interviews
Hexaware Technologies ETL Tester Interview Questions
3.5
 • 5 Interviews
Wipro ETL Tester Interview Questions
3.7
 • 3 Interviews
EPAM Systems ETL Tester Interview Questions
3.7
 • 3 Interviews
HCLTech ETL Tester Interview Questions
3.5
 • 2 Interviews
View all

Fast track your campus placements

Birla Institute of Technology (BIT), Ranchi Placement Questions
2 Interviews
National Institute of Technology (NIT), Durgapur Placement Questions
2 Interviews
National Institute of Technology,(NIT), Delhi Placement Questions
2 Interviews
BV Raju Institute of Technology, Medak Placement Questions
1 Interview
Gandhi Institute for Engineering and Technology, Gunupur Placement Questions
1 Interview
International Institute of Information Technology (IIIT), Pune Placement Questions
1 Interview
J S S Academy of Technical Education, Bangalore Placement Questions
1 Interview
View all
CGI Group ETL Tester Salary
based on 49 salaries
₹2.8 L/yr - ₹9.2 L/yr
6% less than the average ETL Tester Salary in India
View more details

CGI Group ETL Tester Reviews and Ratings

based on 3 reviews

4.7/5

Rating in categories

4.7

Skill development

4.6

Work-life balance

3.9

Salary

4.8

Job security

4.1

Company culture

4.1

Promotions

4.1

Work satisfaction

Explore 3 Reviews and Ratings
CGI Group Salaries in India
Software Engineer
8.1k salaries
unlock blur

₹3.8 L/yr - ₹12 L/yr

Senior Software Engineer
7.3k salaries
unlock blur

₹6.2 L/yr - ₹23 L/yr

Lead Analyst
3.1k salaries
unlock blur

₹10 L/yr - ₹31.5 L/yr

Associate Software Engineer
1.8k salaries
unlock blur

₹2.5 L/yr - ₹7 L/yr

Senior Test Engineer
1.2k salaries
unlock blur

₹6 L/yr - ₹18.9 L/yr

Explore more salaries
Compare CGI Group with

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare

Capgemini

3.7
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview