Overview
Skills
Job Details
Onsite role Urgent client needs Informatica IDMC Developer
Informatica IDMC Developer
New York, NY 10001/Weehawken, NJ - Onsite, all 5 days
12 Months
Detailed Job Description:
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.
Minimum years of experience: 10 years