Cognos Informatica Developer

Oracle are used together
Proven design and development experience as a Cognos BI Programmer/Developer
Proven experience in debugging BI defects and errors as they relate to queries, Framework
Manager, Reports, Cubes or Dashboards
Experience in developing the Application Code package using MS Visual Source Safe or Team Foundation Server.
Demonstrated advanced skills using Oracle Data Integrator and Informatica;
Analyse the new development needs and design, develop and unit test all the project’s
Cognos components; i.e. Framework Manager, reports, cubes, and dashboards;
Demonstrated development experience in an environment where SQL Server, Oracle, SSIS,
SSAS, SSRS, Power BI and SharePoint are used together;
Demonstrated development experience with SQL Server 2012, 2016, Oracle 10.x and 11.x databases
Demonstrated experience with designing and developing using the Microsoft suite of BI tools
(SQL Server, SSIS, SSAS, SSRS, Power BI) together RQ04827

Advantages
Long Term Contract
Pay Every Week
Office is close to College subway station

Responsibilities
The BI Programmer/Developer must have a minimum of 5+ years of the following skills and experience:
Demonstrated experience in performing gap fit analysis and impact analysis;
Strong working experience in an environment where Cognos (version 11), Informatica and
Oracle are used together
Proven design and development experience as a Cognos BI Programmer/Developer
Proven experience in debugging BI defects and errors as they relate to queries, Framework
Manager, Reports, Cubes or Dashboards
Experience in developing the Application Code package using MS Visual Source Safe or Team Foundation Server.
Demonstrated advanced skills using Oracle Data Integrator and Informatica;
Analyse the new development needs and design, develop and unit test all the project’s
Cognos components; i.e. Framework Manager, reports, cubes, and dashboards;
Demonstrated development experience in an environment where SQL Server, Oracle, SSIS,
SSAS, SSRS, Power BI and SharePoint are used together;
Demonstrated development experience with SQL Server 2012, 2016, Oracle 10.x and 11.x databases
Demonstrated experience with designing and developing using the Microsoft suite of BI tools
(SQL Server, SSIS, SSAS, SSRS, Power BI) together
Experience implementing star schema multi-dimensional models;
Experience in database management and administration;
Experience enhancing performance of SQL Queries;

Qualifications
8+ years demonstrated experience with Cognos
Demonstrated experience with developing Cognos reports, dashboards, storyboards, and data visualization techniques
Demonstrated experience in developing using Cognos version 11
Demonstrated experience creating Active Reports
Demonstrated experience with developing Cognos Cubes and in Cognos Query Studio
Demonstrated experience working with Cognos Framework manager and writing specifications for development of reports and other enhancements to BI reports and solutions
Participating in the analysis, design, development, and unit testing of all the project’s
ETL components i.e. Mappings, Workflows, Data Mart; Reports, Cubes, and Dashboards;
Demonstrates experience building cube for Microsoft BI report purposes
Demonstrates design and development experience as a full stack Microsoft BI tools (SQL Server, SSIS, SSAS, SSRS, Power BI) together

Summary
Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
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 tests.
Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.