CYNET SYSTEMS -
309 Jobs
Toronto, ON
Posted today
Job Details:
Full-time
Entry Level
Job Description:
Responsibilities:
Responsibilities:
- Document the new requirements and complete analysis and design document.
- Convert the user requirements into business model for Cognos BI.
- Convert the business model into Framework Manager Models.
- Build the security model for the BI implementation.
- Create metadata, user groups and folder structure for BI objects.
- Develop reports in Cognos on Cloud Pak for Data and AWS Redshift database.
- Test, debug, re-engineer standard reports and dashboards in Cognos on AWS.
- Support converted Dynamic Cubes functionality in DMR or Transformer Cubes without any loss in performance.
- Document test cases to ensure expected functionality of the reports.
- Deploy reports using Cognos Framework Manager.
- Develop SQL and PLSQL process and procedures to implement complex logic.
- Assist with SQL tuning and optimization activities related to the Cognos reports.
- Help to optimize the SQL and PL/SQL process for optimal report performance.
- Prepare scripts and documentation for the data preparation process and regular performance checks & monitoring.
- Support user acceptance testing and system implementation.
- Train SMEs or conduct demos on self-serve BI reporting.
- Report development for Intellihealth expansion.
- Any other deliverables as assigned by the Project/Resource Manager.
- Knowledge transfer to HSC staff in the form of a detailed guide or as per project requirements.
- Public Sector Experience.
- Experience working in the Public Sector and familiarity with I&IT project management processes.
- Experience in design and development of Data Marts or Data Warehouses on a wide range of data repositories (relational and multi-dimensional data stores).
- Experience in Cognos Analytics reporting; modeling with Framework Manager, Transformer, Dynamic Cube Designer, Data Module, Dataset, SDK; implementing point-in-time architecture; testing with Life Cycle Manager (5+ years).
- Excellent requirements analysis skills.
- Demonstrated experience in working with Power Designer Tool to design logical and physical models, generating scripts and applying model changes.
- In-depth knowledge and experience with Cognos report development in Cognos Analytics and Administration v12.x (reporting, dashboarding, embedded JavaScript, embedded SQL).
- Knowledge of BI architecture patterns, best practices, processes, and artefacts.
- Experience developing Cognos reports in the IBM Cloud Pak for Data environment.
- Core skills, database and domain knowledge.
- Experience in Oracle 19 or higher including writing complex SQL/PL SQL queries and materialized views.
- Experience in AWS Cloud technologies, specifically AWS Redshift.
- Experience in database performance and tuning skills.
- Experience in Cognos migration and testing skills (reporting, dashboarding, embedded JavaScript, embedded SQL).
- Experience with Agile/scrum and waterfall methodologies, using tools such as JIRA and Confluence.
- Proven troubleshooting and critical thinking skills.
- Strong interpersonal skills with ability to work with client stakeholders to understand, interpret business requirements and its technical implications.
Share This Job:
