Description :
Role : IDMC Developer
Job Summary :
We are seeking a highly skilled and experienced IDMC Developer to drive the design, development, and implementation of data integration and data governance solutions using the Informatica Data Management Cloud (IDMC) platform.
This role requires 5+ years of relevant experience and demands expert, hands-on proficiency with IDMC services such as Cloud Data Integration (CDI), Cloud Data Quality (CDQ), and Cloud Data Governance and Catalog (CDGC).
The Developer will be responsible for building robust, scalable data pipelines to support cloud data warehousing initiatives and enterprise data strategies.
Core Responsibilities :
Cloud Data Integration (CDI) Development :
- Design, develop, test, and deploy complex ETL / ELT processes using IDMC's Cloud Data Integration (CDI) service.
- Build and optimize mappings, mapping tasks, synchronization tasks, and task flows to extract, transform, and load data between various cloud and on-premises sources.
- Implement advanced transformation logic, including hierarchical transformations, expressions, and aggregate functions within CDI mappings.
- Manage and utilize Secure Agents effectively for secure communication between IDMC and diverse data landscapes.
Data Quality and Governance :
Implement data quality rules, validation checks, and standardization routines using IDMC's Cloud Data Quality (CDQ) to ensure high data integrity.Utilize IDMC's Cloud Data Governance and Catalog (CDGC) for metadata management, data lineage tracking, and establishing data governance policies.Collaborate with data governance teams to enforce data policies and standards across all integrated data assets.Cloud and Database Integration :
Establish secure and efficient connectivity with target data platforms, including Cloud Data Warehouses (e.g., Snowflake, AWS Redshift, Google BigQuery) and various databases (e.g., Oracle, SQL Server).Write and optimize complex SQL queries for source data extraction and target data validation.Troubleshoot and resolve complex integration failures, performance bottlenecks, and data reconciliation issues within the IDMC environment.DevOps and Best Practices :
Apply best practices for IDMC development, including reusability, modular design, parameterization, and secure credential management.Utilize version control systems (e.g., Git) and participate in CI / CD processes for automated deployment of IDMC artifacts.Create and maintain comprehensive technical design documentation for data flows, mappings, and system architectures.Required Skills & Qualifications :
Experience : 5+ years of professional experience in data warehousing and ETL development.
Core IDMC : Expert, hands-on proficiency in Informatica Data Management Cloud (IDMC), specifically Cloud Data Integration (CDI).
Data Quality : Experience implementing data quality and profiling rules using IDMC Cloud Data Quality (CDQ).
Databases : Strong proficiency in SQL and deep understanding of data warehousing concepts (dimensional modeling, ETL / ELT).
Cloud Integration : Experience connecting IDMC to major cloud platforms (AWS, Azure, or GCP) and cloud data warehouses.
Preferred Skills :
Hands-on experience with IDMC Cloud Data Governance and Catalog (CDGC).Informatica Cloud certification (e.g., Cloud Data Integration Specialist).Experience with serverless / API integration capabilities within IDMC.Familiarity with Python scripting for pre- or post-processing tasks.Location & Experience :
Location : Remote
Experience : 5+ Years
(ref : hirist.tech)