What are the responsibilities and job description for the Informatica IDMC Developer position at Ampstek?
Position: Informatica IDMC Developer
Location: Weehawken, NJ (Onsite)
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
Certifications Needed: Optional
Thank You
Aakash Dubey
Talent Acquisition Lead
Aakash.dubey@ampstek.com