Negotiable
Outside
Remote
USA
Summary: The Cloud Services Developer role involves working with Informatica PowerCenter to manage and migrate data within the City of Philadelphia's cloud infrastructure. The position requires the creation and verification of Informatica mappings and the setup of test servers, focusing on ETL processes. This is a remote position for a duration of 5 months, emphasizing both technical skills and the ability to train others. The role is classified as outside IR35.
Key Responsibilities:
- 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,
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).
Salary (Rate): undetermined
City: Philadelphia
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
- 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,
- 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