Job Description

  • Contractor
  • Anywhere

About the job
Client: Government

Type: Contract

Role: Senior ETL Developer

Term: 1 Year + extension option

Pay Rate: $85.00

Start date: 2-3 weeks

Location: Toronto / Hybrid

Req ID: RQ08590

 

 

Requirements: What you’ll need

Skills, Knowledge, Experience, and Qualifications:

 

ETL Development-Data Integration

Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, including:Self-Hosted Integration RuntimeData movement, ETL pipelinesPerformance tuning on large data volumesComplex data transformationsADF Debugger to validate data transformation.Azure RolesExperience with Informatica, including:Workflow ManagerRepository ManagerDesignerWorkflow MonitorExperience 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 PowerBI.

Azure Technologies

Experience with CI/CD (DevOps) pipelines and concepts, including:Azure Resource ManagementGitHub RepoSource code version controlBranching, pull requests, build, release, multiple parallel development repositories merge.Experience with Azure DevOps, including:Azure BoardsAzure Test PlansAzure PipelinesAzure ReposAzure Artefacts

Oracle PL/SQL Development

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

Database Technologies

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

 

Must haves:

 

Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.

 

 

PREFERRED SKILLS

 

ETL + Azure Data Factory / Databricks + PowerBI + CI/CD + DevOps + PL/SQL