Software Developer - ETL - Senior
About The Position
We do have a job opening for Software Developer - ETL - Senior for our direct client Province of Ontario. The position details are given below: Job Details: Job ID: RQ11301 - Software Developer - ETL - Senior Client : Labour and Transportation Cluster Location : Toronto, Ontario Duration: 09 months + Extension Type: Onsite Job Description: 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: 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 · 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 · 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: o 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.
Requirements
- 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, and Azure Roles.
- Experience with Informatica, including Workflow Manager, Repository Manager, Designer, and 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, and Branching, pull requests, build, release, multiple parallel development repositories merge.
- Experience with Azure DevOps, including Azure Boards, Azure Test Plans, Azure Pipelines, Azure Repos, and 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.
Responsibilities
- Gathering requirements and business process knowledge in order to design correct and high-quality data transformation.
- 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, and Azure Roles.
- Experience with Informatica, including Workflow Manager, Repository Manager, Designer, and Workflow Monitor.
- Developing solutions using Logic App and Function App.
- Rapid application development (RAD) methodologies.
- Maintaining and improving existing ETL processes.
- 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, and Branching, pull requests, build, release, multiple parallel development repositories merge.
- Experience with Azure DevOps, including Azure Boards, Azure Test Plans, Azure Pipelines, Azure Repos, and Azure Artefacts.
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
