Informatica IDMC Developer

APN consulting Group

Weehawken, NJ

JOB DETAILS
JOB TYPE
Contractor
SKILLS
Amazon Web Services (AWS), Analysis Skills, Artificial Intelligence (AI), Business Solutions, Cloud Computing, Communication Skills, Consulting, Data Analysis, Data Management, Data Modeling, Data Profiling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Error Handling, GCP (Good Clinical Practices), Identify Issues, Informatica, JSON, Master Data Management (MDM), Microsoft SQL Server, Microsoft Windows Azure, Oracle Database, Oracle PL-SQL, Performance Tuning/Optimization, Problem Solving Skills, Process Improvement, SAP, SQL (Structured Query Language), Salesforce.com, ServiceNow, Snowflake Schema, Team Player, Technical Recruiting, Technical Writing
LOCATION
Weehawken, NJ
POSTED
30+ days ago
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. Job Title: Informatica IDMC Developer Work Location & Reporting Address: Weehawken, NJ Work Mode: Onsite, all 5 days Contract duration: 12 months 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/GCP), 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, 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 We are committed to fostering a diverse, inclusive, and equitable workplace where individuals from all backgrounds feel valued and empowered to contribute their unique perspectives. We strongly encourage applications from candidates of all genders, races, ethnicities, abilities, and experiences to join our team and help us build a culture of belonging.

About the Company

A

APN consulting Group