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.3k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

CGI Group ETL Developer Interview Questions and Answers

Updated 12 Dec 2024

3 interviews found

Sort by: Popular

ETL Developer Interview Questions

user image Anonymous

posted on 12 Dec 2024

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via Naukri.com and was interviewed in Jun 2024.

1 Interview Round

1

Technical Round (1 Question)

  • Q1. Informtica with date functions

Skills evaluated in this interview

ETL Developer Interview Questions

user image Anonymous

posted on 21 Apr 2023

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Campus Placement and was interviewed before Apr 2022.

4 Interview Rounds

1

Resume Shortlist Round

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
2

Technical Round (1 Question)

  • Q1. Basic questions based on Informatica power center
3

Technical Round (1 Question)

  • Q1. Scenario based questions on Informatica power center
4

HR Round (1 Question)

  • Q1. Basic salary and other discussion

ETL Developer Interview Questions

user image Anonymous

posted on 21 Feb 2022

I applied via Approached by Company and was interviewed in Aug 2021.

3 Interview Rounds

1

Coding Test Round

Basic Informatica and SQL questions

2

One-on-one Round (1 Question)

  • Q1. Basic informatica questions on duplicate removal and others, SQL query writing
3

HR Round (4 Questions)

  • Q1. What are your salary expectations?
  • Q2. Share details of your previous job.
  • Q3. Why are you looking for a change?
  • Q4. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be cool and stick to basics of your skills

ETL Developer Jobs at CGI Group

View all

Interview questions from similar companies

ETL Developer Interview Questions

Cognizant user image Anonymous

posted on 11 Dec 2024

Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Naukri.com and was interviewed in Nov 2024.

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. Explainyour job role
  • Q2. Explain implementation of SCD 1 in IICS

Skills evaluated in this interview

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via Job Portal and was interviewed in Sep 2024.

1 Interview Round

1

One-on-one Round (2 Questions)

  • Q1. Transformations
  • Q2. Project related questions
Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 -
Result
 No response

I was interviewed in Jun 2024.

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. Rank and dense rank
  • Q2. Scenario based etl question

ETL Developer Interview Questions

Accenture user image Anonymous

posted on 20 Mar 2024

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. Informatica powercenter architecture, scd1, scd2 etc
  • Q2. Lookups and where to use them

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Campus Placement and was interviewed before Jan 2022.

4 Interview Rounds

1

Resume Shortlist Round

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
2

Assignment Round

It's an assignment for apti, verbal

3

Technical Round (1 Question)

  • Q1. It's like an what are u mentioned in resume skills.
4

HR Round (1 Question)

  • Q1. Just like interaction with candidate like personal details.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepare on what u mentioned in resume skills and self confidence..

ETL Developer Interview Questions

Cognizant user image H Ravindra

posted on 19 Mar 2024

Interview experience
5
 Excellent
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Recruitment Consulltant and was interviewed in Feb 2024.

1 Interview Round

1

Technical Round (5 Questions)

  • Q1. What is the uses of filter stage
  • Q2. What is the uses of transfor stage
  • Q3. What is the uses of sort stage
  • Q4. How to create the prallel job
  • Q5. Defenation of scd

Interview Preparation Tips

Interview preparation tips for other job seekers - Hi my name is ravindra pls check my profile .i'm intrested ur company

Skills evaluated in this interview

ETL Developer Interview Questions

Capgemini user image Anonymous

posted on 19 Sep 2022

I applied via LinkedIn and was interviewed in Aug 2022.

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. Question on logic SCD types
  • Q2. Dynamic lookup along with lookup

Interview Preparation Tips

Interview preparation tips for other job seekers - Technical mainly logic and interview is cool Lister so that you can explain well

CGI Group Interview FAQs

How many rounds are there in CGI Group ETL Developer interview?
CGI Group interview process usually has 2-3 rounds. The most common rounds in the CGI Group interview process are Technical, HR and Coding Test.
How to prepare for CGI Group ETL Developer 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 SQL, CGI, Business process, Informatica and Coding.
What are the top questions asked in CGI Group ETL Developer interview?

Some of the top questions asked at the CGI Group ETL Developer interview -

  1. Informtica with date functi...read more
  2. Basic informatica questions on duplicate removal and others, SQL query writ...read more
  3. Scenario based questions on Informatica power cen...read more

Tell us how to improve this page.

People are getting interviews through

based on 3 CGI Group interviews
Job Portal
Campus Placement
33%
33%
34% candidates got the interview through other sources.
Moderate Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
CGI Group ETL Developer Salary
based on 35 salaries
₹3.9 L/yr - ₹10.1 L/yr
At par with the average ETL Developer Salary in India
View more details

CGI Group ETL Developer Reviews and Ratings

based on 2 reviews

5.0/5

Rating in categories

4.0

Skill development

4.0

Work-Life balance

4.6

Salary & Benefits

4.0

Job Security

4.4

Company culture

4.6

Promotions/Appraisal

4.0

Work Satisfaction

Explore 2 Reviews and Ratings
AZURE ETL Developer

Hyderabad / Secunderabad,

Chennai

+1

4-6 Yrs

Not Disclosed

ETL Developer

Bangalore / Bengaluru

2-4 Yrs

Not Disclosed

Explore more jobs
Software Engineer
8k salaries
unlock blur

₹3.8 L/yr - ₹13.5 L/yr

Senior Software Engineer
7.1k salaries
unlock blur

₹6 L/yr - ₹22 L/yr

Lead Analyst
3k salaries
unlock blur

₹9.9 L/yr - ₹29 L/yr

Associate Software Engineer
1.8k salaries
unlock blur

₹2.5 L/yr - ₹6.8 L/yr

Senior Test Engineer
1.2k salaries
unlock blur

₹6 L/yr - ₹20.2 L/yr

Explore more salaries
Compare CGI Group with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.6
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview