Roles/Responsibilities:
Should be well versed with following Informatica PowerCenter Clients tool set
o Informatica PowerCenter Designer - Mapping Development
o Informatica PowerCenter Workflow Manager Workflow Development
o Informatica PowerCenter Workflow Monitor Job Monitoring
o Informatica PowerCenter Repository Manager Building Code Deployment Queries
o Good exposure of Informatica Command line utilities such as pmcmd, pmrep, etc.
Perform detail design, development, documentation, debugging and implementation of solutions for Informatica ETL requirements.
Should have strong skills on ETL design patterns and data architecture, UNIX and Oracle, DB2, Teradata, Netezza, SQL Server
To provide end to end ETL Design solutions and support Architecture in defining strategies. Leading team of designers and developers
To understand the overall purpose of the projects and contribute to requirements & data analysis, and provide solutions from an ETL perspective
Delivery of low level design documents with ETL & DWH strategy, standards and adhering to ETL & BIW principles & policies.
Strong understanding of ETL, Application Data Integration, DWH and Report designs with functional and non-functional assessment for global implementations.
Identify data source for different type of Customer data and analyze applications / system data
Able to design end to end ETL solution for complex case studies.
Working knowledge of at least one Job scheduler tool.
Identify data source for different type of Customer data and analyze applications / system data.