Job Description

Title: Software Developer - ETL
Location: Toronto, ON
Duration: 12 MonthsSkills
Experience and Skill Set Requirements
Evaluation Table
ETL Development-Data Integration 40%

• 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 Runtime
• Data movement, ETL pipelines
• Performance tuning on large data volumes
• Complex data transformations
• ADF Debugger to validate data transformation.
• Azure Roles

xc2xb7 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 PowerBI.

Azure Technologies 40%

• 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 Artefacts

Oracle PL/SQL Development 10%

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

Database Technologies 10%

• 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.

LanceSoft