ETL Developer

Senior ETL Developer

Client:
Ontario Government
Job Type: Contract
Term: 12 Months
Workplace Type:
On-site
Pay Rate: $80 - 90.00

Start date:

2-3 weeks

Location:

Toronto, ON
Language:
English
Clearance: N/A
ATSID #: 10462

• Extensive experience in gathering requirements and business process knowledge to design high-quality data transformation.
• Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, including:
  • Self-Hosted Integration Runtime
  • Data movement, ETL pipelines
  • Performance tuning on large data volumes
  • Complex data transformations
  • ADF Debugger to validate data transformation.
  • Azure Roles
• Experience with Informatica, including:
  • Workflow Manager
  • Repository Manager
  • Designer
  • Workflow Monitor
• Experience with developing solutions using Logic App and Function App.
• Experience in rapid application development (RAD) methodologies.
• Experience in maintaining and improving existing ETL processes.
• Experience in investigating data to identify potential issues within ETL pipelines.
• Experience with Business Intelligence tools IBM Cognos and Microsoft Power
  
  BI.

• Experience with CI/CD (Dev Ops) pipelines and concepts, including:
  • Azure Resource Management
  • Git Hub Repo
  • Source code version control
  • Branching, pull requests, build, release, multiple parallel development repositories merge.
• Experience with Azure Dev Ops, including:
  • Azure Boards
  • Azure Test Plans
  • Azure Pipelines
  • Azure Repos
  • Azure Artefacts

• Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs.

• Experience with Oracle, Microsoft SQL Server database and tools.
• Experience with relational and hierarchical database technologies.
• Extensive knowledge of Azure SQL DB and Synapse platforms, including:
  • Performance tuning on large data volume

• Extensive experience in design, development, and implementation with Azure Data Factory, Databricks or Informatica.
• Experience with CI/CD (Dev Ops) pipelines.
• Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs.
• Experience with Oracle, Microsoft SQL Server database and tools.

• Azure Data Factory
• CI/CD
• SQL
• Oracle PL/SQL
• Microsoft PowerBI
• ETL
• Informatica

• Applicants must be authorized to work in Canada.