We are seeking a Specialized IT Consultant (Senior) to design and optimize data-focused solutions in a hybrid environment (3 days onsite, 2 days remote). This role requires strong expertise in Oracle, Informatica, Cognos, and ETL processes, including data migration, BI reporting, and integration with modern tools like Fabric Data Factory.
...
Advantages
•Hybrid Work Model: Blend on-site collaboration with remote flexibility.
•Challenging Projects: Contribute to the modernization of large, multi-platform, multi-tier IT systems.
•Cutting-Edge Technology: Work with industry-standard tools such as Oracle, Informatica, Cognos, Power BI, and Fabric Data Factory.
•Professional Growth: Enhance your skills in ETL design, data warehousing, and advanced BI reporting.
•Collaborative Environment: Partner with cross-functional teams to deliver robust solutions and drive continuous improvement.
Responsibilities
•Lead ETL activities using Informatica, Oracle Data Integrator, or SSIS.
•Design, develop, and implement Cognos and Power BI reports, dashboards, and data warehouses.
•Coordinate large-scale data migration initiatives, ensuring performance enhancements and seamless integration.
•Plan and guide the modernization of multi-tier information systems, focusing on data modeling and Fabric Data Factory integration.
•Analyze data requirements, create mapping documents, and troubleshoot production issues to maintain optimal performance.
•Work closely with business users and IT development teams to capture requirements and translate them into technical solutions.
•Prepare design specifications, policies, and procedures for ETL processes and BI solutions.
•Document all work in version control repositories and conduct knowledge transfer sessions as needed.
•Conduct system testing, user acceptance testing, and performance tuning of ETL components.
•Investigate and resolve defects using issue management tools (e.g., HP ALM).
•Oversee deployments, ensuring reliable rollouts and timely updates.
Qualifications
•Proven experience designing and implementing Informatica ETL solutions within an Oracle, Cognos, and Power BI environment.
•Strong knowledge of data warehousing concepts, data modeling, and multi-platform integration.
•Demonstrated ability to optimize SQL queries, handle Unix scripting, and manage code in version control systems.
•Familiarity with Fabric Data Factory or other modern integration tools for data migration and modernization.
•Excellent analytical and problem-solving abilities to evaluate technical design alternatives and troubleshoot issues.
•Experience in Agile or Waterfall SDLC, including requirement gathering, design, and deployment phases.
•Strong communication skills for collaborating with diverse teams and presenting complex information effectively.
Summary
Join us as a Specialized IT Consultant (Senior) and play a pivotal role in modernizing large-scale IT systems. You’ll leverage industry-leading technologies—like Informatica, Cognos, Power BI, and Fabric Data Factory—to deliver impactful data solutions. Apply now to drive innovation and excellence in data-driven transformations!
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 Specialized IT Consultant (Senior) to design and optimize data-focused solutions in a hybrid environment (3 days onsite, 2 days remote). This role requires strong expertise in Oracle, Informatica, Cognos, and ETL processes, including data migration, BI reporting, and integration with modern tools like Fabric Data Factory.
Advantages
•Hybrid Work Model: Blend on-site collaboration with remote flexibility.
•Challenging Projects: Contribute to the modernization of large, multi-platform, multi-tier IT systems.
•Cutting-Edge Technology: Work with industry-standard tools such as Oracle, Informatica, Cognos, Power BI, and Fabric Data Factory.
•Professional Growth: Enhance your skills in ETL design, data warehousing, and advanced BI reporting.
•Collaborative Environment: Partner with cross-functional teams to deliver robust solutions and drive continuous improvement.
Responsibilities
•Lead ETL activities using Informatica, Oracle Data Integrator, or SSIS.
•Design, develop, and implement Cognos and Power BI reports, dashboards, and data warehouses.
•Coordinate large-scale data migration initiatives, ensuring performance enhancements and seamless integration.
...
•Plan and guide the modernization of multi-tier information systems, focusing on data modeling and Fabric Data Factory integration.
•Analyze data requirements, create mapping documents, and troubleshoot production issues to maintain optimal performance.
•Work closely with business users and IT development teams to capture requirements and translate them into technical solutions.
•Prepare design specifications, policies, and procedures for ETL processes and BI solutions.
•Document all work in version control repositories and conduct knowledge transfer sessions as needed.
•Conduct system testing, user acceptance testing, and performance tuning of ETL components.
•Investigate and resolve defects using issue management tools (e.g., HP ALM).
•Oversee deployments, ensuring reliable rollouts and timely updates.
Qualifications
•Proven experience designing and implementing Informatica ETL solutions within an Oracle, Cognos, and Power BI environment.
•Strong knowledge of data warehousing concepts, data modeling, and multi-platform integration.
•Demonstrated ability to optimize SQL queries, handle Unix scripting, and manage code in version control systems.
•Familiarity with Fabric Data Factory or other modern integration tools for data migration and modernization.
•Excellent analytical and problem-solving abilities to evaluate technical design alternatives and troubleshoot issues.
•Experience in Agile or Waterfall SDLC, including requirement gathering, design, and deployment phases.
•Strong communication skills for collaborating with diverse teams and presenting complex information effectively.
Summary
Join us as a Specialized IT Consultant (Senior) and play a pivotal role in modernizing large-scale IT systems. You’ll leverage industry-leading technologies—like Informatica, Cognos, Power BI, and Fabric Data Factory—to deliver impactful data solutions. Apply now to drive innovation and excellence in data-driven transformations!
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
