.Net Developer

MUST HAVES:

• 10 years of experience in the following:
• Designing and developing large complex provincial level financial allocation and payment tracking system Framework C# Web Form MVC and using DevExpress components;
• Designing and developing ETL scripts for data extraction and data loading from MS SQL database to target Oracle database using Python SQL stored procedure and SQL Server Integration Services (SSIS);

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
• Additional Skills for Oracle Software Developer:
• Experience in conducting impact assessments on Oracle E-Business application customizations and extensions.
• Strong conversion experience in Account Receivable Collection modules
• Strong programming skills in Oracle database PL/SQL SQL XML Unix shell scripts and Oracle Data Integrator
• Proved business knowledge of General Ledger Accounts Receivable Collections Accounts Payable and Inventory Modules of Oracle E-Business
• Great knowledge of Oracle E-Business table structure related to GL AR Collections AP INV and FND
• Strong knowledge of SQL tuning and using partition tables
• Demonstrated experience and understanding of data warehouse ETL methodologies and OBIEE
• Demonstrated work experience on Java and Oracle Application Development Framework (ADF) will be a great asset
• Strong verbal and written communication skills and leadership abilities to be able to oversee the quality assurance of the project from technical perspective

NOTE

• Assignment Type: This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.
• Extension/Amendment Attestation:
• Extensions are permitted only to the extent of unused contract days and/or remaining contract funds. No additional funds will be added beyond the maximum contract value including any extension options set out in the original SOW.
• HSC may exercise its option to extend the SOW beyond October 5 2027 provided that the Master Service Agreement is extended. Any such extension shall be on the same terms conditions and covenants as those contained in the SOW.

Experience and Skill Set Requirements

Public Sector Experience - 5 points

• Demonstrated knowledge and experience with Public Sector governance methodologies (e.g. UPM architecture gating);
• Demonstrated understanding of Public Sector/ministries I&IT strategies plans policies directives best practices and standards to ensure compliance in the development co-ordination and implementation of projects.

Solution Design Experience - 40 points

• 10 years of experience in the following:
• Designing and developing large complex provincial level financial allocation and payment tracking system Framework C# Web Form MVC and using DevExpress components;
• Reverse engineering data models from existing applications and databases;
• Designing and developing ETL scripts for data extraction and data loading from MS SQL database to target Oracle database using Python SQL stored procedure and SQL Server Integration Services (SSIS);
• UI/UX Design to comply with WCAG 2.1 or AODA;
• Building enterprise level software automation process using CI/CD pipelines and tool chains on DevOps platform.

Hands on Technical Experience / Knowledge Areas - 30 points

• 10 years of experience in the following:
• Hands-on Web Form MVC development experience install and configure MS Framework SQL Server environment;
• Hands-on experience with relational database design and development in MS SQL Server environment;
• Designing and developing RESTful web services JSON and XML;
• Project development experience with Azure Boards Azure Git and Azure DevOps;
• Designing and developing user authentication using MS Active Directory online or within corporate domain
• Experience with Cloud Platform using PaaS such as Azure Managed Application Services Docker and Kubernetes;
• Post-implementation support.

Project Experience Team Collaboration Communication and General Skills - 25 points

• 10 years of experience in the following:
• Continuous deployment methods and procedures;
• Agile methodologies for the analysis design development and implementation of applications in large complex environments;
• Knowledge and understanding of object-oriented analysis and design techniques;
• Experience leading a team of developers assigning tasks mentoring junior developers coordinating components for successful delivery;
• Excellent analytical trouble-shooting problem-solving and decision-making skills;
• Conducting research and assessment of options for technical design issues;
• Contributing to design/development of project plans including work breakdown and resource plans;
• Good verbal and written communications skills;
• Interpersonal and negotiation skills;
• A good team player with a track record for meeting deadlines;
• Experience with the projects related to business-critical environments and operations.