Solution Designer

2 weeks ago

Toronto, Ontario, Canada CloudVital Full time $80,000 - $120,000 per year

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

  • Solution Designer

    1 day ago

    Toronto, Ontario, Canada Alithya Full time

    Our mission, your futureAs a global network of trusted advisors, we create cutting-edge technological solutions to overcome today's challenges and anticipate tomorrow's needs. It all starts with the collaboration of a diverse team of passionate innovators, each driven to make a difference. Together, we challenge the status quo and push each other to new...

  • Data Solutions Designer

    1 day ago

    Toronto, Ontario, Canada CI Financial Full time $120,000 - $180,000 per year

    DescriptionAt CI, we see a great place to work as one that is a safe place for everyone to have a voice, where people are empowered to take ownership over meaningful work, where there is an opportunity to grow through stretching themselves, where they can work on innovative products and projects, and where employees are supported and engaged in doing so.  ...

  • Solutions Design IT Specialist

    5 days ago

    Toronto, Ontario, Canada TD Full time $125,000 - $156,000 per year

    Work Location:Toronto, Ontario, CanadaHours:37.5Line of Business:Technology SolutionsPay Details:$125,000 - $156,000 CADThis role is eligible for a discretionary variable compensation award that considers business and individual performance.TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and...

  • Lead IT Solution Designer

    7 days ago

    Toronto, Ontario, Canada Capco Full time $120,000 - $180,000 per year

    Capco – The Future. Now.Capco is a distinctly and positively different place to work. Much more than consultants, we are active participants in the global financial services industry. Our passionate business and technology professionals enjoy a unique environment where they are actively encouraged to apply intellect, innovation, experience and teamwork. We...

  • Solutions Design IT Specialist

    7 days ago

    Toronto, Ontario, Canada TD Full time $125,000 - $156,000

    Work Location:Toronto, Ontario, CanadaHours:37.5Line of Business:Technology SolutionsPay Details:$125,000 - $156,000 CADThis role is eligible for a discretionary variable compensation award that considers business and individual performance.TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and...

  • Designer de solutions

    2 weeks ago

    Toronto, Ontario, Canada Alithya Full time $90,000 - $120,000 per year

    Notre mission, votre avenirEn tant que réseau mondial de conseillers et conseillères de confiance, nous créons des solutions technologiques de pointe pour relever les défis d'aujourd'hui et anticiper les besoins de demain. Tout commence par la collaboration d'une équipe diversifiée d'innovateurs passionnés et d'innovatrices passionnées ayant la...

  • Senior Solutions Designer

    2 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time $120,000 - $180,000 per year

    Responsibilities/Assignment Deliverables:Technical Leadership, coordination, and facilitation as required for the RLSO Maintenance and Support tasks.Collaborate with RLSO solution vendor, project teams, solution architects, SDC/ITS, LTC IAST staff and third parties engaged to facilitate agreement on and acceptance of the solution for RLSO technical issues or...

  • Guidewire Solution Designer

    1 week ago

    Toronto, Ontario, Canada Cognizant Technology Solutions Full time $100,000 - $150,000 per year

    About Us:Cognizant is one of the world's leading professional services companies, redefining clients' business, operating, and technology models for the digital era. Our outstanding industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S. Learn how Cognizant helps clients...

  • Sr. Consultant, Solution Design

    2 weeks ago

    Toronto, Ontario, Canada CIBC Full time $80,000 - $120,000 per year

    We're building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what's right for our clients.At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are and...

  • Sr. Consultant, Solution Design

    1 week ago

    Toronto, Ontario, Canada CIBC Full time $120,000 - $180,000 per year

    We're building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what's right for our clients.At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are and...