Informatica Developer – Contract (Remote in Central, NY)

Job Description

Please no 3rd parties or C2C.

Must be a US Permanent Resident or Citizen.

We are unable to sponsor currently.

Candidates must be able to work directly on a W-2 basis.

Job Title: Informatica Developer Location: Primarily Remote – Upstate New York Job Type: Long-Term Contract (Approximately 18 Months)
Pay Rate: $40–$45/hr depending on experience
Schedule: Monday–Friday, standard business hours with rotating on-call responsibilities

About the Role

We are seeking an experienced Informatica Developer to join an established enterprise Data Solutions team within a large healthcare organization. This long-term contract opportunity focuses on developing, maintaining, enhancing, and supporting enterprise data integration solutions using Informatica PowerCenter, Informatica Cloud Data Integration (CDI/IDMC), SQL, and PL/SQL.

The Informatica Developer will be responsible for both new development and ongoing production support, including troubleshooting complex ETL workflows, optimizing existing processes, and supporting modernization initiatives. The ideal candidate will have strong hands-on Informatica development experience, solid database programming skills, and the ability to work independently in a complex enterprise IT environment.

This position offers a primarily remote work arrangement for candidates residing in Upstate New York, with occasional in-person meetings as business needs require.

Key Responsibilities

• Design, develop, test, maintain, and enhance enterprise ETL processes using Informatica PowerCenter and Informatica CDI/IDMC.

• Develop, troubleshoot, and optimize SQL and PL/SQL queries, stored procedures, scripts, and data transformation processes.

• Build and maintain integrations between enterprise applications, relational databases, and data warehouse environments.

• Support existing ETL applications and workflows, including enhancements, defect resolution, and technical debt reduction.

• Monitor scheduled data integration processes, investigate workflow failures, and resolve production incidents.

• Perform root-cause analysis and implement corrective actions to improve system reliability and performance.

• Develop and maintain XML parsing and data processing solutions.

• Utilize Azure DevOps for work item tracking, defect management, deployment activities, and development coordination.

• Manage source code changes using Git repositories and established version control practices.

• Collaborate with developers, business analysts, and internal stakeholders to translate requirements into effective data integration solutions.

• Participate in Agile development activities, including sprint planning, testing, documentation, code reviews, and deployments.

• Support application performance tuning, troubleshooting, and continuous improvement initiatives.

• Participate in a rotating after-hours on-call schedule to support business-critical production systems following appropriate onboarding and training.

Qualifications

Education

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field preferred.

• Equivalent combinations of education and relevant professional experience will be considered.

Experience

• Approximately 3+ years of professional experience in ETL development, enterprise data integration, or related software development.

• Demonstrated hands-on experience developing and supporting Informatica ETL workflows.

• Experience troubleshooting production data integration issues and supporting enterprise applications.

• Experience working with relational databases and enterprise data warehouse environments.

• Previous experience in healthcare, health insurance, or other highly regulated industries is preferred.

• Experience working in Agile/Scrum development environments is preferred.

Technical Skills

Required:

• Strong hands-on development experience with Informatica PowerCenter.

• Experience with Informatica Cloud Data Integration (CDI/IDMC).

• Proficiency in SQL and PL/SQL development, troubleshooting, and performance optimization.

• Experience designing, building, testing, and maintaining ETL workflows and data transformation processes.

• Working knowledge of Azure DevOps, including work items, deployment pipelines, and Git repositories.

• Experience with relational databases, data integration concepts, and data warehouse architecture.

• Experience with XML parsing and data processing.

• Ability to diagnose and resolve complex technical and production support issues.

Preferred:

• Experience with Informatica PowerExchange and Change Data Capture (CDC).

• Experience with Oracle, Microsoft SQL Server, or similar enterprise database platforms.

• Knowledge of UNIX/Linux operating systems and shell scripting.

• Experience with Informatica administration, environment monitoring, and performance tuning.

• Familiarity with healthcare data integration, regulatory requirements, and government-sponsored healthcare programs.

Certifications

• Relevant Informatica certifications are preferred but not required.

• Additional database, cloud integration, or data engineering certifications are beneficial.

Soft Skills

• Strong analytical, troubleshooting, and problem-solving abilities.

• Ability to work independently with minimal technical oversight.

• Effective written and verbal communication skills.

• Strong attention to detail and commitment to data accuracy and reliability.

• Ability to manage competing priorities in a production-focused enterprise environment.

• Collaborative approach to working with technical teams, business analysts, and stakeholders.

• Strong documentation, organizational, and time-management skills.

Work Environment & Schedule

• Work Arrangement: Primarily remote, with occasional in-person meetings at an Upstate New York office location.

• Work Schedule: Monday–Friday during standard business hours.

• On-Call Responsibilities: Approximately one week per month on a rotating schedule, supporting production incidents, batch processing failures, and other critical technical issues.

• Team Structure: Established enterprise Data Solutions team operating within an Agile development environment using two-week sprints.

• Contract Duration: Approximately 18 months, subject to business needs.

Why Join Us?

This opportunity provides the chance to contribute to business-critical data integration solutions within a large, established healthcare organization. The Informatica Developer will work with both traditional and cloud-based Informatica technologies while supporting enterprise data processing, system enhancements, and modernization initiatives.

The position offers a primarily remote schedule, a collaborative technical team, and exposure to complex enterprise systems. It is an excellent opportunity for an experienced developer seeking a long-term engagement with a balance of hands-on development, technical problem-solving, and production support.

ISSI Technology Professionals celebrates diversity. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.