Informatica IDMC Developer

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

IDMC
IICS
Informatica PowerCenter
SQL
PL/SQL
AWS
Azure
GCP
ETL
SV
JSON
Parquet

Job Details

Job Title: Informatica IDMC Developer
Work Location & Reporting Address: Weehawken, NJ Need local candidates or nearby cities, as there will be an in-person interview.
Work Mode: Onsite, all 5 days

Contract duration: 12 months

Interview Process: Face-to-face (In-Person)


Detailed Job Description:
Role: Informatica IDMC Developer designs, builds, and maintains data integration solutions using Informatica Data Management Cloud (IDMC) and Intelligent Cloud Services (IICS), focusing on ETL/ELT pipelines, data quality, and governance across cloud/on-prem systems, requiring strong SQL, cloud platform knowledge (AWS/Azure/Google Cloud Platform), and skills in data modeling, transformations, and troubleshooting data issues for data warehousing and analytics.

Key Responsibilities:
Design & Develop: Create data integration workflows, mappings, and pipelines using IICS/IDMC for data ingestion, transformation, and loading.
Cloud Integration: Connect and manage data flow between cloud and on-premises applications, potentially with SAP, Salesforce, Snowflake.
Data Quality: Implement data profiling, cleansing, and validation rules using Informatica Data Quality (IDQ).
Governance: Apply data governance policies and standards within IDMC.
Performance Tuning: Optimize data workflows and mappings for efficiency.
Troubleshooting: Debug and resolve data pipeline issues.
Documentation: Create technical documentation for processes and workflows.

Required Skills & Qualifications:
Informatica: Strong experience with IDMC, IICS, and potentially Informatica PowerCenter.
Databases: Proficiency in SQL, PL/SQL, and working with databases (Oracle, SQL Server).
Cloud: Familiarity with cloud platforms (AWS, Azure, Google Cloud Platform).
Data Concepts: Understanding of data warehousing, data modeling, and ETL principles.
Technical Skills: Experience with file formats (CSV, JSON, Parquet) and error handling.
Soft Skills: Analytical, problem-solving, and communication skills; ability to work in teams.
Preferred Experience:
Experience with Informatica MDM (Master Data Management).
Knowledge of modern ETL frameworks and migration projects.
Experience with data ingestion and replication.

Minimum years of experience: 10 years
Certifications Needed: Optional

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Epic Systems, Inc,