Informatica IDMC & Salesforce Data Integration Engineer

Apex Systems; New Jersey; On-site; USD 180,521,000 - 194,848,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401K with company match

ESPP (employee stock purchase)

Job summary

Everforth Apex Systems seeks an Informatica Developer to design, develop, and support cloud-based data integration and MDM solutions between Salesforce and enterprise systems. You will work with business stakeholders and Agile teams to translate requirements into scalable, governed data flows using IDMC and PowerCenter.

The role requires 5+ years in ETL/SDLC with Informatica, UNIX scripting, SQL, Autosys, and Salesforce integration.

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.

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.
• Implement cloud-based data integration solutions across Salesforce and downstream/upstream systems.
• Investigate, analyze, and resolve data quality issues such as inaccuracies and duplicates.
• Support Agile implementation teams throughout the development lifecycle.
• Develop and support Informatica mappings and workflows to move, transform, and synchronize data.
• Perform debugging, troubleshooting, enhancements, unit testing, and performance optimization.
• Write and execute complex queries to validate data and ensure accessibility and consistency.
• Ensure solutions comply with data governance, security, and compliance requirements.

Skills

Informatica ETL development

UNIX shell scripting

SQL

Autosys

Salesforce integration

SDLC analysis

Tools

PowerCenter

PowerExchange

Informatica IDMC

Job description

Everforth Apex Systems seeks an Informatica Developer to design, develop, and support cloud-based data integration and MDM solutions between Salesforce and enterprise systems. You will work with business stakeholders and Agile teams to translate requirements into scalable, governed data flows using IDMC and PowerCenter.

The role requires 5+ years in ETL/SDLC with Informatica, UNIX scripting, SQL, Autosys, and Salesforce integration.