Job Title - Solutions Designer – Senior

Period:  12 months

Start Date – 2022-04-01

End Date – 2023-03-31

Location – Toronto

Working Hrs.: 7.25 Hrs. / day

A note on Assignment Type: This position is currently listed as "Onsite"; however, the consultant will be remote due to COVID-19 related Work from Home (WFH) direction. Once the I&IT cluster staff are required to return to the office, the resource under this request will be required to work onsite as well.

Must Haves:

Hands-on experience with large BI solutions

Extensive experience with Informatica

Some work required doing Cognos reporting/development

Experience with migrating to PowerBI

AODA/WCAG experience

Demonstrates experience designing, developing, and implementing Informatica ETL solutions.

Responsibilities: 

Undertakes the design of hosting technology solutions based on the client's service specifications, standards, policies, best practices and cost models, in order to meet client application business requirement and project/initiative deliverables. The consultant will provide services under the direction of the Senior Technical Manager and Project Manager.

Key deliverables to be performed by the consultants include, but are not limited to, the following:

Participating in the analysis, design, development, and unit testing of all the project’s ETL components i.e. Mappings, Workflows, Data Mart.

Develop ETL routines and scripts based on submitted designs.

Developing, testing, and deploying full code package for the solution in Visual Source Safe (VSS) and Team Foundation Server (TFS).

Participating in project design and code walkthrough.

Provide input and complete architectural artifacts.

Provide input in creation of change requests.

Provide knowledge and skill transfer to a designated cluster/ministry staff.

Provides expertise and assistance to cluster functional areas and external service providers in delivering effective technology solutions to clients.

Submit deliverables for the cluster/ministry approval.

Support the analysis of existing business processes, design and recommend process improvements to effectively harness the benefits of using the application(s).

Work closely with the director, managers, and staff on issues and business needs.

Work collaboratively with other groups to ensure optimal integration.

Comply with the Ontario government and the cluster/ministry’s guidelines, standards and procedures such as:architecture/ technology standards and best practices conflict of interest and confidentiality guidelines security procedures and practices Ontario Government.

I&IT Directive, operational policy on the I&IT project gateway process; and other applicable guidelines, standards and procedures.

All General Skills outlined in the “Task-Based I&IT Services” Agreement Solution Designer, Senior.

Demonstrated development and solution design experience in an environment where Oracle, Informatica and Cognos are used together.

Demonstrated experience designing, developing, and implementing Informatica ETL solutions.

Demonstrated experience developing the Application Code package using MS Visual Source Safe (VSS), Team Foundation Server (TFS) and documenting code changes.

Demonstrated experience in working with and analyzing large and diverse data sets, data visualization, KPI development and data profiling to identify relationships and themes.

Demonstrated experience manipulating and analyzing complex, high-volume data from structured and unstructured sources.

Demonstrated experience creating detailed documentation for the tools that are developed, such as business requirements, system requirements and technical requirements.

Demonstrated experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specifications.

Demonstrated experience eliciting requirements, developing/consulting on options and solutions, facilitating the resolution of I&IT and Business issues, and providing effective guidance to Ministry clients.

Demonstrated development and solution design experience with Oracle 11.x and 12.x databases.

Demonstrated experience constructing complex query statements and enhancing performance of SQL Queries.

Demonstrated experience designing technology solutions and working on projects within a multi-client/partner environment, involving multiple highly inter-dependent applications and/ or data sources.

Demonstrated experience developing star schema multi-dimensional models and documenting detailed design models.

Demonstrated analytical, problem-solving, decision-making skills, interpersonal and negotiation skills.

Demonstrated experience performing system testing and unit testing, and conducting SIT, SAT and UAT Testing.

Demonstrated development and design experience with SDLC processes, Agile and Waterfall methodologies.

Demonstrated written and oral communication skills, as well as presentation skills to technical and non-technical audiences.

Demonstrated ability to work collaboratively, with the ability to coordinate multiple projects with competing priorities and a track record for meeting strict deadlines.

Demonstrate experience in managing deployment processes and hand-off, documentation and KT to operation and other teams.

Experience and Skill Set Requirements

Technical Experience - 40%

Demonstrates experience designing, developing, and implementing Informatica ETL solutions.

Demonstrates development and solution design experience in an environment where Oracle, Informatica and Cognos are used together for data warehousing and business intelligence.

Demonstrates experience developing the Application Code package using MS Visual Source Safe (VSS), Team Foundation Server (TFS) and documenting code changes.

Demonstrates working experience in debugging mappings, transformations, mapplets and source qualifier ETL components.

Demonstrates development and solution design experience with Oracle 11.x and 12.x databases.

Demonstrates experience constructing complex query statements and enhancing performance of SQL Queries.

Demonstrates experience designing and developing Unix shell scripts.

Demonstrates Experience using PowerDesigner to review data models, as well as make changes and generate DDL scripts.

Demonstrate experience designing, developing and implementing Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.

Experience with data transfer technologies such as Microsoft MQ, SSIS, SSRS, SSAS.

Experience in leading development and modelling of applications, specifically hierarchical data model applications.

Core Skills - 35%

Demonstrates development and solution design experience with technology, data, databases, statistics, applications, and networking techniques, tools and practices that enables the candidate to lead the design and development of business intelligence projects.

Demonstrates experience in working with and analyzing large and diverse data sets, data visualization, KPI development and data profiling to identify relationships and themes.

Demonstrates experience manipulating and analyzing complex, high-volume data from structured and unstructured sources.

Demonstrates experience creating detailed documentation for the tools that are developed, such as business requirements, system requirements and technical requirements.

Demonstrated experience developing star schema multi-dimensional models and documenting detailed design models.

Demonstrates experience with advanced data visualization tools and techniques, designing high quality interfaces to present information in a meaningful way.

Troubleshooting of production issues and creating fixes for any unplanned deployments.

Defect investigation, resolution and assignment to team members using defect/issue.

management tools, e. g. HP ALM or HP Service Manager.

Demonstrated experience in coordinating and planning for the modernization of large, complex multi-platform, multitier information technology systems.

Proven experience using a variety of methodologies to carry-out the software development lifecycle (e.g., Agile, waterfall, etc.).

Experience with Azure DevOps.

Experience with AODA/WCAG compliance.

Project Experience and Techniques - 15%

Demonstrates development and design experience with SDLC processes, Agile and Waterfall methodologies.

Demonstrates experience conducting system testing and unit testing, and conducting SIT, SAT and UAT Testing.

Demonstrates experience communicating regarding day-to-day tasks and issue tracking, reporting and facilitating resolution of issues and risks for all project activities.

Demonstrates experience gathering and consolidating input into changes required to business and/or system requirements, change requests, project artefacts, as well as leading requirement gathering sessions.

General Skills - 5%

Demonstrates experience problem solving and decision making.

Demonstrates experience communicating clearly in both written and verbal formats.

Demonstrates experience working with and leading multiple teams representing various areas in delivering the project.

Demonstrates ability to work collaboratively, with the ability to coordinate multiple projects with competing priorities and a track record for meeting strict deadlines.

Demonstrates experience working collaboratively with other team members and/or groups and leading a team to ensure optimal solution integration.

Demonstrates experience leading a team and with providing technical advice and guidance.

Demonstrates experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specifications.

Organization Experience - 5%

Previous public sector experience in an organization of equivalent size.

If you are available, please send your resume to deepti.gill@2iresourcing.ca OR refer someone interested.