Software Developer - ETL, Randstad

Randstad

Location:
Canada, North York

Category:
IT - Software Development

Contract Type:
Not provided

Salary:

Not provided

Save Job

Apply Position

Job Description:

Our client seeks a Software Developer – ETL to deliver robust, high-quality data integration solutions in support of enterprise projects. This role involves hands-on pipeline development, complex data transformation, and performance optimization across Azure and Oracle environments. If you thrive on creating scalable, high-performing data pipelines that drive business decisions, this role is a perfect fit.

Job Responsibility:

Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc.
Deliver detailed system design documents and any other supporting documentation conforming to the client's standards
To design logical and physical data models using Sybase Power Designer
Produce transformation mapping document
To implement data pipelines using Azure Data Factory (ADF), stored procedure, and Informatica PowerCenter performing extraction, transformation, and loading activities
Implement solutions using Logic App and Function App
Generate a structured JSON file using ADF/ SQL
Develop Azure CI/CD pipeline to automate ADF release
Develop complex Oracle PL/SQL programs to fulfill project requirements
Implement complex data conversion, e.g., binary to character, EBCDIC to UTF
Implement complex data transformation(s) for derived and calculated values
Integrate data sets from diverse source systems
Implement ADF for initial data load and incremental load
Promote ADF and Informatica ETL/ELT through all Ministry environments, including Development, Integration Testing, QA, UAT, and Production
Resolve and troubleshoot ADF pipeline, stored procedure, and Informatica workflow technical problems
Monitor and analyze incidents and provide timely resolution
Collaborate with IT Professionals throughout the Software Development Life Cycle
Document information from diverse business area stakeholders and subject matter experts
Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow
Monitor application functionality and performance on a daily basis
Provide effective knowledge transfer to staff at all stages of this assignment

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
Experience with Business Intelligence tools
Experience with CI/CD (DevOps) pipelines and concepts
Experience with Azure DevOps
Extensive knowledge of Azure SQL DB and Synapse platforms
Performance tuning on large data volume

What we offer:

Contribute to large-scale high-profile sector data migration and integration projects
Work with the latest Azure data services, DevOps pipelines, and BI tools
Collaborate across functional teams in a dynamic, hybrid environment
Opportunity to optimize and modernize enterprise data workflows

Additional Information:

Job Posted:
May 25, 2025

Expiration:
July 02, 2025

Employment Type:

Fulltime

Work Type:

Hybrid work

View All Jobs In This Company

Job Link Share:

Software Developer - ETL

Randstad

Location:Canada, North York

Category:IT - Software Development

Contract Type:Not provided