M

RQ11023 - Solutions Designer - Senior

icon building Company : Maarut Inc
icon briefcase Job Type : Full Time

Number of Applicants

 : 

000+

Click to reveal the number of candidates who applied for this job.
icon loader
Apply Now
icon loader Apply Now

Let AI Supercharge Your Job Hunt!

JobCopilot scans 500,000+ company career sites daily to find jobs for you

Never miss an opportunity Save hours by auto-filling applications forms Land more interviews with tailored applications
happy man
thunder iconActivate JobCopilot

Job Description - RQ11023 - Solutions Designer - Senior


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





























Criteria
Weight
Solution Architecture & Legacy System Analysis Experience
25
Documentation & Technical Design Skills
25
ETL & Data Integration Expertise
20
Stakeholder Engagement & Communication Skills
15
Public Sector / OPS Experience
15
















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.







Original job RQ11023 - Solutions Designer - Senior posted on GrabJobs ©. To flag any issues with this job please use the Report Job button on GrabJobs.
Apply Now
Share Job
Share Job

Auto-Apply to Solutions Designer Jobs with your AI JobCopilot

thunder icon Auto-Apply with AI

Similar Solutions Designer Jobs in Canada

GrabJobs is the no1 job portal in Canada, connecting you to thousands of jobs fast! Find the best jobs in Canada, apply in 1 click and get a job today!

Mobile Apps

Copyright © 2026 Grabjobs Pte.Ltd. All Rights Reserved.