This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
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.
Job Responsibility:
Solution Architecture: Design technology solutions based on client specifications, best practices, and cost models to meet high-volume data requirements
ETL Development: 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
Requirements:
Extensive experience designing and implementing Informatica ETL solutions
Proven design experience in environments where Oracle, Informatica, and Cognos are used together for data warehousing
Proficiency in PowerDesigner for data model reviews and DDL script generation
Advanced development experience with Oracle (11.x, 12.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)
Ability to translate complex high-volume data themes into clear technical requirements and executive-level presentations
What we offer:
Technical Leadership: Lead complex modernization efforts for multi-platform, multi-tier information technology systems
High-Value Impact: 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
Dedicated Environment: Enjoy a collaborative, fully onsite team structure at a central Toronto cluster