Description

Key Responsibilities:

 ETL Development: Design, develop, and deploy efficient ETL processes(Mappings and Workflows) using Informatica PowerCenter for various dataintegration and migration tasks.

 Perform complex data transformations, cleansing, standardizing andaggregation operations within the ETL workflows to align data with businessneeds using Informatica transformations.

 Implement data validation and quality checks to ensure the integrity andconsistency of the data being integrated.

 Optimize ETL Mapping, workflows and sessions to improve performance andreduce processing time, ensuring that data loads meet the businessrequirements.

 Develop and manage data mapping, connections, and transformationsbetween various source systems (e.g., relational databases SQL Server, flatfiles, etc.) and target systems (e.g., SQL Server, Snowflake, Flat Files etc.).

 Resolve issues related to ETL processes, data mapping, and transformationlogic.

Debug and monitor sessions for errors and failures.

 Create and maintain technical documentation, including process flowdiagrams, Functional specification document, ETL mappings documents etc.

 Perform unit testing and prepare the Unit Testing documents for all ETLprocesses.

 Experience working with databases like Oracle, SQL Server.

 Should have experience in the Stored Procedures, Functions, writing complexqueries, and optimizing SQL performance.

 Experience in the scripting like Windows PowerShell and batch script.

 Experience in the Scheduling Tool Autosys

Key Skills

Education

Any Gradute