Solution Designer

We are hiring for Solution Designer for one our reputed client. Job Title: Solution Designer Job Type: Full Time/ Contract Job Location: Toronto This is an onsite role located in Toronto, requiring you to work in the office 4 to 5 days a week. Scope of Services and Deliverables - The Services and Deliverables to be provided by the Vendor will include the following: · Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc. · Deliver detailed system design documents and any other supporting documentation conforming. · Design logical and physical data models using Sybase Power Designer. · Produce transformation mapping document. · Implement data pipelines using Azure Data Factory (ADF), stored procedure, and Informatica PowerCenter performing extraction, transformation, and loading activities. · Implement solutions using Logic App and Function App. · Generate structured JSON file using ADF/ SQL. · Develop Azure CI/CD pipeline to automate ADF release. · Develop complex Oracle PL/SQL program to fulfill project requirements. · Implement complex data conversion, e.g., binary to character, EBCDIC to UTF. · Implement complex data transformation(s) for derived and calculated values. · Integrate data sets from diverse source systems. · Implement ADF for initial data load and incremental load. · Promote ADF and Informatica ETL/ELT including Development, Integration Testing, QA, UAT, Production. · Resolve and troubleshoot ADF pipeline, stored procedure, and Informatica workflow technical problems. · Monitor and analyze incident, provide timely resolution. · Collaborate with IT Professionals throughout the Software Development Life Cycle. · Document information from diverse business area stakeholders and subject matter experts. · Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow. · Monitor application functionality and performance on daily basis. Must haves: Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation. If interested, please apply via LinkedIn and share your profiles at hr@cludvital.ca

Location: Canada, CA

Posted Date: 11/5/2025