Negotiable
Outside
Remote
USA
Summary: The role of Cloud Services Developer/Informatica PowerCenter ETL Migration Engineer involves migrating and upgrading Informatica PowerCenter systems for the City of Philadelphia. The position requires setting up test servers, creating mappings on cloud platforms, and ensuring the integrity of migrated repositories. The role is remote and focuses on leveraging Informatica's capabilities to enhance ETL processes. Candidates should possess strong knowledge of Informatica PowerCenter and experience in ETL development and migration.
Key Responsibilities:
- Backup the Informatica version 8.1.1 Repository.
- Set up test server using the production server.
- Create Informatica mappings on the cloud platform.
- Perform cleanup on IDMC server.
- Incorporate current sequence IDs from Production into Test Repository.
- Create metadata on the IDMC server.
- Verify the migrated repository.
Key Skills:
- 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).
- Experience in older versions of Informatica PowerCenter such as 8.1.1.
- Informatica Certified Professional.
- Experience with performance tuning.
Salary (Rate): undetermined
City: Philadelphia
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Title: Cloud Services Developer\ Informatica PowerCenter ETL Migration Engineer
Duration: 5 Months
Client: City of Philadelphia
Location: 1234 Market Street, 18th Floor, Philadelphia, PA 19107
Note: Remote role
Work activities:
Informatica 8.1.1 (current)
Backup the Informatica version 8.1.1 Repository.
Set up test server
Use image production server to establish test server.
Create informatica mappings on cloud platform.
Cleanup on IDMC server.
Incorporate all current sequence ids from Production into Test Repository.
Creation of the meta data on the IDMC server.
Verify the Migrated Repository,
Required skills:
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