Position Title: Cloud Services Developer
End Date of Current Term of Contract: December , The resource(s) covered under this SO will support the : Informatica PowerCenter migration to IDMC cloud solution. Position overview / Statement of Work This resource will support the migration activities from power center to cloud . Work activities:
- Informatica (current) Backup the Informatica version Repository.
up test server
- Use image production server to establish test server.
- Create informatica mappings on cloud platform.
.Cleanup
- 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,
Skills/experience of the assigned staff:
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
- Informatica Certified Professional.
- Experience with performance tuning.
Expected duration: Months Additional Background and On-Boarding Details
Item Response Is this SO for a new position? Yes Is an onsite interview a must or is the hiring manager open to screening over a Skype (or other) video call for out of state candidates? Video is fine How many interview rounds will be conducted for the position? - Is there a chance of extension in the duration of the assignment, beyond the budget/duration included in the SO? Yes Will the position require the candidate to be onsite completely or there is a possibility of working remotely (partially/completely)? Full Remote/Hybrid options Can a vendor suggest a different Resource Title based on the position and budget assigned to that position, if the position requires a niche skill? Yes
Start Date (estimated)
//
End Date
//
The location for the position is:
City of Philadelphia
Office of Innovation & Technology
Market Street.
Philadelphia, PA