We are seeking a Senior Specialized IT Consultant for a six-month contract, with the possibility of extension. This is a hybrid role, requiring the candidate to work on-site in Toronto up to three days per week. This position is critical for the cancer care programs team, responsible for designing, implementing, and supporting complex ETL and data pipelines using IICS, Oracle 19G, and Azure SQL Database.
...
Advantages
- Play a central role in a high-impact healthcare data program.
- Opportunity to work with a modern data stack including IICS, Oracle 19G, and Azure Cloud technologies.
- Engage in a dynamic role covering the full software lifecycle (design, development, QA, and production support).
- Hybrid work model offers flexibility.
Responsibilities
- Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading (ETL/ELT) activities using IICS.
- Write, maintain, and optimize SQL queries for Oracle 19G and Azure SQL Database. Develop and maintain Shell Scripts on Linux 8 for system automation.
- Provide production support by monitoring ETL jobs, investigating failures, resolving and troubleshooting technical problems, and supporting QA activities.
- Translate technical specifications into working, tested applications. Create detailed design documents, source code, runbooks, and technical/conceptual specifications.
- Resolve and troubleshoot technical problems during the operation of software packages, and assist with technical implementation, conversion, and migrations.
Qualifications
- A minimum of 8+ years' experience with IICS (Informatica Intelligent Cloud Services).
- A minimum of 8+ years' experience with Oracle 19G.
- A minimum of 8+ years' experience with Azure SQL Database.
- A minimum of 8+ years' experience with Linux 8 – Shell Scripting.
- Proven experience in building and maintaining data pipelines (ETL/ELT processes).
- Proficiency in writing and optimizing SQL queries across relational databases.
- Familiarity with version control systems (e.g., Git) and CI/CD pipelines is highly desirable.
- Strong understanding of ETL concepts, data transformation logic, and data quality best practices.
- Excellent analytical, problem-solving, and decision-making skills.
Summary
If you're interested in the Senior Specialized IT Consultant role based in Toronto, we encourage you to apply online at www.randstad.ca.
Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
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
We are seeking a Senior Specialized IT Consultant for a six-month contract, with the possibility of extension. This is a hybrid role, requiring the candidate to work on-site in Toronto up to three days per week. This position is critical for the cancer care programs team, responsible for designing, implementing, and supporting complex ETL and data pipelines using IICS, Oracle 19G, and Azure SQL Database.
Advantages
- Play a central role in a high-impact healthcare data program.
- Opportunity to work with a modern data stack including IICS, Oracle 19G, and Azure Cloud technologies.
- Engage in a dynamic role covering the full software lifecycle (design, development, QA, and production support).
- Hybrid work model offers flexibility.
Responsibilities
- Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading (ETL/ELT) activities using IICS.
- Write, maintain, and optimize SQL queries for Oracle 19G and Azure SQL Database. Develop and maintain Shell Scripts on Linux 8 for system automation.
...
- Provide production support by monitoring ETL jobs, investigating failures, resolving and troubleshooting technical problems, and supporting QA activities.
- Translate technical specifications into working, tested applications. Create detailed design documents, source code, runbooks, and technical/conceptual specifications.
- Resolve and troubleshoot technical problems during the operation of software packages, and assist with technical implementation, conversion, and migrations.
Qualifications
- A minimum of 8+ years' experience with IICS (Informatica Intelligent Cloud Services).
- A minimum of 8+ years' experience with Oracle 19G.
- A minimum of 8+ years' experience with Azure SQL Database.
- A minimum of 8+ years' experience with Linux 8 – Shell Scripting.
- Proven experience in building and maintaining data pipelines (ETL/ELT processes).
- Proficiency in writing and optimizing SQL queries across relational databases.
- Familiarity with version control systems (e.g., Git) and CI/CD pipelines is highly desirable.
- Strong understanding of ETL concepts, data transformation logic, and data quality best practices.
- Excellent analytical, problem-solving, and decision-making skills.
Summary
If you're interested in the Senior Specialized IT Consultant role based in Toronto, we encourage you to apply online at www.randstad.ca.
Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
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
