Business Intelligence 5781 (Toronto)

Overview

Design, develop and implement an ingestion framework from Oracle source to Azure Data Lake, covering initial load and incremental ETL.

Responsibilities

• Design the ingestion framework and change data capture, prioritizing Oracle Golden Gate and Azure Data Factory.
• Prepare design artifacts and collaborate with IT partners on Golden Gate configuration.
• Maintain a dynamic ETL pipeline to add new tables and data elements.
• Map data source to reporting destination via physical data modeling.
• Review requirements, database tables, and database relationships; identify gaps and recommend optimizations for the current reporting environment.
• Develop scripts and update database and data lake structures.
• Access and work with Oracle DB, SQL Server, SSIS, SQLDeveloper, Azure Data Studio, Azure Data Factory, Databricks, and other tools to build solutions.
• Communicate proactively with business and ...