Assignment: RQ06700 - Software Developer - Senior

Job Title: Senior ETL Developer

Requisition (SS): RQ06700

Start Date: 2024-07-05

End Date: 2025-03-31

Client: Justice Technology Services

Office Location: 595 Bay Street, Toronto

Organization: Justice Technology Services

Ministry: Ministry of Solicitor General

# Business Days: 183.00

Note: This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00-5:00 PM (excluding lunch breaks) Monday to Friday inclusive for three (3) days onsite and two (2) days remote (offsite), unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the assigned Project.

Must Haves:

• A minimum of 5 years knowledge of, experience with, and proven skills:
• Programming Languages: Visual Basic .NET, C#, VB script, ANSI-SQL, PL-SQL
• Developing and supporting ETL's (extract, load, transform)
• Creating report using SQL Reporting Services
• Developing and supporting applications using Windows Forms, C#, and PL/SQL using Visual Studio 2010, 2012 & 2015

Description

SCOPE:

The Office of the Public Guardian and Trustee (OPGT) requires a Software Developer L3 with 5+ years of application development and support experience with Microsoft .NET framework, C#, VB.NET, Oracle, SQL Server, Access to work on the Case Management System (PGTed), Enterprise Reporting System, and other applications.

The primary objective of this project is to assist in the support and enhancements to the functionality of the OPGT's Case Management Systems.

DELIVERABLES:

• Provide support to production environments including the case management system (PGTED) and data warehouse.
• Develop, support, and maintain ETL (Extract, Transform and Load) processes.
• Support and maintain the batch programs for over 80 data interfaces.
• Document all modifications and enhancements made following existing standards including development of detailed programming specifications, user interface designs, prototypes, writing and/or generating code.

Experience and Skill Set Requirements

• The VOR Master Service Agreement which expires on April 5, 2025, leaves some Contracts with funding unassigned for fiscal 2024-25. If the current statement of work expires on March 31, 2025, the remaining funds can be used to exercise an option to extend the SOW beyond March 31, 2025, based on business case approvals. Such extensions will be allowable, only if the Master Service Agreement is extended beyond April 5, 2025, and be upon the same terms, conditions, and covenants contained in the SOW.

SKILLS AND KNOWLEDGE:

Knowledge of, experience with, and proven skills with the following:

• Programming Languages: C#, ANSI-SQL, PL-SQL, Visual Basic .NET, VB script
• Databases: SQL Server 2012 - 2019, Oracle 11g & 12
• Operating Systems: Windows 10 and later, Windows Server 2012 and later
• Experience with, and proven skills (within the last 5 years) in developing and supporting ETL's
• Experience in creating report using SQL Reporting Services
• Experience with, and proven skills in developing and supporting applications using Windows Forms, C#, and PL/SQL using Visual Studio 2010, 2012 & 2015

Experience of the following development tools:

• Team Foundations Server (TFS) - for source code management, reporting, requirements management
• Project management (Scrum development model), automated builds, testing, and release management)
• Architecture: N-Tier Client-Server and Internet Application Architectures (.NET), Component-Based Design (COM+), Architectural Design Patterns, Systems Integration
• Toad for Oracle, SQL Server Management Studio & SQL Server Reporting Services
• System Design: Object Oriented Analysis, Design and Programming, UML, Relational Database Design, User Interface Design, Network / Environment Design.
• Other Tools: IIS, ADO, XML / XSL, Web Services, SOAP, Visio, SharePoint foundation Services 2010-2013
• A team player with a track record for meeting strict deadlines
• Knowledge and understanding of business modeling, and use case modeling
• Analytical, problem solving and decision-making skills; organizational, creativity and perseverance skills
• Experience with relational database technologies
• Knowledge and experience in the implementation of a mechanism for document generation and field-population from disparate data sources
• Excellent verbal and written communication skills
• Highly developed interpersonal skills

CRITERIA

Criteria 1 - Solution Development (35 Points)

Demonstrated experience with:

• Programming Languages: VB script, C#, ANSI-SQL PL SQL, Visual Basic .NET
• Architecture: N-Tier Client-Server and Internet Application Architectures (.NET), Component-Based Design (COM+), Architectural Design Patterns, Systems Integration
• System Design: Object Oriented Analysis, Design and Programming, UML, Relational Database Design, User Interface Design, Network / Environment Design
• Developing scripts and stored procedures in PL/SQL and Transact-SQL Write or change, maintain, unit & system test and supporting ETL's

Criteria 2 - Technical Skills (35 Points)

• 5+ years of professional experience in software development, specifically with C# .NET
• 5+ years of experience leading others technically, including providing coaching and mentoring as well as ensuring high code quality and adherence to standards
• 5+ years of experience including ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC))
• Ability to fully support all phases of the software development lifecycle (SDLC)
• Ability to review requirements, translate these requirements into a design, implement and fully test this design; testing experience should include all aspects of testing (unit, functional, integration, end-to-end)
• Production implementation and support

Criteria 3 - SQL Server Reporting (15 Points)

• 5+ years of experience in writing or changing, maintaining and supporting reports using SQL Server Reporting Services.
• SQL Server Reporting Services deployment and portal customization; complex report design and implementation including drill-down and charting

Criteria 4 - Analytical and Communications Skills (15 Points)

• Excellent analytical, problem-solving and decision-making skills
• Strong verbal and written communication skills
• Strong interpersonal skills
• A team player with a track record for meeting deadlines