Informatica IDMC Developer

Role & Responsibilities:

Builds and optimizes ETL/ELT pipelines with IDMC and Snowflake for batch and real-time transformations.
Design, develop, and implement ETL/ELT processes using Informatica IDMC tools (CDI, CDIR/CMI).
Extract data from various sources, including relational databases, APIs, and flat files.
Collaborate with stakeholders to gather requirements and translate them into robust ETL workflows.
Integrate and transform data to populate Snowflake data warehouses and other storage systems.
Leverage Oracle Fusion data extraction techniques for seamless integration.
Maintain and optimize ETL performance, including error handling and data quality assurance.
Document technical specifications, workflows, and processes for future reference.
Collaborate with cross-functional teams to ensure alignment with business objectives.
Proficient in troubleshooting and optimizing data pipelines for performance and reliability.

Experience Required:

Informatica Developer:

Developed ELT processes using IDMC to integrate data into Snowflake.
Implemented storage management for Azure Blob and Snowflake, enhancing data security.
Established automated data quality monitoring for accuracy and completeness.
Real-Time/Near-Realtime Data Integration Specialist:

Led Snowflake projects with real-time data pipelines and IDMC integration.
Built data quality frameworks and automated cleansing routines.
Managed real-time and batch data flows, ensuring data consistency for analytics.

Technical Skills:

Tools: Informatica Cloud Data Integration, Real-Time Integration (CDIR)
Data Warehousing: Snowflake, DataLake
Programming: SQL, PL/SQL, Python
Data Management: Storage management, quality monitoring, governance
Modeling: Dimensional modeling, star/snowflake schema
Other Tools: Git, JIRA, Confluence