Informatica IDMC Developer_ONSITE@Weehawken, NJ_ON W2

Overview

On Site
Depends on Experience
Contract - Independent
Contract - W2

Skills

Extract
Transform
Load
Informatica
Informatica MDM
Informatica PowerCenter
IDQ
Cloud Computing
Replication
PL/SQL
Performance Tuning
ELT
Informatica IDMC

Job Details

Job Title: Informatica IDMC Developer

Work Location & Reporting Address: Weehawken, NJ

Work Mode: Onsite, all 5 days

Contract duration: 12 months

Interview Process (Is face to face required?) Yes

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.

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.