Our client is seeking a Remote ETL Developer to design, build, and support enterprise data warehouse and analytics solutions that enable critical business reporting and insights. In this role, you will collaborate with architects and business stakeholders to translate requirements into scalable ETL processes using IBM InfoSphere DataStage and Co
...
gnos Data Manager within a SQL Server environment. You will contribute across the full lifecycle, including data modelling, development, testing, and production support, while ensuring data accuracy, security, and performance. This is an excellent opportunity to work on large-scale data initiatives, drive continuous improvements, and play a key role in shaping a modern data environment. Candidates must bring strong DataStage experience, solid analytical skills, and be comfortable participating in a rotating on-call schedule, including occasional weekend support.
*** Candidates must be eligible for Government of Canada Reliability Security Clearance (5+ years in Canada) ***
*** Remote contract position ***
Advantages
•Improved work life balance through flexible scheduling and no commute.
•Broader collaboration opportunities with diverse teams regardless of location.
Responsibilities
•Design, develop, and maintain Data Warehouse systems and DataMarts to support enterprise reporting and analytics
•Translate business requirements into technical solutions in collaboration with product owners, architects, and stakeholders
•Identify risks, dependencies, and impacts to support effective and timely delivery
•Build and enhance ETL processes using IBM InfoSphere DataStage and Cognos Data Manager in a SQL Server environment
•Participate in testing activities to ensure data accuracy, quality, and reliability
•Investigate and resolve complex data warehouse and ETL issues
•Contribute to logical and physical data modelling efforts
•Optimize SQL queries and overall system performance
•Identify and implement process and system improvements to increase efficiency
•Support ongoing operations, including participation in a rotating on call schedule for incident response
•Collaborate with cross functional teams to maintain a stable and high performing data environment
Qualifications
•Bachelor’s degree in Information Technology, Business Administration, or a related field, with 8+ years of relevant experience
•5+ years of hands-on experience with IBM InfoSphere DataStage, including developing, testing, and deploying ETL solutions in enterprise environments
•Strong experience with IBM Cognos Data Manager
•Proficiency with SQL Server, including query development, performance tuning, and troubleshooting
•Experience with automated testing, including developing and executing test cases to validate ETL processes and ensure data quality
•Strong understanding of integration testing and test strategy execution
•Experience with logical and physical data modelling
•Proven ability to gather and analyze requirements and translate them into technical solutions
•Solid technical design and technical documentation skills
•Experience using Azure DevOps for requirement and work management
•Excellent analytical and problem-solving skills
•Strong communication and interpersonal skills
•Ability to work independently and collaboratively within cross functional teams
•Bilingual in French and English is considered an asset
Summary
If you're qualified and interested please submit your resume and one of our experienced Recruiters would be happy to give you a call. Thank 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.
This posting is for existing and upcoming vacancies.
show more
Our client is seeking a Remote ETL Developer to design, build, and support enterprise data warehouse and analytics solutions that enable critical business reporting and insights. In this role, you will collaborate with architects and business stakeholders to translate requirements into scalable ETL processes using IBM InfoSphere DataStage and Cognos Data Manager within a SQL Server environment. You will contribute across the full lifecycle, including data modelling, development, testing, and production support, while ensuring data accuracy, security, and performance. This is an excellent opportunity to work on large-scale data initiatives, drive continuous improvements, and play a key role in shaping a modern data environment. Candidates must bring strong DataStage experience, solid analytical skills, and be comfortable participating in a rotating on-call schedule, including occasional weekend support.
*** Candidates must be eligible for Government of Canada Reliability Security Clearance (5+ years in Canada) ***
*** Remote contract position ***
Advantages
•Improved work life balance through flexible scheduling and no commute.
...
•Broader collaboration opportunities with diverse teams regardless of location.
Responsibilities
•Design, develop, and maintain Data Warehouse systems and DataMarts to support enterprise reporting and analytics
•Translate business requirements into technical solutions in collaboration with product owners, architects, and stakeholders
•Identify risks, dependencies, and impacts to support effective and timely delivery
•Build and enhance ETL processes using IBM InfoSphere DataStage and Cognos Data Manager in a SQL Server environment
•Participate in testing activities to ensure data accuracy, quality, and reliability
•Investigate and resolve complex data warehouse and ETL issues
•Contribute to logical and physical data modelling efforts
•Optimize SQL queries and overall system performance
•Identify and implement process and system improvements to increase efficiency
•Support ongoing operations, including participation in a rotating on call schedule for incident response
•Collaborate with cross functional teams to maintain a stable and high performing data environment
Qualifications
•Bachelor’s degree in Information Technology, Business Administration, or a related field, with 8+ years of relevant experience
•5+ years of hands-on experience with IBM InfoSphere DataStage, including developing, testing, and deploying ETL solutions in enterprise environments
•Strong experience with IBM Cognos Data Manager
•Proficiency with SQL Server, including query development, performance tuning, and troubleshooting
•Experience with automated testing, including developing and executing test cases to validate ETL processes and ensure data quality
•Strong understanding of integration testing and test strategy execution
•Experience with logical and physical data modelling
•Proven ability to gather and analyze requirements and translate them into technical solutions
•Solid technical design and technical documentation skills
•Experience using Azure DevOps for requirement and work management
•Excellent analytical and problem-solving skills
•Strong communication and interpersonal skills
•Ability to work independently and collaboratively within cross functional teams
•Bilingual in French and English is considered an asset
Summary
If you're qualified and interested please submit your resume and one of our experienced Recruiters would be happy to give you a call. Thank 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.
This posting is for existing and upcoming vacancies.
show more
