Senior Solutions Designer (BB-5F9C4)
Found in: Talent CA
Description:We are looking for Senior Solutions Designer for our client in Toronto, ONJob Title: Senior Solutions DesignerJob Location: Toronto, ONJob Type: ContractJob Description: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 requirements and project/initiative deliverables.Key deliverables to be performed by the Solution Designer includes, but are not limited to, the following:Complete work and achieve milestones within the assigned deadlines.Consult with clients and manages business analysis in order to assess clients' business.problems/opportunities and to identify business and technology solutions suited to client needsDevelop realistic work breakdown structure and contribute in preparing overall project scheduleEnsure defined Change Management Process is followed for any change from agreed scope, schedule, or qualityLiaise with IT specialists and unit leads and work closely with support team members and relevant stakeholdersNotify the cluster/ministry project manager in writing of any issues or other material concerns related to the assignment deliverables, as soon as the becomes aware of them.Participate in discussions with Infrastructure Technology Services (ITS), Cyber Security Branch (CSB), Centre of Excellence for Accessibility and Information Privacy and Archives (IPA) Office to ensure the application remains compliant with all applicable GO-ITS Standards.Participate in discussions with the business regarding any changes required to business and system requirements.Participate in working groups and client interviews to define and document needs, processes and problem resolution.Perform daily tracking, reporting and facilitating resolution of issues and risks for all project activities.Provide analysis covering systems requirements, screen design, workflow design, gap analysis, testing, and change management in support of any application changes.Provide clarification to designers, developers, and testers at various stages of SDLC to ensure that any changes or enhancements are fully regression tested and validated.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.Skills:A team player with the ability to coordinate multiple projects with competing priorities and strict deadlinesExcellent analytical, problem-solving, and decision-making skills; verbal and written communication skills interpersonal and negotiation skills.Knowledge and experience in working in accordance with policies and procedures of the public sector client.Proven ability to lead technical teams to the successful completion of an assignment of this nature, magnitude, and complexity, and demonstrated ability to help them achieve the desired business benefits on schedule and within budget.Proven experience facilitating the resolution of I&IT and Business issues.Experience:The Programmer/Developer should have 10+ years of experience in the following:Demonstrate experience in performing gap fit analysis and impact analysis.Demonstrated advanced experience and skills using Informatica ETL tools (experience with Oracle Data Integrator also an asset).Demonstrates development and solution design experience in an environment where SQL Server, Oracle, SSIS, SSAS, SSRS, Power View, Power BI and SharePoint are used together.Demonstrates development and solution design experience with SQL Server 2012, 2016, Oracle 10. x and 11.x databases.Experience enhancing performance of ETL code and SQL Queries.Experience developing ETL routines using Informatica in a data warehousing environment or large data migration.Demonstrates experience designing and developing for WCAB AA compliance in web applications.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.Experience Designing Data warehouse components and ETL Scripts.Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components.Experience in developing the Application Code package using MS Visual Source Safe.Demonstrate experience in the analysis and planning for the modernization of large, complex multi-platform, multi-tier information technology systems.Demonstrate skills and experience with documenting deliverables outlined in Deliverables section.Experience in documenting system requirements.Experience supporting business users working on projects or programs involving multiple highly inter-dependent applications and/or data sources.Experience with requirement management, quality assurance, and change management tools.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.Extensive experience with GO-ITS standards.Knowledge and experience with public sector corporate gating and enterprise architecture checkpoints processes.Experience developing solutions involving technologies such as Informatica, Oracle DBMS, Cognos, Microsoft BI, GO-Secure, PKI, and data encryption.Knowledge Transfer:Transfer From Solution Development / Task-Based I&IT Consultant / Level 3 to Project Manager.When Knowledge Will Be Transferred:Knowledge transfer must be completed one week prior to the end of the project or one week prior to the consultant leaving the ministry.What Knowledge Will Be Transferred:All deliverables, including design/supporting/release/training documents must be checked into designated version control repositories (for example, SharePoint). All final documents and working drafts related to project requirements or solution design must be stored on designated project repositories (for example, SharePoint site, HPQC, TFS).Project manager and designated ministry staff must be regularly informed in writing (by email) of where documentation has been stored and must be provided a minimum of one walk-through of all documentation as part of the final knowledge transfer activities.How Knowledge Will Be Transferred:Knowledge will be transferred through 1 on 1 sessions, emails, document updates and document review with the team.Skills:Solution Development / Solutions Designer / Senior.Technical Experience (35%):Experience with Data Dictionary, data source to target mapping.Experience with the Process Design for applications.10+ years of demonstrated advanced experience and skills using Informatica ETL tools.Experience enhancing performance of ETL code and SQL Queries.Experience developing ETL routines using Informatica in a data warehousing environment or large data migration.Experience Designing Data warehouse components and ETL Scripts.Experience working with Microsoft SSIS and has experience with migration involving Informatica to Microsoft BI suite.Experience using PowerDesigner to review data models, as well as make changes and generate DDL's.Minimum 8 years of experience with Unix scripting.Experience working with Oracle Databases, DB2 Database, and with complex kornshell scripts.Experience in designing RDBMS SQL, DML and DDL (DB2 and Oracle) and the architectural implications associated with each platform in regards to ETL.Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components.Experience in developing the Application Code package using MS Visual Source Safe, TFS and/ or Buildmaster.Working knowledge of aggregate reporting.Core Skills (35%):Working Knowledge of systems design and development, and related methods, techniques, practices and standards enable the candidate to analyze and define clients' business and information technology requirements pertaining to data flow and data integration.Working Knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable the candidate to lead the design and development of infrastructure support projects.Document applications designs and specifications.Demonstrates Analytical and problem-solving skills to assess clients' business priorities and needs; to evaluate business and technical design alternatives.Demonstrated experience developing star schema multi-dimensional models and documenting detailed design.Project Experience and Techniques (20%):Demonstrates experience eliciting requirements, developing/consulting on options and solutions, facilitating the resolution of I&IT and Business issues.Demonstrates development and design experience with SDLC processes, Agile and Waterfall methodologies.Demonstrates experience conducting unit testing on ETL workflows.Public Sector Experience (10%):Previous public sector experience in an organization of equivalent size or complexity to public sector.Demonstrates experience designing and developing applications that comply with GOITS standards would be an asset.
calendar_today5 days ago