Informatica IDMC Developer

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.