Business Intelligence Specialist - Toronto, Canada - iPartner Staffing

iPartner Staffing
iPartner Staffing
Verified Company
Toronto, Canada

2 weeks ago

Sophia Lee

Posted by:

Sophia Lee

beBee Recruiter
Description
7+ years in ETL tools such as Microsoft SSIS, stored procedures
(Must Have):

  • 2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines
    (Must Have):
  • 2+ years Python
    (Must Have)
Description


General Responsibilities
Design, develop and implement ingestion framework from Oracle source to Azure Data Lake - initial load and incremental ETL


Used tools are:

  • Oracle Golden Gate (knowledge and experience are an asset but not required) for data ingestion and change data capture (currently in final stages of proof of concept)
  • Azure Data Factory (expert knowledge) to maintain pipeline from Oracle to Azure Data Lake
  • Azure Databricks/PySpark (good Python knowledge required) to build transformations of raw data into curated zone in the data lake
  • Azure Synapse to build stored procedures and read data from data lake

Job Type:
Fixed term contract

Contract length: 6 months


Salary:
$400.00-$750.00 per day


Schedule:

  • 8 hour shift

Ability to commute/relocate:

  • Toronto, ON: reliably commute or plan to relocate before starting work (required)

Experience:


  • Python: 1 year (required)
Business Intelligence Specialist: 9 years (required)

  • ETL tools such as Microsoft

SSIS:
7 years (required)

  • Azure Data Lake and
Data Warehouse: 2 years (required)


Work Location:
On the road
More jobs from iPartner Staffing
See all jobs of iPartner Staffing