NUCLEUS TECH SOLUTIONS LLC
Cloud Services Developer
NUCLEUS TECH SOLUTIONS LLC, Hyattsville, Maryland, United States, 20780
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.
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.