- Location: Toronto, Ontario
- Job Type: Contract
- Salary: CA$34 Per Hour
Advantages
• Earn a competitive rate within the industry
• Hybrid – – Candidate MUST work 3 days onsite and 2 days remote. Starting October 20, resources are expected to come into the office 4 days per week. Starting January 5, resources are expected to come into the office 5 days per week. This is subject to change based on manager discretion.
• Potential for extension
Responsibilities
• Design, develop, and implement web applications using Oracle APEX.
• 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.
Qualifications
Must haves:
• Experience with advanced APEX features like interactive reports, charts, and dynamic actions
• Writing complex procedures/pkg/views/scripts to do data de-normalization, data extraction, data transformation(cleansing), and data loading.
• Relational databases (Oracle, SQL Server), data modelling (relational & dimensional), advanced SQL, query optimization, data replication, administration
• Cloud technologies (Azure, Google, AWS)
• Conducting technical evaluation and assessment of options for technical design issues, application figuration aspects and integration capabilities, related tools and utilities, gap analysis of integration components to technical requirements/specifications/documentation
• Technical analysis, Oracle APEX program code, detailed programming and reports specifications, program design, writing and /or generating code, and conducting unit tests
General Skills:
Ability to assess ‘as is’ state of legacy applications and assist in providing recommendations
Proven experience in developing applications using Oracle APEX
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 with advanced APEX features like interactive reports, charts, and dynamic actions
Experience utilizing Oracle REST Data Services (ORDS) to create RESTful APIs
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
ETL and Database Skills
Knowledge and experience in gathering requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end users
Knowledge and experience maintaining and improving already existing processes.
Knowledge and experience ensuring that the data architecture is scalable and maintainable
Knowledge and experience working with the business in designing and delivering correct, high quality data
Experience investigating data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions
Experience working with the Oracle database, including data modeling, SQL, and PL/SQL development and data modeling
Experience preparing detailed documentation for further reference
Desirable Skills:
Knowledge and experience with programming Internet-ready applications
Knowledge and experience in rapid application development (RAD) and Agile 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