AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
CGI Group
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
CGI Group ETL Developer Interview Questions and Answers for Experienced
CGI Group ETL Developer Interview Experiences for Experienced
3 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
(1 Question)
- Q1. Informtica with date functions
- Ans.
Informatica is a popular ETL tool used for data integration and transformation. It has built-in functions to handle date operations.
Informatica is a powerful ETL tool used for extracting, transforming, and loading data.
It provides a variety of built-in functions for handling date operations such as date calculations, formatting, and conversions.
Examples of date functions in Informatica include TO_DATE, TO_CHAR, ADD_TO_
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed before Apr 2022. There were 4 interview rounds.
(1 Question)
- Q1. Basic questions based on Informatica power center
(1 Question)
- Q1. Scenario based questions on Informatica power center
(1 Question)
- Q1. Basic salary and other discussion
I applied via Approached by Company and was interviewed in Aug 2021. There were 3 interview rounds.
Basic Informatica and SQL questions
(1 Question)
- Q1. Basic informatica questions on duplicate removal and others, SQL query writing
(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
Top trending discussions
Interview questions from similar companies
Selected
I applied via Campus Placement and was interviewed before Jan 2022. There were 4 interview rounds.
It's an assignment for apti, verbal
(1 Question)
- Q1. It's like an what are u mentioned in resume skills.
(1 Question)
- Q1. Just like interaction with candidate like personal details.
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Aug 2022. There were 3 interview rounds.
(1 Question)
- Q1. Self introduction
(1 Question)
- Q1. Package discussion
Selected
I applied via Naukri.com and was interviewed before Apr 2023. There was 1 interview round.
(1 Question)
- Q1. SQL query and informatica scenario based questions
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Aug 2022. There was 1 interview round.
(2 Questions)
- Q1. Question on logic SCD types
- Q2. Dynamic lookup along with lookup
Interview Preparation Tips
I appeared for an interview in Jun 2024.
(2 Questions)
- Q1. Rank and dense rank
- Q2. Scenario based etl question
I applied via Naukri.com and was interviewed in Dec 2023. There was 1 interview round.
(1 Question)
- Q1. Explain the difference between ETL and ELT?
- Ans.
ETL is Extract, Transform, Load where data is extracted, transformed, and loaded into a data warehouse. ELT is Extract, Load, Transform where data is extracted, loaded into a data warehouse, and then transformed.
ETL involves extracting data from source systems, transforming it according to business rules, and loading it into a data warehouse.
ELT involves extracting data from source systems, loading it into a data wareh...
Skills evaluated in this interview
Interview Questionnaire
4 Questions
- Q1. Whats is mapping
- Ans.
Mapping is the process of defining the relationship between source and target data in ETL.
Mapping involves identifying the source and target data structures.
It also involves defining the transformation rules to be applied to the source data.
Mappings can be simple or complex depending on the complexity of the data.
Mapping is a critical step in ETL as it determines the accuracy and completeness of the data in the target
- Q2. What is sesson
- Ans.
Session refers to a period of time during which a user interacts with a computer system or application.
A session is created when a user logs into a system or application.
It is used to track user activity and maintain user-specific data.
Sessions can be terminated manually or automatically after a certain period of inactivity.
Session management is important for security purposes.
Examples of session management techniques
- Q3. Which role u did
- Q4. Oracle sqi pl sqi
CGI Group Interview FAQs
Tell us how to improve this page.
CGI Group Interviews By Designations
- CGI Group Software Engineer Interview Questions
- CGI Group Associate Software Engineer Interview Questions
- CGI Group Senior Software Engineer Interview Questions
- CGI Group Software Developer Interview Questions
- CGI Group Senior Test Engineer Interview Questions
- CGI Group Test Engineer Interview Questions
- CGI Group Softwaretest Engineer Interview Questions
- CGI Group Automation Test Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior ETL Developer Interview Questions
- Informatica ETL Developer Interview Questions
- Database Developer Interview Questions
- Informatica Developer Interview Questions
- Datastage Developer Interview Questions
- SQL Server Developer Interview Questions
- ETL Lead Interview Questions
- Software Developer Interview Questions
- Show more
CGI Group ETL Developer Interview Process for Experienced
based on 2 interviews
Interview experience
ETL Developer Interview Questions from Similar Companies
Fast track your campus placements
CGI Group ETL Developer Reviews and Ratings
based on 2 reviews
Rating in categories
|
Software Engineer
8.1k
salaries
|  ₹3.8 L/yr - ₹12 L/yr |
|
Senior Software Engineer
7.3k
salaries
| ₹6.1 L/yr - ₹23 L/yr |
|
Lead Analyst
3.1k
salaries
| ₹10 L/yr - ₹31.5 L/yr |
|
Associate Software Engineer
1.9k
salaries
| ₹2.5 L/yr - ₹7 L/yr |
|
Senior Test Engineer
1.2k
salaries
| ₹6 L/yr - ₹21.3 L/yr |
Accenture
Wipro
Cognizant
Capgemini
- Home >
- Interviews >
- CGI Group Interview Questions >
- CGI Group ETL Developer Interview Questions for Experienced
