Description

You will build advanced data pipelines using Informatica Cloud (IICS) to move data from Oracle transaction databases to a Snowflake Data Lake.

This role is on-site.

Responsibilities

• Build mass ingestion pipelines and ETL/ELT processes using Informatica Cloud (IICS).
• Design source-to-target data models and Snowflake target data lake databases.
• Develop data connections for Oracle RDBMS and RESTful API-based applications.
• Implement dimensional modeling within the data warehouse to support reporting and performance.
• Create API-based data ingestion routines and manage Snowflake Data Sharing.

Required Skills

• 8 years of data engineering experience.
• Informatica Cloud (IICS) for data integration and pipeline development.
• Snowflake for data lake and data warehouse modeling.
• Oracle RDBMS for source data extraction.
• SQL for data manipulation and modeling.
• Experience with ETL and ELT development patterns.
• Ability to consume RESTful API application-based data connections.
• Knowledge of source-to-target data modeling.

Key Skills

Education

ANY GRADUATE