Akkodis is seeking an Informatica Migration/Upgrade Developer for a contract position with a client located in Philadelphia, PA (Remote to start, but can be hybrid in the future).
Pay Range: $75-$85/hr, The rate may be negotiable based on experience, education, geographic location, and other factors
Need candidates local or nearby Philadelphia, PA only.
Job Description:
The resource(s) covered under this SO will support the Informatica PowerCenter 8.1.1 migration to the PowerCenter 10.5 project
Position Overview / Statement of Work
Migrate our outdated version of Informatica PowerCenter through various versions of the software until we reach version 10.5. This will require hardware specs to build the virtual servers and software installation of each needed version between 8.1.1 to 10.5. Migration of the Informatica objects, workflows, worklets, tasks, etc. to each subsequent version. If necessary, successfully test each migration. After successfully migrating to version 10.5, providing knowledge transfer to staff responsible for maintaining the software.
Work activities:
1. Informatica 8.1.1 (current)
• Backup the Informatica version 8.1.1 Repository.
2. Informatica 8.6.1
• Provide hardware specs to build virtual servers for software.
• Install PowerCenter 8.6.1 Components Client and ODBC on the new Windows 2019 (2022) server.
• Install the PowerCenter 8.6.1 Repository server on the new Windows 2019 (2022) server.
• Configure PowerCenter 8.6.1 Informatica server on the new Windows 2019 (2022) server.
• Upgrade the Repository on the new Windows 2019 (2022) server.
• Verify the upgraded Repository.
• Run Test with new software version and new repository.
3. Informatica 9.5.1
• Provide hardware specs to build virtual servers for software.
• Install PowerCenter 9.5.1 Components Client and ODBC on the new Windows 2019 (2022) server. • Install the PowerCenter 9.5.1 Repository server on the new Windows 2019 (2022) server.
• Configure PowerCenter 9.5.1 Informatica server on the new Windows 2019 (2022) server.
• Upgrade the Repository on the new Windows 2019 (2022) server.
• Verify the upgraded Repository.
• Run Test with new software version and new repository.
4. Informatica 9.6.1
• Provide hardware specs to build virtual servers for software.
• Install PowerCenter 9.6.1 Components Client and ODBC on the new Windows 2019 (2022) server. • Install the PowerCenter 9.6.1 Repository server on the new Windows 2019 (2022) server.
• Configure PowerCenter 9.6.1 Informatica server on the new Windows 2019 (2022) server.
• Upgrade the Repository on the new Windows 2019 (2022) server.
• Verify the upgraded Repository.
• Run Test with new software version and new repository.
5. Informatica 10.5
• Provide hardware specs to build virtual servers for software.
• Install PowerCenter 10.5 Components Client and ODBC on the new Windows 2019 (2022) server.
• Install the PowerCenter 10.5 Repository server on the new Windows 2019 (2022) server.
• Configure PowerCenter 10.5 Informatica server on the new Windows 2019 (2022) server.
• Upgrade the Repository on the new Windows 2019 (2022) server.
• Verify the upgraded Repository.
• Run Test with new software version and new repository.
6. Set up a test server.
• If possible, use an image production server to establish a test server.
• If not, repeat steps 2 through 5 for the test server.
7. Cleanup
• Incorporate all current sequence IDs from Production into Test Repository
• Migrate the Repository from Production to Test. Connecting to New Repository Database.
• Verify the Migrated Repository
• Uninstall old Informatica software and the new Windows 2019 (2022) server.
Skills/experience of the assigned staff resource:
Informatica Developer 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, and Workflows.
• Ability to apply best practices to ETL development, testing, scheduling, and monitoring.
• Knowledge of SQL (standard).
• Ability to provide training to the 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.
If you are interested in this role, then please click APPLY NOW. For other opportunities available at Akkodis, or any questions, please contact Anirudh Srivastava at 610-227-6773 or anirudh.srivastava@akkodisgroup.com.
Equal Opportunity Employer/Veterans/Disabled
Benefit offerings include medical, dental, vision, term life insurance, short-term disability insurance, additional voluntary benefits, commuter benefits, and a 401K plan. Our program provides employees the flexibility to choose the type of coverage that meets their individual needs. Available paid leave may include Paid Sick Leave, where required by law; any other paid leave required by Federal, State, or local law; and Holiday pay upon meeting eligibility criteria.
Disclaimer: These benefit offerings do not apply to client-recruited jobs and jobs that are direct hires to a client.
To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.akkodis.com/en/privacy-policy.