HM Note: This hybrid contract role is three (3) days in office. Candidates' resumes must include first and last name.

Description

Must haves:

8-10 years experience with the following:

• IICS (Informatica Intelligent Cloud Services)
• Oracle 19G
• Azure SQL Database
• Linux 8 – Shell Scripting.
• GIT (Global Information Tracker)

Responsibilities:

• Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
• Provide production support by monitoring ETL jobs, investigating failures and providing detailed reports on the resolution for issues faced in managing multiple data pipelines and QA support.
• 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.
• Resolve and troubleshoot technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

Desired Skills:

• Experience at the specified experience level setting up user access and user profiles, backup and recovery, and day-to-day computer systems operations.
• Experience in building and maintaining data pipelines (ETL/ELT processes).
• Experienced in building and managing Cloud Data Integration (CDI) pipelines for ETL/ELT processes.
• Proficient and experienced in designing and managing data warehouses (IICS) and databases(Oracle 19g)
• Experienced in data ingestion from cloud storage, on-premises systems, and streaming sources and API's
• Proficient in designing and developing data integration solutions using Informatica Intelligent Cloud Services (IICS).
• Experienced in system management and administration on Windows and Linux operating systems.
• Strong understanding of ETL concepts, data transformation logic, and data quality best practices.
• Proficient in writing and optimizing SQL queries across various relational databases (Oracle, SQL Server).
• Familiar and proficient on Azure Cloud and Azure Storage technologies such as Azure Data Lake Storage, Azure SQL Database, and Azure Data Lake Analytics.
• Skilled in monitoring, troubleshooting, and resolving IICS job failures and performance issues.
• Experienced in incident management, root cause analysis, and implementing preventive measures.
• Familiar with version control systems (e.g., Git) and CI/CD pipelines for deployment automation.
• Knowledgeable in managing support tickets and change requests.
• Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills
• A team player with a track record for meeting deadlines.
• Proficient in scripting (shell/python/Perl).
• CRM technologies (e.g. Oracle Siebel CRM), Oracle OBIEE, Informatica (PowerCenter and/or IICS).
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

Required Skills:

• IICS – Informatica Intelligent Cloud Services.
• Oracle 19G,
• Azure
• Azure SQL Database
• Linux 8 – Shell Scripting
• GIT Version Control
• ETL
• Excellent Communication, Collaboration Skills and contributes effectively to team objectives.

Required Experience / Evaluation Criteria:

1. IICS (Informatica Intelligent Cloud Services) – Development & Production Support - 35pts

2. Oracle 10g - 35 pts

3. Azure – SQL Server - 10 pts

4. Linux 8 – Shell Scripting - 10 pts

5. Git - 10 pts

Total Capabilities Evaluation Criteria - 100 points

Deliverables

Deliverables Include:

• Provide end to end software design, development and QA/Production support and documentation services for all ongoing and upcoming ETL and data projects at OH on the cancer care programs team.

• Some of the deliverables required from the individual will be:

• Design Documents (LSTM, Tickets in ADO).

• Source Code (PL/SQL, SQL, Shell Scripting, ETL, Python).

• ETL / Production Support Runbooks

• Project / Work Estimates

• ReadME.md

• Technical/ Conceptual specification documents

Knowledge Transfer Details:

• The resource will ensure full knowledge transfer is provided to the Ontario Health team before end of engagement. Some of this might occur at the end of the engagement but will also be shared as information is obtained/consolidated. Key deliverables will be shared with team.
• The resource must provide all related documentation as part of Knowledge Transfer protocol. Documents will be reviewed by the appropriate leads and signed off by manager/director.
• The resource will work collaboratively with the Ontario Health team throughout the assignment and ensure key deliverables, milestones, and documentation are shared.
• A walkthrough of any demos, development, etc. will be required before the end of the engagement.

Must Haves:

• 8+ years experience with IICS (Informatica Intelligent Cloud Services)
• 8+ years experience with Oracle 19G
• 8+ years experience with Azure SQL Database
• 8+ years experience with Linux 8 – Shell Scripting

Nice to haves:

• GIT