Job Description

Note:

This position is currently listed as "Hybrid" 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.

• Candidate needs to be in office- 3 days in a week

Mandatory documents: * Kindly provide updated Resume in word format.

• Kindly provide attached Skills Matrix and References after filling.

Job Title: RQ05758 - Software Developer - Senior

Client: Ministry of Transportation

Work Location: Toronto, Ontario, Hybrid

Estimated Start Date: 2023-07-10

Estimated End Date: 2024-03-31

#Business Days: 183.00

Extension: 253.00

Hours per day or Week: 7.25 hours per day

Security Level: No Clearance Required

Mandatory Requirements:

• Experience with analysis, design, developing, unit testing, defect fixing and other necessary tasks in data warehousing, BI environment
• Experience in Designing, developing and testing SQL and PL/SQL
• Experience in Designing, developing and testing in Informatica

Nice to have

• Experience in BOE dashboards, universes & reports, PowerBI, Crystal Reports

Kindly share the following documents to by Wednesday, August 9 at 10:00 AM EST

Description

Responsibilities:

• 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 in structured methodologies for the design, development, implementation and maintenance of applications
• 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

\xe2\x80\x98Employment Ontario\xe2\x80\x99 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 an datawarehousing and BI environemnt in Oracle PL/SQL

• Design, develop and test Informatica mappings
• ETL scripts to transfer and transform data from OLTP database to Data Warehouse and Datamarts.
• Communicate your progress clearly and timely to the management team

Technical Skills

• 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

70%

Communication Skills

• Excellent analytical, problem-solving and decision making skills
• Leadership and collaboration skills
• Proven track record for building strong working relationships
• A demonstrated team player with a track record for meeting deadlines
• Strong verbal and written communication skills

30%

Powered by JazzHR

S M Software Solutions Inc