Azure Data Factory ETL Developer

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
Payment every week
Long Term Contract
Working in Ontario Public Sector
RQ03071

Responsibilities
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

Qualifications

Knowledge and experience in gathering requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end users
Knowledge and experience maintaining and improving already existing processes.
Knowledge and experience ensuring that the data architecture is scalable and maintainable
Knowledge and experience working with the business in designing and delivering correct, high quality data
Experience investigating data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions
Experience preparing detailed documentation for further reference
Desirable Skills:

Knowledge and experience with programming Internet-ready applications
Knowledge and experience in rapid application development (RAD) methodologies
Knowledge and understanding of Information Management principles, concepts, policies and practices
Experience with middleware and gateways
Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging
Ability to provide post-implementation support and resolve any post-implementation technical issues
Experience conducting design walkthrough sessions with project team
Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
Ability to provide user and system documentation as required

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.