This is a contract position for a Software Developer - ETL for our public sector client.
Work location: Toronto
Duration: Seven Months
7.25 hours/day
This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)
...
Advantages
Good Compensation working on projects that will make a difference to the people of Ontario.
Responsibilities
· Monitor and analyze incident, provide timely resolution
· 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 Ministry standards
· Design logical and physical data models using Sybase Power Designer
· Produce transformation mapping document
· Implement solution using Azure Data Factory (ADF) pipeline and stored procedure, and Informatica PowerCenter
· Develop Azure CI/CD pipeline to automate ADF release
· Develop complex Oracle PL/SQL program to fulfill project requirements
· 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 from PostgreSQL to Azure SQL DB
· Promote ADF and Informatica ETL/ELT through all Ministry environments including: Development, Integration Testing, QA, UAT, Production
· Debug ADF pipeline and stored procedure, and Informatica workflow to investigate and fix defects
· Actively participate, support and provide feedback to project team during design/development/testing/implementation phase
· Produce supporting documentation
· 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 Ministry staff at all stages of this assignment
Qualifications
ETL and BI Development
· Extensive experience with ETL tools Informatica PowerCenter;
o Workflow Manager
o Repository Manager
o Designer
o Workflow Monitor
· Extensive experience with Azure Data Factory, 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 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, merging pipeline across multiple parallel development repositories
· Experience with Azure DevOps, including:
o Azure Boards
o Azure Test Plans
o Azure Pipelines
o Azure Repos
o Azure Artefacts
· Expert experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI;
Oracle PL/SQL Development
· Extensive experience in designing and developing Oracle PL/SQL programs
Database Technologies
· Experience with PostgreSQL, Oracle, Microsoft SQL Server database and tools;
· Extensive knowledge of Azure SQL DB and Synapse platforms, including:
o Performance tuning on large data volume
Summary
If interested and qualified for this role, please apply today for immediate consideration!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
voir plus
This is a contract position for a Software Developer - ETL for our public sector client.
Work location: Toronto
Duration: Seven Months
7.25 hours/day
This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)
Advantages
Good Compensation working on projects that will make a difference to the people of Ontario.
Responsibilities
· Monitor and analyze incident, provide timely resolution
· 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 Ministry standards
· Design logical and physical data models using Sybase Power Designer
· Produce transformation mapping document
· Implement solution using Azure Data Factory (ADF) pipeline and stored procedure, and Informatica PowerCenter
· Develop Azure CI/CD pipeline to automate ADF release
· Develop complex Oracle PL/SQL program to fulfill project requirements
...
· 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 from PostgreSQL to Azure SQL DB
· Promote ADF and Informatica ETL/ELT through all Ministry environments including: Development, Integration Testing, QA, UAT, Production
· Debug ADF pipeline and stored procedure, and Informatica workflow to investigate and fix defects
· Actively participate, support and provide feedback to project team during design/development/testing/implementation phase
· Produce supporting documentation
· 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 Ministry staff at all stages of this assignment
Qualifications
ETL and BI Development
· Extensive experience with ETL tools Informatica PowerCenter;
o Workflow Manager
o Repository Manager
o Designer
o Workflow Monitor
· Extensive experience with Azure Data Factory, 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 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, merging pipeline across multiple parallel development repositories
· Experience with Azure DevOps, including:
o Azure Boards
o Azure Test Plans
o Azure Pipelines
o Azure Repos
o Azure Artefacts
· Expert experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI;
Oracle PL/SQL Development
· Extensive experience in designing and developing Oracle PL/SQL programs
Database Technologies
· Experience with PostgreSQL, Oracle, Microsoft SQL Server database and tools;
· Extensive knowledge of Azure SQL DB and Synapse platforms, including:
o Performance tuning on large data volume
Summary
If interested and qualified for this role, please apply today for immediate consideration!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
voir plus
