Solutions Designer – Legacy Modernization & Informatica ETL

• Title
• Solutions Designer
• Description
• To respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as needed basis.

• Major Responsibilities
• :Leads the analysis, documentation, and modernization of legacy system architectures, with a strong focus on understanding and mapping existing data flows, integrations, and dependencies, particularly Informatica ETL processes
• .Develops comprehensive architectural documentation (current-state and future-state), including system context diagrams, data architectures, integration patterns, and technical specifications
• .Provides expert-level analysis of ETL processes (especially Informatica), identifying data lineage, transformation logic, dependencies, and opportunities for optimization, simplification, or modernization
• .Collaborates closely with business stakeholders, developers, and data teams to translate business requirements into scalable, maintainable, and compliant solution designs
• .Ensures solutions align with OPS architecture principles, Information Management standards, security policies, and regulatory requirements
• .Facilitates design reviews and architectural governance processes to ensure consistency, quality, and adherence to standards
• .Communicates complex technical concepts clearly and effectively to both technical and non-technical stakeholders
• .Supports project delivery by guiding development teams, resolving design issues, and ensuring architectural integrity throughout implementation
• .Identifies risks, constraints, and impacts related to legacy systems and ETL processes, and proposes mitigation strategies
• .Maps business processes to supporting systems, data flows, and ETL processes, ensuring traceability and alignment between business and technical layers
• .Collaborates with business stakeholders to understand operational workflows and translate them into architectural representations
• .Promotes reuse of existing components, services, and data assets to improve efficiency and reduce duplication
• .Skill

• s
• Experience and Skill Set Requiremen
• tsTo respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as needed basi

• s.
• Major Responsibiliti
• es:Leads the analysis, documentation, and modernization of legacy system architectures, with a strong focus on understanding and mapping existing data flows, integrations, and dependencies, particularly Informatica ETL process
• es.Develops comprehensive architectural documentation (current-state and future-state), including system context diagrams, data architectures, integration patterns, and technical specificatio
• ns.Provides expert-level analysis of ETL processes (especially Informatica), identifying data lineage, transformation logic, dependencies, and opportunities for optimization, simplification, or modernizati
• on.Collaborates closely with business stakeholders, developers, and data teams to translate business requirements into scalable, maintainable, and compliant solution desig
• ns.Ensures solutions align with OPS architecture principles, Information Management standards, security policies, and regulatory requiremen
• ts.Facilitates design reviews and architectural governance processes to ensure consistency, quality, and adherence to standar
• ds.Communicates complex technical concepts clearly and effectively to both technical and non-technical stakeholde
• rs.Supports project delivery by guiding development teams, resolving design issues, and ensuring architectural integrity throughout implementati
• on.Identifies risks, constraints, and impacts related to legacy systems and ETL processes, and proposes mitigation strategi
• es.Maps business processes to supporting systems, data flows, and ETL processes, ensuring traceability and alignment between business and technical laye
• rs.Collaborates with business stakeholders to understand operational workflows and translate them into architectural representatio
• ns.Promotes reuse of existing components, services, and data assets to improve efficiency and reduce duplicati
• on.Mandatory Skil
• ls:Strong knowledge and hands-on experience with ETL tools, particularly Informatica PowerCenter and/or Informatica Cloud (IDMC), including mapping, workflows, transformations, and performance tuni
• ng.Expertise in data architecture, data integration, and data modeling, including understanding of data lineage, metadata management, and data quali
• ty.Experience documenting and analyzing legacy systems and complex integration environmen
• ts.Knowledge of Information Management principles, concepts, policies, and practic
• es.Experience developing technical and solution architecture artifacts (e.g., high-level designs, detailed designs, data flow diagrams, interface specification
• s).Understanding of OPS I&IT standards, architecture frameworks, and governance process
• es.Knowledge of AODA and accessibility standards and their impact on solution desi
• gn.Ability to assess and recommend technology solutions, tools, and integration approach
• es.Strong analytical and problem-solving skills to decompose complex systems and troubleshoot data and integration issu
• es.Ability to identify dependencies and impacts across systems and recommend effective design solutio
• ns.Strong stakeholder engagement skills, including the ability to explain architecture decisions and manage expectatio
• ns.General Skil
• ls:Leads architecture planning and strategy aligned with business and ministry objectiv
• es.Analyzes business requirements and translates them into end-to-end technical solutions and data integration desig
• ns.Develops and maintains architecture documentation, including system diagrams, data flow diagrams, and interface mappin
• gs.Provides guidance and oversight to development teams to ensure adherence to architectural standards and best practic
• es.Coordinates across multiple teams (business, data, infrastructure, application) to ensure cohesive solution delive
• ry.Identifies, assesses, and mitigates technical risks and technical debt, especially within legacy syste
• ms.Supports impact analysis for changes, releases, and enhancements across integrated syste
• ms.Ensures solutions are scalable, maintainable, secure, and cost-effecti
• ve.Promotes best practices in data integration, ETL design, and system interoperabili
• ty.Ability to bridge business and technical architecture, ensuring end-to-end traceability from business requirements through to implementati
• on.Experience producing integrated architecture documentation that connects business architecture, data architecture, and solution architectu
• re.Participates in governance forums, architecture review boards, and stakeholder meetin
• gs.Provides clear and concise reporting on architecture status, risks, and recommendations to senior stakeholde
• rs.Supports knowledge transfer and documentation to ensure sustainability of solutio
• ns.Desirable Skil
• ls:Experience with data warehousing concepts and dimensional modeli
• ng.Knowledge of modern data integration tools and cloud-based ETL platforms (e.g., Azure Data Factory, Informatica IIC
• S).Experience with API design, microservices architecture, and integration patter
• ns.Familiarity with database technologies (e.g., Oracle, SQL Server) and advanced S
• QL.Knowledge of DevOps practices and CI/CD pipelines for data and integration solutio
• ns.Experience working in public sector or OPS environments, including familiarity with governance process
• es.Exposure to data governance, data quality frameworks, and master data management (MD
• M).Evaluation Crite
• riaCriteriaWei
• ghtSolution Architecture & Legacy System Analysis Experie
• nc
• e25Documentation & Technical Design Ski
• ll
• s25ETL & Data Integration Expert
• is
• e20Stakeholder Engagement & Communication Ski
• ll
• s15Public Sector / OPS Experie
• nc

e15

Assignment Type: Hybrid (3 days in of

• fice)
• Must Haves: (10+ year of exper
• ience)Strong knowledge and hands-on experience with ETL tools, particularly Informatica PowerCenter and/or Informatica Cloud (IDMC), including mapping, workflows, transformations, and performance t
• uning.Expertise in data architecture, data integration, and data modeling, including an understanding of data lineage, metadata management, and data qu
• ality.Experience documenting and analyzing legacy systems and complex integration environ
• ments.Knowledge of Information Management principles, concepts, policies, and prac
• tices.Experience developing technical and solution architecture artifacts (e.g., high-level designs, detailed designs, data flow diagrams, interface specificat
• ions).Understanding of OPS I&IT standards, architecture frameworks, and governance proc
• esses.Knowledge of AODA and accessibility standards and their impact on solution d
• esign.Ability to assess and recommend technology solutions, tools, and integration appro
• aches.Strong analytical and problem-solving skills to decompose complex systems and troubleshoot data and integration i
• ssues.Ability to identify dependencies and impacts across systems and recommend effective design solu
• tions.Strong stakeholder engagement skills, including the ability to explain architecture decisions and manage expecta

tions.