10+ years of experience in designing and developing large-scale multi-client web applications
7+ years of experience in IT projects, preferably in the Ontario Public Sector
Strong expertise in data and business modeling (ERD, BPMN, UML)
Proficiency in data and business analysis tools like JIRA and Azure DevOps
Experience with Java development and Oracle or SQL databases
Strong programming skills in PL/SQL, SQL, XML, and Unix shell scripts
Excellent communication and leadership abilities
Responsibilities
Translate technical specifications into functional applications
Develop detailed programming specifications and generate code
Conduct unit tests and maintain data-driven programs
Troubleshoot technical issues during software operation
Collaborate with IT professionals throughout the Software Development Life Cycle
Provide post-implementation support and resolve technical issues
Conduct design walkthrough sessions with project teams
Benefits
Opportunity to work on large-scale, impactful projects
Collaborative work environment with IT professionals
Exposure to the latest technologies and methodologies
Professional development opportunities in a public sector setting
Flexible work arrangements and supportive team culture
Full Job Description
Job Description Responsibilities
Required to translate technical systems specifications into working, tested applications.
This includes:
developingdetailed programming specifications
writingand/or generating code o compiling data-driven programs, maintaining, andconducting unit tests.
Resolvesand troubleshoots technical problems which arise during the use andoperation of software packages, including technical assistance inimplementation, 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
Requirements
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
Experience and Skill Set Requirements
Core Skills and Experience - 40 %
10+ years of experience as a designer and developer in the large-scale multi-client web applications
10+ year of hands-on working experience of Java development with Oracle or SQL database
5+ years of hands-on experience of RestAPI, RESTful WebServices
Knowledge and experience of microservice architecture as well as a demonstrated ability to apply core architecture principles to enhance a product's extensibility and maintainability.
Knowledge and experience with programming Internet-ready applications
Knowledge and experience in rapid application development (RAD) methodologies
Experience using Azure DevOps
Technical Skills and Experience - 35%
Knowledge of security gateways and protocols (JWT, Oauth2.0, SSL Certificates)
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
Soft Skills- 20%
Strong communication skills; both written and verbal
Ability to develop and present new ideas and conceptualize new approaches and solutions
Excellent interpersonal relations and demonstrated ability to work with others effectively in teams
Demonstrated ability to work with functional and technical teams Demonstrated ability to participate in a large team and work closely with other individual team members
Proven analytical skills and systematic problem solving
Strong ability to work under pressure, work with aggressive timelines, and be adaptive to change
Displays problem-solving and analytical skills, using them to resolve technical problems
Public sector Experience- 5%
OPS Development standard/Process
Must haves:
7+ years of experience in IT projects.
Ontario Public Sector (OPS) experience is preferred.
Strong expertise in data and business modeling (ERD, BPMN, UML, data flow diagrams, process mapping, etc.).
Proficiency in data and business analysis tools:
JIRA, Confluence, Azure DevOps (for requirements and project tracking).
Visio, Lucidchart, MIRO (for process modeling and workflow documentation).
SharePoint, MS Teams (for collaboration).
Experience in systems re-engineering, workflow optimization, and automation.
Ability to work in Agile (Scrum, Kanban) and Waterfall environments.
Experience composing Data Requirements Documents (DRD) or System Requirements Documents (SRD)
Creation of Data Models (ERD, UML, Data Flow Diagrams, etc.)
Experience with extract data from databases via querying languages such as SQL and LINQ
