Informatica IDMC Developer

APN Healthcare Solutions

Weehawken, NJ, United States

6 days ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Working hours

Regular working hours

Job source

www2.jobdiva.com

Tech stack

Amazon Web Services Microsoft Azure Cloud Computing Databases Data Governance Data Integration Extract Transform Load (ETL) Data Profiling Data Warehousing Software Debugging JSON Microsoft SQL Server

+19 more

Oracle (Applications) Performance Tuning Cloud Services Standard Sql Salesforce.Com SAP (Applications) Simple Data Format PL-SQL SQL Databases Data Streaming Parquet Google Cloud Cloud Platform System Data Ingestion Informatica Powercenter Snowflake Data Management Cloud Integration Data Pipelines

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/GCP), and skills in data modeling, transformations, and troubleshooting data issues for data warehousing and analytics., * 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.

Requirements

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, GCP).
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 Interview Process (Is face to face required?) Yes

About the company

APN Consulting, Inc. is a progressive IT staffing and services company offering innovative business solutions to improve client business outcomes. We focus on high impact technology solutions in ServiceNow, Fullstack, Cloud & Data, and AI / ML. Due to our globally expanding service offerings we are seeking top-talent to join our teams and grow with us.