Job Description :
Title: Task-Based I&IT Consultant - Level 3 Location: Toronto, ON Next Week End Date:2021-08-30 Assignment Type: Onsite Security Level: No Clearance Required # Business Days: 184.00 Description MSP Intake Notes *Note that the start date is ASAP, start date is backdated for budget reasons Looking for a Cognos developer to join a modernization project. The resource will be building Cognos Reports and will need to have a strong understanding of ETL business rules. Must Haves (please read full description) PowerBI + SSIS ETL Cognos Reporting Oracle Maximum number of Submissions per vendor: 1 Shortlisting deadline: Friday January 8th at 10:00am EST 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. Responsibilities: Works in partnership with clients, advising them how to use information management (IM) and/or information technology in order to meet their business objectives or overcome problems, work to improve the structure and efficiency of an organziation's I&IT Systems. The Task-based I&IT Consultant may be used to provide strategic guidance to organizations with regard to IM and Task-based IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT. they can also be used to provide subject matter expertise during the procurement as well as providing highly expert technical assistance. Knowledge Transfer Transfer From Solution Development / Task-Based I&IT Consultant / 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. Note: This position is currently listed as onsite but due to COVID-19 restrictions the consultant will be working remotely until restrictions are lifted. Note: This procurement will also include the option to extend the end date of the project if there are unused effort days and no change to the ceiling amount if the need arises. Skills Experience and Skill Set Requirements Experience and Skill Set Requirements Task-Based Consultant / Level 3 Technical Skills - Working knowledge of the entire Data Dictionary, data mapping Working knowledge of the Business Process Design Re-engineering for applications 5+ years of demonstrated experience and skills using Oracle Data Integrator and/or Informatica ETL tools Experience enhancing performance of ETL code and SQL Queries Experience developing ETL routines using Informatica and/or SSIS in a data warehousing environment or large data migration Experience Designing Data warehouse components and ETL Scripts Experience using PowerDesigner to review data models, as well as make changes and generate DDL's 5+ years of experience with Unix scripting Experience working with Oracle Databases (version 10.x or higher), 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