Match score not available

Unlock Premium Benefits Today!
🚀 Elevate your career with priority access.
Stand out to top recruiters with Jobgether Priority Access:
  • ✅ Top Match: We help you identify job offers where you're a perfect fit.
  • ✅ Exclusive Referral Service: Connect directly with recruiters as a Jobgether Certified Premium User.
  • ✅ Personalized Feedback: Receive feedback and expert guidance on applications, and have your profile manually reviewed.

Start Your Free Trial Now!

Start my free trial

Informatica Migration/Upgrade Developer

Remote: 
Full Remote
Work from: 
United States

Offer summary

Qualifications:

Knowledge of Informatica PowerCenter, Experience in upgrade migration and software installation, Ability to spec hardware requirements, Experience in end-to-end ETL processes development, Knowledge of SQL and data modeling.

Key responsabilities:

  • Migrate Informatica PowerCenter to version 10.5
  • Set up test server if applicable
  • Provide training to City staff post successful migration
  • Coordinate with various software versions and hardware specs
  • Ensure data transformations, mappings, workflows align with best practices
Tri-Force Consulting Services logo
Tri-Force Consulting Services Information Technology & Services SME https://triforce-inc.com/
51 - 200 Employees
About Tri-Force Consulting Services
Tri-Force is a leading provider of cloud technology solutions, as well as innovative and cost-effective software development (web and mobile apps), systems integration, data analytics, systems automation, cybersecurity, IT Staffing (Contract, Contract-to-Hire, and Full-time placement), and IT Staffing (Contract, Contract-to-Hire, and Full-time placement). Tri-Force serves commercial industry sectors as well as government agencies. Clients often come to Tri-Force for assistance with difficult problems, such as increasing productivity or efficiencies through the use of automation or lowering costs. Integrity, diligence, and technological superiority are the three core values that set us apart from the other companies in our industry, and they all benefit our customers. Innovative cloud-based software as a service (SaaS) products like MLeads, SecureEventz, EventsAnywhere, and MyShaleWell have been developed by Tri-Force. In order to better assist small and medium-sized businesses and new ventures, Tri-Force has opened a software development delivery center in India. Tri-Force has a track record of success working with clients from the Department of Defense (DoD), other government agencies (non-DoD), state government agencies, and local city government agencies. EMSDC, the City of Philadelphia, New York City, Wilmington, the Port Authority of New York and New Jersey, the State of Pennsylvania, New Jersey, New York, Delaware, and the State of Virginia have all recognized Tri-Force as a certified Minority Business Enterprise. In order to work with various agencies, Tri-Force is in possession of both GWACs and state- and city-specific government contracts. Tri-Force has developed relationships with authorized resellers as well as partnerships with solution providers in the field of cybersecurity technology in order to acquire hardware and software products on behalf of its clients. Tri-Force has been recognized as the fastest-growing company in Philadelphia.
See more Tri-Force Consulting Services offers

Job description

This is a remote position.

Name of position: Informatica Migration/Upgrade Developer
Note: its remote position

client name: City of Philadelphia


job description

Migrate our outdated version of Informatica Power Center through various versions of the software until we reach version 10.5.
This will require hardware specs to build the virtual servers, software installation of each needed version between 8.1.1 to 10.5. Migration of the Informatica objects, workflows, worklets, task, etc. to each subsequent version.
If necessary, successfully testing each migration.
After successfully migrating to version 10.5, providing knowledge transfer to City 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 City with hardware specs to build virtual servers for software.
• Install PowerCenter 8.6.1 Components Client and ODBC on new Windows 2019 (2022) server.
• Install PowerCenter 8.6.1 Repository server on new Windows 2019 (2022) server.
• Configure PowerCenter 8.6.1 Informatica server on new Windows 2019 (2022) server.
• Upgrade the Repository on new Windows 2019 (2022) server.
• Verify the upgraded Repository.
• Run Test with new software version and new repository.
3. Informatica 9.5.1
• Provide City with hardware specs to build virtual servers for software.
• Install PowerCenter 9.5.1 Components Client and ODBC on new Windows 2019 (2022) server.
• Install PowerCenter 9.5.1 Repository server on new Windows 2019 (2022) server.
• Configure PowerCenter 9.5.1 Informatica server on new Windows 2019 (2022) server.
• Upgrade the Repository on new Windows 2019 (2022) server.
• Verify the upgraded Repository.
• Run Test with new software version and new repository.
4. Informatica 9.6.1
• Provide City with hardware specs to build virtual servers for software.
• Install PowerCenter 9.6.1 Components Client and ODBC on new Windows 2019 (2022) server.
• Install PowerCenter 9.6.1 Repository server on new Windows 2019 (2022) server.
• Configure PowerCenter 9.6.1 Informatica server on new Windows 2019 (2022) server.
• Upgrade the Repository on new Windows 2019 (2022) server.
• Verify the upgraded Repository.
• Run Test with new software version and new repository.
5. Informatica 10.5
• Provide City with hardware specs to build virtual servers for software.
• Install PowerCenter 10.5 Components Client and ODBC on new Windows 2019 (2022) server.
• Install PowerCenter 10.5 Repository server on new Windows 2019 (2022) server.
• Configure PowerCenter 10.5 Informatica server on new Windows 2019 (2022) server.
• Upgrade the Repository on new Windows 2019 (2022) server.
• Verify the upgraded Repository.
• Run Test with new software version and new repository.
6. Set up test server.
• If possible, use image production server to establish test server.
• If not, repeat steps 2 through 5 for test server.
7. Cleanup
• Incorporate all current sequence ids from Production into Test Repository
• Migrate Repository from Production to Test. Connecting to New Repository Database.
• Verify the Migrated Repository
• Uninstall old Informatica software new Windows 2019 (2022) server

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

"If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why you think you are a fit."

About Us:
Tri-Force is one of the fastest growing companies in Philadelphia region by receiving the award 5 times and 3 times(Ranked #931 2021) on Inc. 5000 fastest growing companies in the USA. Tri-Force Consulting Services, Inc. is an established consulting services firm offering innovative solutions to Government and Commercial sectors. We specialize in building customized software applications solutions such as knowledge management systems, business intelligence, data analysis, database support and maintenance, data warehouse implementation and support, systems architecture and systems integration for our clients. Our technical competencies are in Java,.NET, SharePoint, PHP, Business Intelligence (Cog nos, Data Warehouse), mobile applications platforms (iPhone, iPad, Android, Blackberry), and various other technologies. We also specialize in providing resources to manage infrastructure projects.  Tri-Force is one of the fastest growing companies in the Philadelphia region by receiving the award 5 times and 2 times on Inc. 5000 fastest growing companies in the USA.


Required profile

Experience

Industry :
Information Technology & Services
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Hard Skills

Process DevelopmentData ModelingInformatica PowercenterSQL (Programming Language)Performance Tuning

Other Skills

  • Open Mindset
  • Verbal Communication Skills
  • Leadership
Are you interested?

Related jobs

See more jobs
Sign in or sign up with Google or LinkedIn