RQ09595 - Software Developer - Senior

Cleo Consulting; Toronto; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A leading consulting firm in Toronto is seeking a Senior Software Developer to design and develop BI reporting systems. Candidates should have at least 3 years of experience in data warehousing, Crystal Reports, and Power BI. The role offers a hybrid work model involving 3 days onsite and 2 days remote work. Successful candidates will possess strong analytical skills and be capable of translating technical specifications into applications.

Qualifications

• 3 years experience in data warehousing BI environment.
• Strong analytical and problem-solving skills.
• Experience with ETL processes and data transfer.

Responsibilities

• Design and develop data warehousing BI reporting.
• Perform unit testing and defect fixing.
• Communicate progress clearly to management.

Skills

Analysis design

Data warehousing

SQL and PL/SQL

Informatica

Crystal Reports

Power BI

Software Development Life Cycle (SDLC)

Tools

J2EE

Oracle Database

Business Objects

Job description

Overview

Assignment: RQ09595 - Software Developer - Senior

Office Location: 87 Sir William Hearst Ave Toronto ON M3M 0B4 Toronto

Organization: Labour and Transportation Cluster

Ministry: Ministry of Transportation

Business Days: 250.00

Extension # of Days: 250.00

Hybrid - The Consultant must be able to work 3 days onsite and 2 days remote

Employment Type: Full-time

Experience: years

Vacancy: 1

Must haves

• 3 years experience in designing and developing Crystal reports Power BI and BOE reports

Description

Employment Ontario is one of the major programs delivered by the Employment and Training Division of the Ontario Ministry of Training Colleges and Universities. Employment Ontario helps the citizens of Ontario gain the training skills and experience to achieve their goals.

The Employment Ontario Information Systems (EOIS) is the major IT system that supports the administration of these programs. Application subsystems under EOIS include CaMS (Case Management System) Service Provider lifeCycle (SPL) EO Self Service (EOSS) APPR (Apprenticeship) COJG (Canada Ontario Job Grant) and APPR AOL (Apply OnLine).

The operating Environment includes J2EE CURAM Crystal Reports Oracle SQL / PL SQL Power BI Oracle Database Business Objects Universe and Dashboarding WebI and Bursting technologies and Informatica ETL.

This request is for strong developers to help in designing and developing data warehousing BI reporting and analytics.

Perform analysis design developing unit testing defect fixing and other necessary tasks in a data warehousing and BI environment in Oracle PL / SQL

Design develop and test Informatica mappings

ETL scripts to transfer and transform data from OLTP database to Data Warehouse and Data marts.

Must have skills in Crystal reports Power BI and BOE reporting

Communicate your progress clearly and timely to the management team

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.

General Skills

• Experience in programming and analysis; specialized software package support at the specified experience level
• Ability to collaborate with IT Professionals throughout the Software Development Life Cycle
• Experience in structured methodologies for the development design implementation and maintenance of applications
• Experience in design code test debug and document applications
• Experience in the use of object and / or third generation language development tools
• Experience in one or more programming languages
• Experience in application design latest design patters deployment and troubleshooting
• Experience with relational and hierarchical database technologies
• Experience in the use of information retrieval packages using query languages
• Experience with one or more communications protocols
• Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts
• Excellent analytical problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
• A team player with a track record for meeting deadlines

Desirable Skills

• Knowledge and experience with programming Internet-ready applications
• Knowledge and experience in rapid application development (RAD) methodologies
• Knowledge and understanding of Information Management principles concepts policies and practices.
• Experience with middleware and gateways
• Experience reviewing analyzing and modifying product installation scripts including encoding testing debugging
• Ability to provide post-implementation support and resolve any post-implementation technical issues
• Experience conducting design walkthrough sessions with project team
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
• Ability to provide user and system documentation as required.

Key Skills

Spring,.NET,C / C++,Go,React,OOP,C#,AWS,Data Structures,Software Development,Java,Distributed Systems

Requirements

• 3 years Experience with analysis design developing unit testing defect fixing and other necessary tasks in data warehousing BI environment.
• 3 years experience in designing and developing Crystal reports Power BI and BOE reports
• 3 years Experience in Designing developing and testing SQL and PL / SQL.
• 3 years Experience in Designing developing and testing in Informatica.
• Experience with technology solutions and development methodologies
• Experience in analyzing and designing changes to existing web-based software solutions
• Complete knowledge of SDLC methodologies e.g. Agile development.
• Experience in RDBMS design concepts.
• Experience with Data Warehouse design Reporting and ETL concepts.
• Experience with Data Warehouse architecture design dimensional modeling development and deployment of business intelligence systems.
• Communication & other Skills - 30%
• Ability to build good working relationships.
• Positive team player.
• Good verbal and written communication skills.
• Good analytical and problem-solving skills.
• Excellent ability to present to a technical and non-technical audience.

Note: This description retains the original content but reorganizes and formats it for clarity and accessibility while removing disallowed formatting.