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
Requirements Experience and Skill Set Requirements:
Must Haves:
10+ years of experience in the following:
Designing and developing large, complex, provincial level financial allocation and payment tracking system using Dot Net Framework, ASP.Net, VB.Net, 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);
Skill Set Requirements:
Public Sector Experience:
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:
10+ years of experience in the following:
Designing and developing large, complex, provincial level financial allocation and payment tracking system using Dot Net Framework, ASP.Net, VB.Net, 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:
10+ years of experience in the following:
Hands-on ASP.Net VB.Net Web Form, MVC development experience, install and configure MS IIS, Dot Net 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:
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.
