Specialized IT Consultant (Senior)

Maplesoft Group; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

Maplesoft Group seeks a Specialized IT Consultant to support ETL projects. The role includes designing data pipelines, providing production support, and troubleshooting issues. Candidates should have 8-10 years of experience with IICS, Oracle, and Azure. Join a company that values innovation and inclusivity while contributing to exciting government projects.

Qualifications

• 8-10 years experience with IICS, Oracle 19G, Azure SQL Database.
• Proficient in ETL, data transformation, and cloud integration.
• Strong analytical problem-solving and communication skills.

Responsibilities

• Design and implement data pipelines for ETL projects.
• Provide QA & production support for monitoring ETL jobs.
• Troubleshoot and resolve technical problems related to data integration.

Skills

ETL

Data Transformation

SQL

Data Warehousing

Incident Management

Cloud Integration

Scripting (Shell/Python/Perl)

Version Control (Git)

Tools

IICS

Oracle 19G

Azure

Linux

Git

Job description

Maplesoft implements TimeLive for Electronic time tracking.

Please view the demo below on how to enter and approve time.

Do you want to work in a dynamic environment where your contributions count?

At Maplesoft, we value the contributions of all our employees and contractors. We listen and act upon suggestions, advice, and innovative ideas to further our strategic vision. In turn, Maplesoft contributes to the communities where we live and operate. We think globally, but act in our own backyards.

Build your future with Maplesoft’s exciting technologies, deep partnerships, personal approach to consulting services, professional development opportunities and exciting company culture.

If you are interested in any of following job openings, please apply directly to [e-mail] , citing the position titleandjob id in the email subject line.

Maplesoft Group is currently seeking a Specialized IT Consultant (Senior) for our Provincial Government client.

Responsibilities and tasks include, but are not limited to the following:

Background Information

- To procure a Specialised IT Consultant contingent resource for six months. The technical skilled resource will be initially required to focus on the Design and Development and QA & Production Support for ETL Projects.

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 – Development & Production Support
2) Oracle 10g
3) Azure – SQL Server
4) Linux 8 – Shell Scripting
5) Git

Must Haves:

· 8-10 years experience with the following:
· IICS (Informatica Intelligent Cloud Services)
· Oracle 19G
· Azure SQL Database
· Linux 8 – Shell Scripting.



Maplesoft Group prides itself on its distinct corporate culture and recognizes that success is a direct reflection of our most valuable asset - our people. Therefore, attitude and ambition are key personality traits we seek out, along with skill and aptitude, in potential employees.

Maplesoft Group is committed to having a diverse, representative workforce and continuing to build an inclusive environment. We encourage applications from all qualified individuals. Maplesoft Group is an equal opportunity employer committed to diversity and inclusion. We are pleased to consider all qualified applicants irrespective of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veterans’ status, Aboriginal peoples or any other legally protected factors.

All employment decisions are made based on business needs, job requirements, and individual qualifications.

We are committed to developing inclusive, barrier-free recruitment and selection processes, and a work environment that supports our diverse workforce. Please let us know if you require accommodations at any stage of the recruitment process. We can be reached at Maplesoft Info at [e-mail].

We thank you for your interest in Maplesoft Group and wish to advise you, that only candidates under consideration will be contacted.

Ready to Excel?

Think you're a great fit for our team? Explore our Job Opportunities page.