Solutions Designer - Senior

Job ID: RQ11023 - Solutions Designer - Senior

Job Description:

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.

Mandatory Skills: (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 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:

• Develops and maintains architecture documentation, including system diagrams, data flow diagrams, and interface mappings .

• Identifies, assesses, and mitigates technical risks and technical debt , especially within legacy systems.

• Supports impact analysis for changes, releases, and enhancements across integrated systems.

• 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.

• 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.