Senior ETL Developer Contract

*************************************************
Client: Government
Location: Toronto (hybrid)
Type: Contract
Role: Senior ETL Developer
Term: 168 working days + extension
Rate: Open
Start date: 2/3 weeks
Req ID: 5754
*************************************************
On behalf of our Government client, Wirehead has a new contract opportunity for a Senior ETL Developer.

Requirements: What you’ll need

Skills, Knowledge, Experience, and Qualifications
Deliverables:

ETL and BI Development

• Extensive experience with ETL tools Informatica PowerCenter;
o Workflow Manager
o Repository Manager
o Designer
o Workflow Monitor
• Extensive experience with Azure Data Factory, including:
o Self-Hosted Integration Runtime
o Data movement, ETL pipelines
o Performance tuning on large data volumes
o Complex data transformations
o ADF Debugger to validate data transformation
o Azure Roles
• Experience with CI/CD (DevOps) pipelines and concepts, including:
o Azure Resource Management
o GitHub Repo
o Source code version control
o Branching, pull requests, build, release, merging pipeline across multiple parallel development repositories
• Experience with Azure DevOps, including:
o Azure Boards
o Azure Test Plans
o Azure Pipelines
o Azure Repos
o Azure Artefacts
• Expert experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI;

• Oracle PL/SQL Development
 Extensive experience in designing and developing Oracle PL/SQL programs

• Database Technologies
 Experience with PostgreSQL, Oracle, Microsoft SQL Server database and tools;
 Extensive knowledge of Azure SQL DB and Synapse platforms, including:
• Performance tuning on large data volume

EVALUATION CRITERIA:

ETL and BI Development 50%

• Experience with Informatica PowerCenter, including:
• Workflow Manager
• Repository Manager
• Designer
• Workflow Monitor
• Extensive experience with Azure Data Factory, 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 CI/CD (DevOps) pipelines and concepts, including:
• Azure Resource Management
• GitHub Repo
• Source code version control
• Branching, pull requests, build, release, merging pipeline across multiple parallel development repositories
• Experience with Azure DevOps, including:
• Azure Boards
• Azure Test Plans
• Azure Pipelines
• Azure Repos
• Azure Artefacts
• Expert experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI;

Oracle PL/SQL Development 20%

• Extensive experience in designing and developing Oracle PL/SQL programs

Database Technologies 30%

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

Must haves:

• Experience with Informatica PowerCenter, including:
o Workflow Manager
o Repository Manager
o Designer
o Workflow MonitoR
• Extensive experience with Azure Data Factory, including:
o Self-Hosted Integration Runtime
o Data movement, ETL pipelines
o Performance tuning on large data volumes
o Complex data transformations
o ADF Debugger to validate data transformation
o Azure Roles
• Experience with PostgreSQL, Oracle, Microsoft SQL Server database and tools;
• Extensive knowledge of Azure SQL DB and Synapse platforms, including:
o Performance tuning on large data volume

HOW TO APPLY

Please apply for this opportunity by using the Apply button or sending your resume directly to careers@wirehead.com

We thank all candidates for their interest but advise that only candidates selected for interviews will be contacted directly. Rest assured that your resume will be kept on our database and will be considered for all future opportunities.

***This opportunity is in Toronto; preference will be given to local candidates. Wirehead does not offer a relocation package. We encourage you continue to refer to our Job listing page as new opportunities become available and updated on a regular basis. Thank you again for your interest in Wirehead!