This is a contract position for a Software Developer - ETL for our client who is in the Broader Public Sector. Work location will be in the Greater Toronto Area.
This is a Hybrid Role with some days in the office at the discretion of the Hiring Manager.
The Contract runs for one year.
Hours per day will be 7.25
Advantages
...
Good Compensation working on projects that will make a difference to the people of Ontario.
Responsibilities
Support the Business Intelligence and Business Analytics (BIBA) Unit in developing and implementing the technical solutions needed for data acquisition as well as providing operational support ensuring that any technical glitch is quickly addressed
Design technical solutions for data acquisition and storage into our centralized data repository
Develop ETL scripts, design data-driven logic and conduct unit testing
Conduct database modeling and design as to improve overall performance
Develop, test, and implement the required technical solutions as well as ensure that the requirements in terms of data accuracy, quality are met
Produce design artifacts and documentation which will allow future support of the implemented solutions
Investigate and resolve incidents and identify whether the problem is caused by the data loading code or is due to bad data received from the provider
Execute service requests related to routine and ad-hoc data loads
Provide the data quality check and report on the data quality issue
Ensure that data collected is in a format which is easy consumable by the business users from Capacity Planning and Analytics Division.
Qualifications
Must Haves:
Data warehouse experience
Experience with Informatica
ETL
Relational databases (Oracle)
Cloud exposure
Nice to have:
Reporting tool experience (PowerBI, Cognos, Tableau)
Note to suppliers: Please submit the candidates references with the resume.
Project information:
Many projects on the go
Lots of data processing to do
Adhoc requests
Operational support
Routine data processes runs
Is public sector experience helpful?
Yes; esp within healthcare & OPS
Handling healthcare data
Hybrid policy:
This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home.
5700 Yonge Street
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 for our client who is in the Broader Public Sector. Work location will be in the Greater Toronto Area.
This is a Hybrid Role with some days in the office at the discretion of the Hiring Manager.
The Contract runs for one year.
Hours per day will be 7.25
Advantages
Good Compensation working on projects that will make a difference to the people of Ontario.
Responsibilities
Support the Business Intelligence and Business Analytics (BIBA) Unit in developing and implementing the technical solutions needed for data acquisition as well as providing operational support ensuring that any technical glitch is quickly addressed
Design technical solutions for data acquisition and storage into our centralized data repository
Develop ETL scripts, design data-driven logic and conduct unit testing
Conduct database modeling and design as to improve overall performance
Develop, test, and implement the required technical solutions as well as ensure that the requirements in terms of data accuracy, quality are met
Produce design artifacts and documentation which will allow future support of the implemented solutions
...
Investigate and resolve incidents and identify whether the problem is caused by the data loading code or is due to bad data received from the provider
Execute service requests related to routine and ad-hoc data loads
Provide the data quality check and report on the data quality issue
Ensure that data collected is in a format which is easy consumable by the business users from Capacity Planning and Analytics Division.
Qualifications
Must Haves:
Data warehouse experience
Experience with Informatica
ETL
Relational databases (Oracle)
Cloud exposure
Nice to have:
Reporting tool experience (PowerBI, Cognos, Tableau)
Note to suppliers: Please submit the candidates references with the resume.
Project information:
Many projects on the go
Lots of data processing to do
Adhoc requests
Operational support
Routine data processes runs
Is public sector experience helpful?
Yes; esp within healthcare & OPS
Handling healthcare data
Hybrid policy:
This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home.
5700 Yonge Street
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