Description

Build and optimize ETL/ELT pipelines using Informatica IDMC and Snowflake for batch and real-time data transformations.

Responsibilities

• Design and implement ETL/ELT processes using Informatica Cloud Data Integration (CDI) and Real-Time Integration.
• Extract data from relational databases, APIs, and flat files to populate Snowflake data warehouses.
• Apply Oracle Fusion data extraction techniques for seamless system integration.
• Maintain pipeline performance through error handling, data quality assurance, and automated cleansing routines.
• Document technical specifications, workflows, and processes for future reference.

Required Skills

• 4+ years of experience in ETL/ELT development.
• Proficiency with Informatica Cloud Data Integration (CDI) and Real-Time Integration (CDIR).
• Hands-on experience developing ELT processes to integrate data into Snowflake.
• Strong SQL and PL/SQL programming skills.
• Experience with Python for data tasks.
• Knowledge of Snowflake and DataLake environments.
• Experience with storage management for Azure Blob and Snowflake.
• Understanding of dimensional modeling, star, and snowflake schemas.
• Familiarity with Git, JIRA, and Confluence.

Preferred Skills

• Experience establishing automated data quality monitoring and governance frameworks.

Key Skills

Education

Bachelor's degree in Computer Science