Our Client in the Ontario Public Sector is looking for a COGNOS Developer on a 12 month contractMust Haves:BI Solutions software developer, specifically in COGNOSETL experience (Informatica) and Data MappingWCAG AA 2.0 experiencePower BI migration experience Participating in the analysis, design, development, and unit testing of all the project’s BIcomponents i.e. Data Mart; Reports, Cubes, and Dashboards; Developing Cubes, Reports, and Dashboards using IBM Cognos & Microsoft Power BI, SSRS, SSAS, SSISRQ02020 AdvantagesWork From HomeLong Term ContractPAYMENT EVERY WEEK Working in the Ontario PublicRQ02020 ResponsibilitiesResponsibilities:Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit testsQualificationsParticipating in the analysis, design, development, and unit testing of all the project’s BIcomponents i.e. Data Mart; Reports, Cubes, and Dashboards; Developing Cubes, Reports, and Dashboards using IBM Cognos & Microsoft Power BI, SSRS, SSAS, SSISProven Infomatica ETL development experience in a complex environmentStrong working experience in an environment where Informatica (vers 9.x or higher), DB2 orOracle, and Sun Solaris are used togetherExperience working with Oracle 10.x and 11.x databasesCognos, GO-Secure, PKI, and data encryption.Creating and/or updating data processing overview, technical design, source to target mapping, operation manual and other technical documentation;Participating in project design and code walkthroughs;Complete work and achieve milestones within the assigned deadlines;Consults with clients and manages business analysis in order to assess clients' business problems/opportunities and to identify business and technology solutions suited to client needs;Develop realistic work breakdown structure and contribute in preparing overall project schedule;Ensure defined Change Management Process is followed for any change from agreed scope, schedule, or quality;Lead discussions with the business regarding any changes required to business and/or system requirements;Liaise with IT specialists and unit leads and work closely with support team members and relevant stakeholders;Notify the cluster/ministry project manager in writing of any issues or other material concerns related to the assignment deliverables, as soon as the he/she becomes aware of them;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 and complete architectural artifacts;Provide input in creation of change requests;Provide knowledge and skill transfer to a designated cluster/ministry staff;Participate in the analysis, design, development and testing of new and existing projects;Analyze the new development needs and design, develop and unit test all the project’s ETL components i.e. mappings, sessions, and workflows;Assess the performance of existing ETL components and develop performance enhancements; Develop ETL process overview and ETL design documents including Informatica batches, load flows document; Participate in the SIT testing and support the System Acceptance and User Acceptance Testing;Develop, test and deploy full code package for projects in MS Visual Source Safe or Team Foundation Server;Create and update build, deployment and other technical documentations to ensure a thorough record of solution delivery and a smooth transition to operations; and Participate in project design and code walkthroughs.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.SummaryThe Advanced Analytics Unit of DDSB works on many different initiatives in the Data Collection, Data Warehouse and Business Intelligence area. These tools collect data and transform it into meaningful information, enabling evidence-based strategic, tactical, and operational insights and decision-making. Client Ministries have access to historical, current and predictive views of business operations, increasing the analysis capacity of decision makers.Randstad Canada is committed to building a diverse workforce reflective of the diversity of Canada. As a result, we promote employment equity and encourage candidates, especially those who identify as a woman, an Aboriginal person, a person with a disability or a member of a visible minority group, and any others who may contribute to the diversification of our workforce, to apply.Randstad Canada is also committed to developing an inclusive, barrier-free selection processes and work environments.If contacted in relation to a job opportunity, you should advise your Randstad Representative or your local Randstad branch in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner.Information received relating to accommodation measures will be addressed confidentially.For all feedback on equity and accommodation needs, please contact your local Randstad Canada Branch.