Specialized IT Consultant – Senior

2iResourcing; Ontario; On-site; CAD 100,000 - 125,000; Full time

Job summary

An established industry player is seeking a Senior Specialized IT Consultant to join their team. This role involves designing and implementing ETL solutions in a hybrid work environment, where you will be expected to work onsite three days a week and remotely for two days. You will leverage your extensive experience with Oracle, Informatica, and Cognos to modernize complex IT systems and develop business intelligence solutions. If you thrive in a collaborative setting and have a passion for technology, this opportunity is perfect for you to make a significant impact on large-scale projects.

Qualifications

• 5+ years of experience in ETL design and development using Informatica.
• Proven skills in designing BI solutions with Cognos and Power BI.

Responsibilities

• Design and develop ETL solutions, ensuring data integrity and performance.
• Collaborate with business users and IT teams to meet project requirements.

Skills

Oracle Data Integrator

Informatica ETL

Cognos

Microsoft Power BI

SQL

Unix Scripting

Data Warehousing

ETL Design

Data Migration

Agile Methodologies

Tools

PowerDesigner

SSIS

Visual Source Safe

Job description

If interested, please share your latest resume at [e-mail] / [e-mail]

RQ08199 - Specialized IT Consultant – Senior

Client: Ministry of Public and Business Service Delivery and Procurement

Period: 12 months

Start Date: 2025-04-01

End Date: 2026-03-31

Working Hrs.: 7.25 Hrs. / day

Location: 777 Bay St

Hybrid: Candidate must be able to work 3 days onsite and 2 days remote.

Assignment Type: This position is currently listed as "Hybrid" as consultants may be required to work partly in the physical workplace and partly remotely. The details of this arrangement will be at the Hiring Manager's discretion.

Must Have:

• Demonstrated development and solution design experience in an environment where Oracle, Informatica and Cognos are used together.
• Demonstrated experience designing, developing, and implementing Informatica ETL solutions.
• Demonstrates experience designing and developing BI Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.
• Demonstrated experience in coordinating and planning for the modernization of large, complex multi-platform, multi-tier information technology systems, particularly in ETL design, data migration, and Fabric Data Factory integration.

Description

Evaluation Project Requirements Evaluation Breakdown

Technical Skills - 45%

• Working knowledge of the entire Data Dictionary, data mapping.
• Working knowledge of the Business Process Design Re-engineering for applications.
• 5+ years of demonstrated experience and skills using Oracle Data Integrator and/or Informatica ETL tools.
• Experience enhancing performance of ETL code and SQL Queries.
• Experience developing ETL routines using Informatica and/or SSIS in a data warehousing environment or large data migration.
• Experience Designing Data warehouse components and ETL Scripts.
• Experience using PowerDesigner to review data models, as well as make changes and generate DDL's.
• 5+ years of experience with Unix scripting.
• Experience working with Oracle Databases (version 10.x or higher), DB2 Database, and with complex korn-shell scripts.
• Experience in designing RDBMS SQL, DML and DDL (DB2 and Oracle) and the architectural implications associated with each platform in regards to ETL.
• Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components.
• Experience in developing the Application Code package using MS Visual Source Safe. Demonstrated experience performing system testing, unit testing, and user acceptance testing.
• Demonstrates development and solution design experience in an environment where Oracle, Informatica and Cognos are used together for data warehousing and business intelligence.
• Demonstrate experience designing, developing and implementing Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.
• Experience in leading development and modelling of applications, specifically hierarchical data model applications.

Core Skills - 35%

• Experience performing the design of data warehouse and related components, including working knowledge of SQL Server, Oracle SQL, PL/SQL, and their optimization techniques.
• Experience with systems design and development, and related methods, techniques, practices and standards.
• Working Knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure support projects.
• Experience documenting application designs and specifications, and drafting policies and procedures for ETL processes and Power BI-compatible formats.
• Working knowledge of aggregate reporting and ETL processes, specifically using tools like Informatica, SSIS , and Fabric Data Factory.
• Troubleshooting of production issues and creating fixes for any unplanned deployments.
• Defect investigation, resolution and assignment to team members using defect/issue management tools, e.g. Client ALM or Client Service Manager.
• Demonstrated experience in coordinating and planning for the modernization of large, complex multi-platform, multi-tier information technology systems, particularly in ETL design, data migration, and Fabric Data Factory integration.
• Proven experience using a variety of methodologies to carry-out the software development lifecycle (e.g., Agile, waterfall, etc.).

Communication Skills - 15%

• Experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specifications.
• Analytical and problem-solving skills to assess clients' business priorities and needs; to evaluate business and technical design alternatives.

Public Sector Experience - 5%

• Previous public sector experience in an organization of equivalent size.