Informatica IDMC Developer

Location:

Weehawken, NJ (Onsite – 5 days/week)

Salary Range:

Competitive based on experience and qualifications

Introduction

The role involves designing, building, and supporting enterprise data integration solutions using Informatica Data Management Cloud (IDMC) and Intelligent Cloud Services (IICS). The focus is on ETL/ELT pipelines, data quality, and governance across cloud and on-prem environments, supporting data warehousing and analytics initiatives.

Required Skills & Qualifications

• Strong hands-on experience with IDMC, IICS (PowerCenter a plus)
• Advanced SQL / PL-SQL; experience with Oracle, SQL Server
• Experience with AWS, Azure, or GCP
• ETL/ELT, data warehousing, data modeling concepts
• Experience with CSV, JSON, Parquet, error handling, and transformations
• Strong analytical, troubleshooting, and communication skills
• Prior work experience at client or in client's Industry
• Applicants must be able to work directly for Artech on W2

Preferred Skills & Qualifications

• Informatica MDM (Master Data Management)
• Experience with modern ETL frameworks and migration projects
• Experience with data ingestion and replication solutions

Day-to-Day Responsibilities

• Design and develop data integration workflows, mappings, and pipelines using IDMC/IICS
• Build and manage data flows between cloud and on-prem systems (e.g., SAP, Salesforce, Snowflake)
• Implement data profiling, cleansing, and validation using Informatica Data Quality (IDQ)
• Apply data governance standards and policies within IDMC
• Optimize performance of data pipelines and mappings
• Troubleshoot and resolve data integration issues
• Produce clear technical documentation for workflows and processes

Company Benefits & Culture

• Comprehensive health, dental, and vision insurance
• 401(k) with company matching
• Opportunities for professional growth and development

For immediate consideration please click APPLY to begin the screening process with Alex.