This is a contract position for a Software Developer for our public sector client.
Work location: Downtown 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
Work as an integrated member of the Data Management team to support cross functional data initiatives with various business clients
Interact with Business teams to better understand the technical functionality requirements and analyze data requirements and their impact to the existing systems
Responsible in connecting various source and target systems (Oracle and Microsoft databases, APIs, flat files, etc.) and performing Extract, Transform, and Load (ETL) activities
Work with team members to develop ETL within Azure Data Factory and SQL code to satisfy business requirements
Create ETL Mappings and develop stored procedures, SQL queries and tune/optimize SQL code the ETL process and the target database for reporting
Execute unit tests to ensure the accuracy of code changes, and to verify that data integrity and performance requirements are met
Participate in meetings and scrums, works on incident and enhancement/maintenance tickets assignments and delivers excellent technical support
Create and maintains technical documents, including data models
Qualifications
Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI
Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)
Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
Experience with data integration, data cleansing, and data analytics
Experience with data modeling and design principles for data marts and data warehouses
Experience in database management and administration
Experience in constructing complex SQL queries and performance tuning
Experience with Git and knowledge of source control strategies
Experience creating technical documentation including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.
Experience in eliciting, documenting, and validating business requirements
Experience in software development lifecycle from Development, to Testing and Quality Assurance, to Delivery
Solid communications skills: the ability to understand, comprehend, and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.
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.
show more
This is a contract position for a Software Developer for our public sector client.
Work location: Downtown 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
Work as an integrated member of the Data Management team to support cross functional data initiatives with various business clients
Interact with Business teams to better understand the technical functionality requirements and analyze data requirements and their impact to the existing systems
Responsible in connecting various source and target systems (Oracle and Microsoft databases, APIs, flat files, etc.) and performing Extract, Transform, and Load (ETL) activities
Work with team members to develop ETL within Azure Data Factory and SQL code to satisfy business requirements
Create ETL Mappings and develop stored procedures, SQL queries and tune/optimize SQL code the ETL process and the target database for reporting
...
Execute unit tests to ensure the accuracy of code changes, and to verify that data integrity and performance requirements are met
Participate in meetings and scrums, works on incident and enhancement/maintenance tickets assignments and delivers excellent technical support
Create and maintains technical documents, including data models
Qualifications
Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI
Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)
Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
Experience with data integration, data cleansing, and data analytics
Experience with data modeling and design principles for data marts and data warehouses
Experience in database management and administration
Experience in constructing complex SQL queries and performance tuning
Experience with Git and knowledge of source control strategies
Experience creating technical documentation including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.
Experience in eliciting, documenting, and validating business requirements
Experience in software development lifecycle from Development, to Testing and Quality Assurance, to Delivery
Solid communications skills: the ability to understand, comprehend, and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.
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.
show more
