(Senior) IT Solution Architect H/F

We are seeking a Senior Solutions Designer with deep expertise in Informatica ETL and the Oracle/Cognos ecosystem. In this role, you will be responsible for the architectural design and technical delivery of hosting technology solutions. You will lead the migration, transformation, and optimization of data across complex environments, specifically focusing on the conversion of Oracle-based systems to SQL Server architectures while ensuring high-performance Business Intelligence (BI) delivery.

Technical Leadership: Lead complex modernization efforts for multi-platform, multi-tier information technology systems.

• Directly influence the data architecture used for critical provincial business intelligence and reporting.
• Comprehensive Stack: Work across a wide array of top-tier tools including Informatica, Cognos, Power BI, Databricks, and Azure.
• Design technology solutions based on client specifications, best practices, and cost models to meet high-volume data requirements.
• Design, develop, and unit test project ETL components, including mappings, workflows, mapplets, and data marts using Informatica.
• Database Migration: Lead schema conversion between Oracle and SQL Server, converting PL/SQL stored procedures, triggers, and functions into T-SQL code.
• Data Modeling: Utilize PowerDesigner to review data models, execute changes, and generate DDL scripts for hierarchical and star-schema multidimensional models.
• Performance Optimization: Fine-tune database performance through indexing, query optimization, and partitioning within SQL Server and Oracle environments.
• Business Intelligence: Design and implement reports and dashboards using Cognos 10+ and Microsoft Power BI, focusing on KPI development and data visualization.
• Collaboration: Work closely with project managers and business stakeholders to ensure technical specifications accurately reflect business needs.
• Code Management: Maintain the full application code package using TFS, VSS, and Azure DevOps, documenting all changes and facilitating deployment.

Extensive experience designing and implementing Informatica ETL solutions.

• Proven design experience in environments where Oracle, Informatica, and Cognos are used together for data warehousing.
• Data Modeling Tools: Proficiency in PowerDesigner for data model reviews and DDL script generation.
• Database Depth: Advanced development experience with Oracle (11.x) and SQL Server, including T-SQL and PL/SQL expertise.
• Hands-on experience with Microsoft MQ, SSIS, SSRS, and SSAS.
• Demonstrated success in Agile and Waterfall SDLC environments, including system testing (SIT, SAT, UAT).
• Technical Communication: Ability to translate complex high-volume data themes into clear technical requirements and executive-level presentations.

If you're interested in the Solutions Designer role based in Toronto, we encourage you to apply online at

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 View email address on randstad.com.