Software Developer – ETL – Senior

Role: Software Developer – ETL – Senior
Location: Toronto, ON (Hybrid- 3 days in office)
Duration: Long Term Contract
Note: Need only Canadian Authorized candidate.
Must haves:
•             Extensive experience in gathering requirements and business process knowledge in order to design correct and High-Quality Data Transformation.
Skills: –
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:
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 Informatica, including:
o            Workflow Manager
o            Repository Manager
o            Designer
o            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:
o            Azure Resource Management
o            GitHub Repo
o            Source code version control
o            Branching, pull requests, build, release, multiple parallel development repositories merge.
Experience with Azure DevOps, including:
o            Azure Boards
o            Azure Test Plans
o            Azure Pipelines
o            Azure Repos
o            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