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

zig zag pattern zig zag pattern

Filter interviews by

CGI Group ETL Tester Interview Questions and Answers for Experienced

Updated 9 Oct 2024

CGI Group ETL Tester Interview Experiences for Experienced

1 interview 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

Interview questions from similar companies

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

Round 1 - Technical 

(1 Question)

  • Q1. Questions on Salesforce Basics. One can learn all great features in Salesforce.com but we must know the basic admin functionalities and features in Saleforce.
Round 2 - Behavioral 

(1 Question)

  • Q1. The questions will be on your career, Resume. They will look for story telling skills, can you be a team player and individual player, etc. Can be technical as well.

Interview Preparation Tips

Interview preparation tips for other job seekers - First know the basics of Saleforce.com for functional role then you dive into all great features in Salesforce.

I applied via Naukri.com and was interviewed in Jun 2019. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Configuration Management, data modelling, CI relationships, Problem management process flow, SIAM, integration, cmdb reports, KPIs.
  • Q2. General introduction, projects handled in the past,

Interview Preparation Tips

Interview preparation tips for other job seekers - Stick to what u have worked on in your resume, ask about offered profile,

I applied via Campus Placement and was interviewed before Nov 2019. There were 8 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Porters Generic Marketing Strategy
  • Q2. Extempore Pitch to position a product differentially in the Market
  • Ans. 

    Our product is the only one in the market that offers a unique combination of features and benefits.

    • Our product is designed to solve a specific problem that no other product in the market can solve.

    • Our product offers a unique combination of features and benefits that are not available in any other product.

    • Our product is backed by extensive research and development, ensuring that it is the most effective solution in the...

  • Answered by AI
  • Q3. Why MBA, Why Marketing

Interview Preparation Tips

Interview preparation tips for other job seekers - 1.Be confident , Open and Prepared

2.Kindly understand the question and answer relating with some of the concepts you have studied

I applied via Naukri.com and was interviewed before Dec 2019. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Oracle Apps Technical - PlSQL concepts
  • Q2. Basic questions like logic to find even number, swap number ,etc.

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to see all the Technology related questions in Google before going for interview.

Interview Questionnaire 

1 Question

  • Q1. Data transforms, integration, data pages, RAP, Case management

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and give your answer with confidence

I applied via Referral and was interviewed in Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Its from Java, Springboot, Microservices.. and touchbase of UI technologies such as Angular.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be well prepared for evry topic.. ask yourself what, when, why, how.
Thats how you can think logically.

then only you will be able to crack.

I applied via Campus Placement and was interviewed before Apr 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is sdlc? Tell me about yourself. What is options future

Interview Preparation Tips

Interview preparation tips for other job seekers - Preparation tell me about yourself well

I applied via Approached by Company and was interviewed in Dec 2018. There were 2 interview rounds.

Interview Preparation Tips

General Tips: I believe Knowledge and application of knowledge are the only things required to get selected in any interview. To get this two things you have to work on your skills and have good hands on experience. You will be a master in applying your knowledge to real time problems if you have faced them with honesty, hard work and dedication in your current/previous work. Other skills like communication, presentation and domain knowledge comes as by product in the process of learning/day to day job. Make sure your basics are strong in whatever technology you are working in.
If you fail once, you will be better for the next. Good luck!
Skills: Communication, Problem Solving, Analytical Skills, Presentation Skills, Decision Making Skills
Duration: 1-4 weeks

Interview Questionnaire 

2 Questions

  • Q1. Technical
  • Q2. Be yourself

CGI Group Interview FAQs

How many rounds are there in CGI Group ETL Tester interview for experienced candidates?
CGI Group interview process for experienced candidates usually has 1 rounds. The most common rounds in the CGI Group interview process for experienced candidates are Technical.
How to prepare for CGI Group ETL Tester interview for experienced candidates?
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 ETL Tester Interview Process for Experienced

based on 1 interview

Interview experience

4
  
Good
View more
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
Software Engineer
8.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
7.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Analyst
3.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Software Engineer
1.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Test Engineer
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare CGI Group with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview