i
CGI Group
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Campus Placement and was interviewed before Apr 2022. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
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_
I applied via Approached by Company and was interviewed in Aug 2021. There were 3 interview rounds.
Basic Informatica and SQL questions
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
ETL Developers are responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into a data warehouse.
Designing ETL processes to extract data from multiple sources
Transforming data to meet business requirements
Loading data into a data warehouse or other target systems
Developing and maintaining ETL jobs using tools like Informatica, Talend, or SSIS
SCD Type 1 in IICS involves overwriting existing data with new data without maintaining historical changes.
In IICS, use the Mapping Designer to create a mapping that loads data from source to target.
Use a Lookup transformation to check if the record already exists in the target table.
If the record exists, update the existing record with new data using an Update Strategy transformation.
If the record does not exist, inse...
I applied via Job Portal and was interviewed in Sep 2024. There was 1 interview round.
I was interviewed in Jun 2024.
Lookups are used to retrieve related data from another table based on a common key.
Lookups are used in ETL processes to enrich data by adding additional information from a reference table.
They are commonly used to replace codes with corresponding descriptions, such as replacing product IDs with product names.
Lookups can be performed using SQL joins or lookup transformations in ETL tools like Informatica or Talend.
I applied via Campus Placement and was interviewed before Jan 2022. There were 4 interview rounds.
It's an assignment for apti, verbal
I applied via Recruitment Consulltant and was interviewed in Feb 2024. There was 1 interview round.
Filter stage is used in ETL processes to selectively pass or reject data based on specified criteria.
Filter stage helps in removing unwanted data from the input dataset.
It can be used to apply conditions like filtering out duplicate records, selecting specific columns, or excluding certain values.
For example, a filter stage can be used to only pass records where the sales amount is greater than $1000.
Transform stage is used in ETL process to apply business rules, clean and enrich data before loading into target database.
Transform stage is used to apply business rules to the data.
It is used to clean and standardize data before loading into the target database.
Transform stage can also be used to enrich data by combining multiple sources or adding calculated fields.
Examples include converting data types, removing dupl
Sort stage is used in ETL processes to sort data based on specified criteria before loading it into the target system.
Sort stage helps in arranging data in a specific order for better analysis and reporting
It can be used to remove duplicates from data before loading
Sorting can be done based on multiple columns or expressions
Example: Sorting customer data based on their purchase amount before loading into a data warehou
To create a parallel job, use parallel processing techniques to divide tasks into smaller subtasks that can be executed simultaneously.
Identify tasks that can be executed independently and in parallel
Use parallel processing techniques such as multi-threading or distributed computing
Implement parallel job using ETL tools like Informatica or Talend
Monitor and optimize parallel job performance to ensure efficient executio
SCD stands for Slowly Changing Dimension, a technique used in data warehousing to track changes in dimension attributes over time.
SCD is used to maintain historical data in a data warehouse
There are different types of SCDs - Type 1, Type 2, and Type 3
Type 1 SCD overwrites old data with new data
Type 2 SCD creates a new record for each change and maintains history
Type 3 SCD keeps a limited history by adding columns to tr
I applied via LinkedIn and was interviewed in Aug 2022. There was 1 interview round.
based on 2 reviews
Rating in categories
Software Engineer
8k
salaries
| ₹3.8 L/yr - ₹13.5 L/yr |
Senior Software Engineer
7.1k
salaries
| ₹6 L/yr - ₹22 L/yr |
Lead Analyst
3k
salaries
| ₹9.9 L/yr - ₹29 L/yr |
Associate Software Engineer
1.8k
salaries
| ₹2.5 L/yr - ₹6.8 L/yr |
Senior Test Engineer
1.2k
salaries
| ₹6 L/yr - ₹20.2 L/yr |
TCS
Infosys
Wipro
HCLTech