This is a contract position for a Software Developer ETL - Senior for our client who is in the Broader Public Sector. Work location will be in Downtown Toronto.
This is a Hybrid Role with 3 days in the office a week. This is a mandatory requirement of the role and is non negotiable outside of exceptional circumstances.
...
The Contract runs for four months.
Hours per day will be 7.25
Advantages
Good Compensation working on projects that will make a difference to the people of Ontario.
Responsibilities
SCOPE:
The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer – ETL with 9 + years’ experience to perform data migration activities from existing OPGT legacy applications to the new Dynamics 365 OPGT solution and data warehouse.
DELIVERABLES:
• As a member of the data migration team, responsible for tasks to migrate the data from the existing OPGT legacy applications to new Dynamics 365 OPGT solution.
• As a member of the data migration team, responsible for tasks to migrate the data from the existing OPGT legacy applications to new data warehouse.
• Provide strong technical knowledge and business subject matter expertise across a wide range of database technologies, with a primary focus on SQL Server, Oracle, Azure SQL Database.
• Provide knowledge transfer to the business and other IT resources, and maintaining documentation
The Vendor’s Personnel will also be required to:
• Complete work and achieve milestones within the assigned deadlines;
• Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the Assignment Deliverables, as soon as the he/she becomes aware of them;
• Submit Deliverables for the Cluster/Ministry approval as they are completed,
• Comply with the Ontario Government and the Cluster/Ministry security procedures and practices;
• Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices;
• Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines;
• Provide knowledge and skill transfer to a designated Cluster/Ministry staff; and
• Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.
Qualifications
• 5+ years of proven working experience with SQL Server, Oracle, Azure SQL Databases
• Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning
• Experience with SQL Server Management Studio, Azure data management tools, data modeling tools (preferably, ERWIN), DevOps
• Experience with at least one programming language (Python, Java, C#, etc.)
• Experience with Azure Data Factory (ADF)
SKILLS AND KNOWLEDGE:
• 5+ years of proven working experience with SQL Server, Oracle, Azure SQL Databases
• Expert knowledge and experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning
• Experience with SQL Server Management Studio, Azure data management tools, data modeling tools (preferably, ERWIN), DevOps, Synapse Studio
• Experience with at least one programming language (C#, Python, Java, etc.)
• Experience with Azure Data Factory (ADF) and Synapse Link for SQL
• Experience with data warehousing technologies such as snowflake
• Familiarity with Azure cloud platform
• Excellent problem-solving and analytical skills
• Strong communication and teamwork skills
Nice to have:
• Azure Databricks
• Power Platform (in particular, Power BI), Dynamics 365
• DevOps CI/CD experience
• Logic App, Function development experience
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 ETL - Senior for our client who is in the Broader Public Sector. Work location will be in Downtown Toronto.
This is a Hybrid Role with 3 days in the office a week. This is a mandatory requirement of the role and is non negotiable outside of exceptional circumstances.
The Contract runs for four months.
Hours per day will be 7.25
Advantages
Good Compensation working on projects that will make a difference to the people of Ontario.
Responsibilities
SCOPE:
The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer – ETL with 9 + years’ experience to perform data migration activities from existing OPGT legacy applications to the new Dynamics 365 OPGT solution and data warehouse.
DELIVERABLES:
• As a member of the data migration team, responsible for tasks to migrate the data from the existing OPGT legacy applications to new Dynamics 365 OPGT solution.
• As a member of the data migration team, responsible for tasks to migrate the data from the existing OPGT legacy applications to new data warehouse.
...
• Provide strong technical knowledge and business subject matter expertise across a wide range of database technologies, with a primary focus on SQL Server, Oracle, Azure SQL Database.
• Provide knowledge transfer to the business and other IT resources, and maintaining documentation
The Vendor’s Personnel will also be required to:
• Complete work and achieve milestones within the assigned deadlines;
• Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the Assignment Deliverables, as soon as the he/she becomes aware of them;
• Submit Deliverables for the Cluster/Ministry approval as they are completed,
• Comply with the Ontario Government and the Cluster/Ministry security procedures and practices;
• Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices;
• Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines;
• Provide knowledge and skill transfer to a designated Cluster/Ministry staff; and
• Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.
Qualifications
• 5+ years of proven working experience with SQL Server, Oracle, Azure SQL Databases
• Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning
• Experience with SQL Server Management Studio, Azure data management tools, data modeling tools (preferably, ERWIN), DevOps
• Experience with at least one programming language (Python, Java, C#, etc.)
• Experience with Azure Data Factory (ADF)
SKILLS AND KNOWLEDGE:
• 5+ years of proven working experience with SQL Server, Oracle, Azure SQL Databases
• Expert knowledge and experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning
• Experience with SQL Server Management Studio, Azure data management tools, data modeling tools (preferably, ERWIN), DevOps, Synapse Studio
• Experience with at least one programming language (C#, Python, Java, etc.)
• Experience with Azure Data Factory (ADF) and Synapse Link for SQL
• Experience with data warehousing technologies such as snowflake
• Familiarity with Azure cloud platform
• Excellent problem-solving and analytical skills
• Strong communication and teamwork skills
Nice to have:
• Azure Databricks
• Power Platform (in particular, Power BI), Dynamics 365
• DevOps CI/CD experience
• Logic App, Function development experience
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
