Informatica Admin  

- Understand the business requirement or the downstream process requirement
- Deliver Informatica PowerCenter solution implementation and support
- Provide impact analysis whenever there are any changes and production events happen that may affect MDM
- Work with Data Mapper and Data modeler to define the dataflow and implement the ETL to fulfill the requirement
- Monitor throughout the project delivery life cycle in order to manage the scope, schedule, and cost for IT projects
- Ensure development guide and best practice for developing PowerCenter solutions are followed
- Review functional and technical specifications prepared by vendors
- Review test scope, test approach, and test strategies
- Manage defects closing during the SIT and UAT
- Liaise with infrastructure team on nonproduction and production infrastructure and environments
- Maintain the application domain knowledge for PowerCenter, drive the team to maintain awareness of technology trends to ensure the delivery of best practices.

Primary skills:
Informatica – IDR
PET/PROD ODS Architecture must be known – this is project/company specific – this need to explained one time for any new person
- knowledge on shell Scripting is must
- HF tool can be taught by team

Informatica DATA replication (IDR) Software Knowledge
- Knowledge on creation of replication Configuration
- replication Schedule creation and investigation of replication issues
- Monitoring the IDR Schedules
- Knowledge on TCL Scripting – needed in Migration of tables
- Knowledge on IDR upgrade

Informatica – PowerCenter
- Informatica Service creation
o repository service which hold actual Workflow/components
o Integration Service which connect ETL scripts to repository
- investigation while creation of Repository services /Domain / Workflow execution
- user + role - creation and Management

Cognos Setup
- user+ Role - creation and management
- Cognos Upgrades
- Data Source Creation and Maintenance
- Packages Export / Import knowledge

secondary skill
- Knowledge of Oracle and SQL
- Linux OS knowledge