BNP Paribas Informatica Developer Interview Questions, Process, and Tips

I am an experienced Informatica Developer with expertise in ETL processes, data integration, and data warehousing.

• Developing ETL mappings using Informatica PowerCenter

• Designing and implementing data integration solutions

• Optimizing performance of ETL processes

• Troubleshooting and resolving data quality issues

• Collaborating with business analysts and stakeholders to gather requirements

I have worked on various types of transformations including Aggregator, Expression, Filter, Joiner, Lookup, Router, and Sorter.

• Aggregator transformation for performing calculations on groups of data

• Expression transformation for performing calculations and manipulating data

• Filter transformation for filtering out unwanted data

• Joiner transformation for joining data from multiple sources

• Lookup transformation for retrieving...read more

Sorter can be active or inactive depending on the configuration.

• Sorter transformation can be configured to be active or passive.

• If active, it sorts the data based on specified criteria.

• If passive, it passes the data through without sorting.

• Sorter can be used to remove duplicates from data.

• Sorter can also be used to sort data in ascending or descending order.

Update strategy is a transformation used to flag rows for insert, update, delete or reject.

• Update strategy is used to control the flow of data in a mapping.

• It is used to flag rows for insert, update, delete or reject.

• It can be used to update a target table based on a source table.

• It can be used to insert new rows into a target table.

• It can be used to delete rows from a target table.

• It can be used to reject rows that do

Caches are temporary storage areas that hold frequently accessed data for quick access.

• There are several types of caches including CPU cache, disk cache, browser cache, and DNS cache.

• CPU cache stores frequently accessed data from RAM for faster access.

• Disk cache stores frequently accessed data from hard disk for faster access.

• Browser cache stores frequently accessed web pages, images, and other resources for faster loa...read more

If we don't specify anything in group by aggregator, it will return the result without any grouping.

• The result will contain all the rows from the input without any aggregation.

• The output will have the same number of rows as the input.

• No grouping will be performed on any column.

• The output will be similar to a select statement without a group by clause.