Informatica IDMC Data Engineer
Summary
Mid-level data engineer designing, building, and optimizing cloud ETL/ELT pipelines in Informatica IDMC (Cloud Data Integration, Application Integration, Data Quality). Day to day involves mappings, mapplets, taskflows, API and cloud data source integration, data quality rules, and performance tuning across AWS/Azure/GCP.
We are looking for an experienced Mid-Level Informatica IDMC Data Engineer to design, build, and optimize cloud-based data integration and ETL workflows using Informatica Intelligent Data Management Cloud (IDMC). The role involves working across data pipelines, API integration, cloud orchestration, and data quality initiatives.
Key Responsibilities
- Develop, configure, and maintain ETL/ELT pipelines using Informatica IDMC (Cloud Data Integration, Cloud Application Integration, Cloud Data Quality).
- Design data integration jobs connecting cloud and on-prem data sources (AWS/Azure/GCP, Databases, APIs).
- Build reusable mappings, mapplets, tasks, workflows, and parameterized templates.
- Configure and optimize Informatica Cloud Tasks such as:
- Mapping Tasks
- Taskflows
- Replication Tasks
- Perform data transformation, cleansing, validation, and enrichment.
- Integrate data from REST/SOAP APIs, databases, flat files, and cloud storage.
- Monitor, troubleshoot, and optimize IDMC jobs for performance and reliability.
- Implement data quality rules, profiling, and validations using Informatica Cloud Data Quality.
- Collaborate with data architects and business teams to translate requirements into scalable technical solutions.
- Maintain documentation including data mappings, workflows, and solution designs.
Required Skills & Qualifications
- 3–7 years of hands‑on experience in Informatica ETL, with at least 2+ years in Informatica IDMC / Informatica Cloud.
- Strong understanding of Cloud Data Integration (CDI), Taskflows, and Mapping Design.
- Experience with cloud platforms (AWS, Azure, or GCP).
- Knowledge of REST/SOAP API integrations.
- Experience with scheduling and orchestration tools (Control‑M, Airflow, IDMC Taskflows).
- Strong understanding of data warehousing concepts and dimensional modeling.
- Good debugging, workflow analysis, and performance tuning skills.
Preferred Skills (Nice to Have)
- Experience with Informatica Data Quality (IDQ) or Data Governance tools.
- Knowledge of Snowflake, Databricks, or Big Data technologies.
- Experience with Python or shell scripting.
- Familiarity with CI/CD tools (Git, Jenkins, Azure DevOps).
Skills
Sign in to read and join the discussion.