Job Description
About the job
Client: Government
Type: Contract
Role: Senior ETL Developer
Term: 1 Year + extension option
Pay Rate: $85.00
Start date: 2-3 weeks
Location: Toronto / Hybrid
Req ID: RQ08590
Requirements: What you’ll need
Skills, Knowledge, Experience, and Qualifications:
ETL Development-Data Integration
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 RuntimeData movement, ETL pipelinesPerformance tuning on large data volumesComplex data transformationsADF Debugger to validate data transformation.Azure RolesExperience with Informatica, including:Workflow ManagerRepository ManagerDesignerWorkflow MonitorExperience 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
Experience with CI/CD (DevOps) pipelines and concepts, including:Azure Resource ManagementGitHub RepoSource code version controlBranching, pull requests, build, release, multiple parallel development repositories merge.Experience with Azure DevOps, including:Azure BoardsAzure Test PlansAzure PipelinesAzure ReposAzure Artefacts
Oracle PL/SQL Development
Extensive experience in designing and developing SQL Server Stored Procedure, 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:
Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.
PREFERRED SKILLS
ETL + Azure Data Factory / Databricks + PowerBI + CI/CD + DevOps + PL/SQL