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).