RQ08814 - Middleware Specialist - Senior

Rubicon Path; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A technology service provider is seeking a Middleware Specialist to ensure the availability and performance of critical applications. The ideal candidate should have extensive experience in application support, particularly with ETL processes and database technologies. Familiarity with SAP Business Object Enterprise and Informatica is preferred. Strong communication skills and public sector experience will be assets.

Qualifications

• Hands-on experience in application support and production deployment.
• Working knowledge of database technologies and ETL processes.
• Demonstrated ability to work effectively in teams.

Responsibilities

• Support application availability and monitor production environments.
• Manage and troubleshoot high-priority production issues.
• Document technical needs for ETL processes.

Skills

Application support

ETL processes

Database design

Troubleshooting

SAP Business Object Enterprise

Power Center Informatica

Team collaboration

Tools

Oracle

Windows/Linux/Solaris OS

PL/SQL

Job description

RQ08814 - Middleware Specialist - Senior

About the job RQ08814 - Middleware Specialist - Senior

Description

The EOIS platform has the following planned initiatives which require resources to support several application sustainment and support initiatives. This platform hosts a business-critical Case Management System, Common Assessment under Employment Services Transformation (EST) initiative, Apprenticeship System, Service Provider Connect System with Data Warehouse and Reporting environment, and several public facing applications.

· Monthly application releases EOIS has a planned cycle of 12 monthly releases that requires comprehensive build and test activities in the pre-production environment to ensure seamless deployments to the production environment. EOIS maintenance release deployments ensure modern, effective, and secure systems are in place to support the day-to-day tracking of case management based on Employment Ontario programs.

· Application Operations, Maintenance and Support - EOIS IT team is responsible to support production and non-production environments, including, application availability and monitoring checks as per service level agreement, troubleshooting high priority production issues, keeping the lights‑on, addressing service requests, incidents, change requests, application deployments, configuration, and support.

Business Intelligence report environment EOIS has an enhanced reporting environment based on SAP Business Object Enterprise (BOE) and Power Center Informatica/Oracle‑based ETL system which is an essential component for the EOIS to run business critical daily, weekly, and monthly reports to make timely, informed decisions. Business dependency is extremely high on the availability of these systems.

· Technology upgrades upgrade the various EOIS technologies (i.e., SAP Business Object Enterprise, Informatica, etc.) for business‑critical applications used by internal and external service providers users and keep the government assets current and up to date.

Deliverables and Skillsets

Middleware specialist experience in:

· Hands‑on experience in application support, build and test, production deployment, change request, and release management.

· Working experience of database design, editing, transformation, and loading using Power Center Informatica ETL, and support SAP Business Object Enterprise (BOE) based reporting analytics solutions.

· Support new and current informatica ETL processes to enhance loading of data from and into different source/ target systems

· Review, analyze, modify, and create informatica ETL workflows and processes.

· Perform ETL monitoring, testing, debugging, tuning and providing on‑going support to business critical Datawarehouse and reporting solutions in production.

· Document technical needs for ETL processes and databases, and ensure optimal technical infrastructure is utilized.

· Perform various complex assignments without much supervision and must be able to carry out training for ministry and IT staff.

· Working experience of large data integration and Informatica and BOE technology upgrade projects.

· Working knowledge of n‑tier web‑based applications, database technologies, software, tools, and languages such as SAP Business Object Enterprise, Informatica, Oracle, PL/SQL, and Windows/Solaris/Linux operating systems.

· Sound knowledge of production applications support process including incident management, change management, deployment, support, and upgrades.

· Working knowledge of the Systems Development Life Cycle (SDLC), application deployment and testing, and release management processes to contribute to the development, delivery, and on‑going support of applications.

· Excellent interpersonal skills and demonstrated ability to work with others effectively in teams.

· Demonstrated ability to participate in a large team and work closely with other individual team members.

· Public sector experience would be an asset.

SkillsExperience and Skill Set Requirements

Evaluation criteria

Criterion

Technical Experience

· Working experience with business‑critical applications support in a production environment.

• Hands‑on experience in application support, build and test, production deployment, change request, and release management.
• Ability to perform database design, editing, transformation, and loading (i.e., ETL)
• Knowledge of complex programming concepts and languages to lead the preparation of detailed design specifications, testing, implementation, and documentation.
• Working knowledge of n‑tier web‑based applications, database technologies, software, tools, and languages such as SAP Business Object Enterprise, Informatica, Oracle, PL/SQL, and Windows/Solaris/Linux operating systems
• Sound knowledge of production applications support process including incident management, change management, deployment, support, and upgrades.
• Ability to manage and track all incident and service requests and coordinate with other support teams.

· Working experience with technology upgrade projects

60

Information Technology Standards and Processes Knowledge

· Knowledge of the Systems Development Life Cycle (SDLC), application deployment, testing, and release management processes to contribute to the development, delivery, and ongoing support of applications.

• Knowledge of ITIL and experience of application support with incident tickets, service requests, change requests, deployment, and release management.

· Working knowledge of information architecture and data modeling, internet technology, and emerging technologies to support the n‑tier web‑based Datawarehouse and Reporting applications.

20

Soft Skills

• Demonstrated ability to participate in a large team and work closely with other individual team members

· Demonstrated ability to develop and present new ideas and conceptualize new approaches and solutions

15

Public Sector Experience

· Experience working in the public sector

· Knowledge of government I&IT directives and standards

5

Total

100

Must haves:

Working experience with business‑critical applications support in a production environment