Solutions Designer - Senior

Job Description Solutions Designer - Senior

for our direct client Province of Ontario.

Job ID: RQ11023 - Solutions Designer - Senior

Client : Land & Resources Cluster

Location : 40 St Clair Ave W, Toronto , Ontario

Duration: 05 months + Extension

Type: Hybrid (3 days Onsite, 2 Days Remote)

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, simplificat...