Wirehead - Senior ETL Developer

Developer is needed in Toronto, Canada.

Client: Wirehead

Location: Toronto, ON, Canada

Contract: Contractor, Full-time, Full-time

Job Description

Client: Government

Type: Contract

Role: Senior ETL Developer

Term: 1 Year + 1 year extension option

Pay Rate: $95.00

Start date: 2-3 weeks

Location: Toronto / Hybrid

Req ID: RQ08275

Requirements

Skills, Knowledge, Experience, and Qualifications:

ETL Development-Data Integration:

• Extensive experience in gathering requirements and business process knowledge to design high-quality data transformation.
• Design, development, and implementation experience with Azure Data Factory and 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.
• Maintaining and improving existing ETL processes.
• Investigating data to identify potential issues within ETL pipelines.
• Experience with BI tools: IBM Cognos and Microsoft PowerBI.

Azure Technologies:

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

Oracle PL/SQL Development:

• Extensive experience in designing and developing SQL Server Stored Procedures and 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

• Design, Develop and Implement data pipelines using Azure Data Factory (ADF), stored procedure, and Informatica PowerCenter performing extraction, transformation, and loading activities.
• Develop Azure CI/CD pipeline to automate ADF release.
• Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, Informatica including Data movement, ETL pipelines.
• Experience with CI/CD (DevOps) pipelines and concepts, including Azure Resource Management, GitHub Repo, source code version control.
• Extensive experience in designing and developing SQL Server Stored Procedures, Oracle PL/SQL programs.
• Knowledge of Databases - Oracle, Microsoft SQL Server database and tools.

Preferred Skills

• Azure Data Factory
• CI/CD
• Databricks
• DevOps
• ETL
• Informatica

How to Apply

Apply to this position through LinkedIn.