Informatica Developer

Apex Systems; Pennington (NJ); On-site; USD 105,000 - 150,000; Full time

Benefits offered by this job

ESPP

401K

Health insurance

HSA

Employee Assistance Program

Job summary

Everforth Apex Systems is seeking an Informatica Developer to design, develop, and support cloud-based data integration and MDM solutions between Salesforce and enterprise systems. The role emphasizes data quality, governance, and scalable integration using IDMC and PowerCenter.

You will work with stakeholders, architects, and Agile teams to translate requirements into secure, reliable solutions and help optimize data flows across landscapes.

Qualifications

• 5+ years of Software Development Lifecycle analysis experience.
• 5+ years of Informatica ETL development experience using PowerCenter 10.x and PowerExchange or Informatica Cloud (IDMC).
• 5+ years of experience with ETL tuning and performance.
• 5+ years of UNIX shell scripting.
• 4+ years of strong SQL experience with relational databases.
• 3+ years of experience with Autosys.
• 1-2 years of Salesforce integration experience.

Responsibilities

• Design, develop, and implement Salesforce integrations using Informatica IDMC, including Data Integration.
• Gather and analyze business, data, and integration requirements, translating them into technical solutions aligned with enterprise architecture standards.
• Implement cloud-based data integration solutions across Salesforce and downstream/upstream systems, ensuring reliability and scalability.
• Investigate, analyze, and resolve data quality issues such as inaccuracies, duplicates, and incompleteness.
• Support Agile implementation teams throughout the development lifecycle, including planning, development, testing, and deployments.
• Develop and support Informatica mappings and workflows to move, transform, and synchronize data between Salesforce and enterprise databases.
• Perform debugging, troubleshooting, enhancements, unit testing, and performance optimization of integration and MDM solutions.
• Write and execute complex queries to validate data, support analysis, and ensure data is accessible, consistent, and performant.
• Ensure solutions comply with data governance, security, and compliance requirements, especially in a cloud-based IDMC environment.
• Build and maintain MDM mappings, hierarchies, match/merge rules, and integration pipelines to support master and reference data use cases.

Skills

Informatica ETL

UNIX shell scripting

SQL

Salesforce integration

SDLC analysis

ETL tuning

IDMC

Tools

PowerCenter

PowerExchange

IDMC

Job description

Job#: 3044841

Job Description

Informatica Developer

Location

Pennington, New Jersey (Onsite)

Role Overview

The Informatica Developer is responsible for designing, developing, and supporting cloud-based data integration and master data management solutions between Salesforce and enterprise systems. This role ensures high-quality, trusted, and governed data flows using PowerCenter/Informatica Intelligent Data Management Cloud (IDMC), including MDM, Data Integration, and data quality components. The developer works with business stakeholders, architects, and Agile delivery teams to translate business and data requirements into scalable and secure integration solutions.

Key Responsibilities

• Design, develop, and implement Salesforce integrations using Informatica IDMC, including Data Integration.
• Gather and analyze business, data, and integration requirements, translating them into technical solutions aligned with enterprise architecture standards.
• Implement cloud-based data integration solutions across Salesforce and downstream/upstream systems, ensuring reliability and scalability.
• Investigate, analyze, and resolve data quality issues such as inaccuracies, duplicates, and incompleteness.
• Support Agile implementation teams throughout the development lifecycle, including planning, development, testing, and deployments.
• Develop and support Informatica mappings and workflows to move, transform, and synchronize data between Salesforce and enterprise databases.
• Perform debugging, troubleshooting, enhancements, unit testing, and performance optimization of integration and MDM solutions.
• Write and execute complex queries to validate data, support analysis, and ensure data is accessible, consistent, and performant.
• Ensure solutions comply with data governance, security, and compliance requirements, especially in a cloud-based IDMC environment.
• Build and maintain MDM mappings, hierarchies, match/merge rules, and integration pipelines to support master and reference data use cases.

Required Qualifications

• 5+ years of Software Development Lifecycle analysis experience.
• 5+ years of Informatica ETL development experience using PowerCenter 10.x and PowerExchange or Informatica Cloud (IDMC).
• 5+ years of experience with ETL tuning and performance.
• 5+ years of experience with UNIX shell scripting.
• 4+ years of strong SQL experience with relational databases.
• 3+ years of experience with Autosys.
• 1-2 years of Salesforce integration experience.

Preferred Qualifications

• Experience with PowerCenter to IDMC Migration.
• Proficiency with Salesforce.

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Everforth Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Everforth Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our ‘Welcome Packet’ as well, which an Everforth Apex team member can provide.

Everforth Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.

If you require an accommodation under the Americans with Disabilities Act to participate in an interview with a virtual recruiter or to use our website for a search or application, please contact our Benefits Department at [email protected] or 804-523-8228. Please note that this contact information is strictly to be used for medical ADA accommodations and that no other inquiries will be answered.

UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Apex Systems.

© 2026 Everforth, Inc. All rights reserved.

Everforth Apex Systems is part of the Commercial Segment of Everforth, Inc.

NYSE: EFOR

4400 Cox Road

Suite 200

Glen Allen, Virginia 23060

Everforth Apex is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.