ETL DEVELOPER

  Toronto

Our Client in Ontario Public Sector is looking for a ETL Developer on a 6 month contract

5+ Years of:

Demonstrates experience designing, developing, and implementing ETL solutions using Azure Data Factory.
Demonstrates development and solution design experience in an environment where Azure Data Factory, and PowerBI are used together
Experience in designing data warehouses and data marts for databases such as Oracle, SQL Server
Azure SQL Database as well as having a strong understanding of the architectural implications associated with each platform in regard to ETL
Demonstrates experience developing application code package using Azure DevOps
Demonstrates development experience with SQL Server 2016+, Azure Blob and Azure SQL Database, Oracle 12.
Demonstrates experience developing application code package using Azure DevOp

Advantages
Long Term Contract
Hybrid Work
New Technology
Payment Every week
Contract will extend for an additional year

Responsibilities
Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

Qualifications
Demonstrates 5 – 10 years of experience designing, developing, and implementing ETL solutions using Azure Data Factory.

· Demonstrates development and solution design experience in an environment where Azure Data Factory, and PowerBI are used together

· Experience in designing data warehouses and data marts for databases such as Oracle, SQL Server, Azure Blob, Azure SQL Database as well as having a strong understanding of the architectural implications associated with each platform in regard to ETL

· Experience in debugging mappings, transformations, mapplets, source qualifier files and queries

· Demonstrates experience with developing ETL solutions to populate data warehouses and create data extracts for the purpose of business intelligence reporting

· Demonstrates experience developing star schema multi-dimensional models

· Experience with developing, debugging and enhancing the performance of complex SQL queries

· Demonstrates experience developing Unix shell scripts

· Demonstrates experience using Power Designer to review data models, as well as make changes and generate DDL scripts

· Demonstrates experience developing application code package using Azure DevOps

· Demonstrates development experience with SQL Server 2016+, Azure Blob and Azure SQL Database, Oracle 12.x

· Demonstrates experience with documenting code changes, creating release packages and deployment instructions

· Experience with performing unit testing and conducting System Integration Testing and User Acceptance Testing

Demonstrated Experience with Informatica and Powercenter would be an asset

Summary
Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

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.
___________________

View original article here Source