Informatica IDMC & Salesforce Data Integration Engineer

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

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.