Informatica IDMC Developer

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.

• 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

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.