What are the responsibilities and job description for the Informatica IDMC Developer_ONSITE@Weehawken, NJ_ON W2 position at BURGEON IT SERVICES LLC?
Job Details
Job Title: Informatica IDMC Developer
Work Location & Reporting Address: Weehawken, NJ
Work Mode: Onsite, all 5 days
Contract duration: 12 months
Interview Process (Is face to face required?) Yes
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/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.