The resource will support the Informatica PowerCenter 8.1.1 migration to IDMC cloud solution.

Work activities:

· Informatica 8.1.1 (current)

o Backup the Informatica version 8.1.1 Repository.

· Set up test server

o Use image production server to establish test server.

o Create informatica mappings on cloud platform.

· Cleanup

o Cleanup on IDMC server.

o Creation of the meta data on the IDMC server.

o Incorporate all current sequence ids from Production into Test Repository.

o Verify the Migrated Repository,

Skills/experience:

Required

• Knowledge of Informatica PowerCenter.

• Experience in Informatica PowerCenter upgrade migration.

• Experience in Informatica PowerCenter software installation - Multiple versions.

• Ability to spec out hardware requirements.

• Experience in developing ETL processes end-to-end in Informatica.

• Knowledge of data modeling, transformations, Mappings, Workflows.

• Ability to apply best practices to ETL development, testing, scheduling, and monitoring.

• Knowledge of SQL (standard).

• Ability to provide training to the City's Informatica PowerCenter administrator/developers(s).

Highly Desired/Preferred

• Experience in older versions of Informatica PowerCenter such as 8.1.1.

• Informatica Certified Professional.

• Experience with performance tuning.

This is a remote position.