Informatica IDMC DeveloperLocation: Weehawken, NJ Experience: 10+ Duration: 12 MonthsRole: 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.