Informatica IDMC Developer – Job Description
We are seeking an experienced Informatica IDMC Developer to design, develop, and support cloud-based data integration and data management solutions using Informatica Intelligent Data Management Cloud (IDMC). The ideal candidate should have strong expertise in ETL/ELT development, cloud data integration, API integrations, and data warehousing concepts.
Key Responsibilities
- Design, develop, and maintain ETL/ELT pipelines using Informatica IDMC services.
- Work with Cloud Data Integration (CDI), Cloud Application Integration (CAI), and Mass Ingestion services.
- Develop mappings, mapplets, taskflows, and workflows for data movement and transformation.
- Integrate data from multiple sources including databases, APIs, cloud platforms, and flat files.
- Perform data cleansing, validation, transformation, and loading into target systems.
- Optimize data integration jobs for performance, scalability, and reliability.
- Collaborate with business analysts, architects, and data engineering teams to gather requirements and implement solutions.
- Troubleshoot production issues and provide ongoing support for data integration processes.
- Implement error handling, logging, monitoring, and scheduling mechanisms.
- Ensure data quality, governance, and security best practices are followed.
- Participate in code reviews, deployment activities, and documentation preparation.
Required Skills
- Strong experience with Informatica IDMC / IICS platform.
- Hands-on experience in CDI, CAI, Mass Ingestion, and API integrations.
- Good knowledge of ETL/ELT concepts and data warehousing.
- Experience working with cloud platforms such as AWS, Azure, or GCP.
- Strong SQL skills and experience with relational databases like Oracle, SQL Server, PostgreSQL, or Snowflake.
- Knowledge of REST/SOAP APIs, JSON, XML, and web services.
- Experience with scheduling and orchestration tools.
- Understanding of data governance and data quality concepts.
- Strong troubleshooting and analytical skills.
Preferred Qualifications
- Bachelor's degree in Computer Science, Information Technology, or related field.
- Informatica IDMC/IICS certification is preferred.
- Experience with Agile/Scrum methodology.
- Exposure to DevOps and CI/CD practices is an added advantage.
Nice to Have
- Experience with Snowflake, Databricks, Kafka, or cloud-native data platforms.
- Knowledge of Python or scripting languages.
- Familiarity with data lake and big data technologies.
