Ampstek ยท 2 days ago
Informatica IDMC Developer
Ampstek is seeking an Informatica IDMC Developer who will design, build, and maintain data integration solutions using Informatica Data Management Cloud (IDMC) and Intelligent Cloud Services (IICS). The role focuses on creating ETL/ELT pipelines, ensuring data quality, and applying governance across cloud and on-prem systems.
IT Management
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
Qualification
Required
Strong experience with IDMC, IICS, and potentially Informatica PowerCenter
Proficiency in SQL, PL/SQL, and working with databases (Oracle, SQL Server)
Familiarity with cloud platforms (AWS, Azure, GCP)
Understanding of data warehousing, data modeling, and ETL principles
Experience with file formats (CSV, JSON, Parquet) and error handling
Analytical, problem-solving, and communication skills; ability to work in teams
Minimum years of experience: 10 years
Preferred
Experience with Informatica MDM (Master Data Management)
Knowledge of modern ETL frameworks and migration projects
Experience with data ingestion and replication
Certifications Needed: Optional