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.
Requirements Mandatory Skills:
- Strong knowledge and hands-on experience with ETL tools, particularly Informatica PowerCenter and/or Informatica Cloud (IDMC), including mapping, workflows, transformations, and performance tuning.
- Expertise in data architecture, data integration, and data modeling, including understanding of data lineage, metadata management, and data quality.
- Experience documenting and analyzing legacy systems and complex integration environments.
- Knowledge of Information Management principles, concepts, policies, and practices.
- Experience developing technical and solution architecture artifacts (e.g., high-level designs, detailed designs, data flow diagrams, interface specifications).
- Understanding of OPS I&IT standards, architecture frameworks, and governance processes.
- Knowledge of AODA and accessibility standards and their impact on solution design.
- Ability to assess and recommend technology solutions, tools, and integration approaches.
- Strong analytical and problem-solving skills to decompose complex systems and troubleshoot data and integration issues.
- Ability to identify dependencies and impacts across systems and recommend effective design solutions.
- Strong stakeholder engagement skills, including the ability to explain architecture decisions and manage expectations.
General Skills:
- Leads architecture planning and strategy aligned with business and ministry objectives.
- Analyzes business requirements and translates them into end-to-end technical solutions and data integration designs.
- Develops and maintains architecture documentation, including system diagrams, data flow diagrams, and interface mappings.
- Provides guidance and oversight to development teams to ensure adherence to architectural standards and best practices.
- Coordinates across multiple teams (business, data, infrastructure, application) to ensure cohesive solution delivery.
- Identifies, assesses, and mitigates technical risks and technical debt, especially within legacy systems.
- Supports impact analysis for changes, releases, and enhancements across integrated systems.
- Ensures solutions are scalable, maintainable, secure, and cost-effective.
- Promotes best practices in data integration, ETL design, and system interoperability.
- Ability to bridge business and technical architecture, ensuring end-to-end traceability from business requirements through to implementation.
- Experience producing integrated architecture documentation that connects business architecture, data architecture, and solution architecture.
- Participates in governance forums, architecture review boards, and stakeholder meetings.
- Provides clear and concise reporting on architecture status, risks, and recommendations to senior stakeholders.
- Supports knowledge transfer and documentation to ensure sustainability of solutions.
Desirable Skills:
- Experience with data warehousing concepts and dimensional modeling.
- Knowledge of modern data integration tools and cloud-based ETL platforms (e.g., Azure Data Factory, Informatica IICS).
- Experience with API design, microservices architecture, and integration patterns.
- Familiarity with database technologies (e.g., Oracle, SQL Server) and advanced SQL.
- Knowledge of DevOps practices and CI/CD pipelines for data and integration solutions.
- Experience working in public sector or OPS environments, including familiarity with governance processes.
- Exposure to data governance, data quality frameworks, and master data management (MDM).
Evaluation Criteria:
Solution Architecture & Legacy System Analysis Experience
Documentation & Technical Design Skills
ETL & Data Integration Expertise
Stakeholder Engagement & Communication Skills
Public Sector / OPS Experience
Must Haves: (10+ year of experience)
- Strong knowledge and hands-on experience with ETL tools, particularly Informatica PowerCenter and/or Informatica Cloud (IDMC), including mapping, workflows, transformations, and performance tuning.
- Expertise in data architecture, data integration, and data modeling, including an understanding of data lineage, metadata management, and data quality.
- Experience documenting and analyzing legacy systems and complex integration environments.
- Knowledge of Information Management principles, concepts, policies, and practices.
- Experience developing technical and solution architecture artifacts (e.g., high-level designs, detailed designs, data flow diagrams, interface specifications).
- Understanding of OPS I&IT standards, architecture frameworks, and governance processes.
- Knowledge of AODA and accessibility standards and their impact on solution design.
- Ability to assess and recommend technology solutions, tools, and integration approaches.
- Strong analytical and problem-solving skills to decompose complex systems and troubleshoot data and integration issues.
- Ability to identify dependencies and impacts across systems and recommend effective design solutions.
- Strong stakeholder engagement skills, including the ability to explain architecture decisions and manage expectations.
#IMPJOB
Pay: $62.11-$100.00 per hour
Work Location: In person
