Avirupa Chakraborty

• Used informatica PowerCenter for (ETL) extraction transformation and loading data from heterogenous source systems into target database.

• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

• Involved in extracting the data from flat files and relational databases into staging area.

• Developed informatica mappings and reusable transformations to facilitate timely loading of data of a schema.

• Implemented slowly changing dimension to maintain current information and history information in warehouse tables.

• Developed mapplets that were used in other mappings.

• Extensively worked on performance tuning for optimization at source, target and mapping level.

• Used Teradata as a source system.

• Wrote and optimized in-application SQL statements.

• Mentored junior developers on best practices in ETL development, fostering a culture of continuous learning within the team.

• Acquired some knowledge on informatica intelligent cloud services (IICS) and performed development using the same.

• Developed ETL programs using informatica to implement the business requirement.

• Communicated with business customers to discuss the issues and requirements and fixed invalid mappings and fixed issues of the database.

• Effectively used parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

• Involved in enhancements and maintenance activities of data warehouse including physicalizing, modification of stored procedures for code enhancements.

• Developed informatica mappings by using Aggregator, SQL overrides using Lookups, source filter usage in source qualifiers and data flow management into multiple targets using router.

• Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.

• Created adhoc reports for Business Unit in Tableau by connecting various data sources.

• Deployed tableau dashboards and worksheets in clustered environment.

• Generated Tableau dashboards with global filters parameters and calculated fields on Tableau Reports .

• Resolved complex technical issues through effective problem-solving techniques and root cause analysis.