Software Developer - ETL - Senior
- Toronto, ON
- Permanent
- Full-time
Location: 87 Sir William Hearst Ave., Toronto, (Hybrid)
Duration: 12 Months Contract With 12 Month extension.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
- 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.
- 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
- Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs.
- 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
- Experience with CI/CD (DevOps) pipelines and concepts
- Extensive experience in designing and developing SQL Server Stored procedures, Oracle PL/SQL programs.