Senior BI / ETL DeveloperCleo Consulting • Toronto, ON, Canada

Senior BI / ETL Developer

Cleo Consulting • Toronto, ON, Canada

Il y a 16 heures

Type de contrat

Temps plein

Quick Apply

Description de poste

Assignment : RQ10584 - Software Developer - ETL - Senior

Job Title : Senior BI / ETL Developer

Requisition (SS) : RQ10584

Start Date : 2026-03-16

Client : Land & Resources Cluster

End Date : 2026-04-30

Office Location : 40 St. Clair West, Toronto

Organization : Land & Resources Cluster

Ministry : Ministry of Public and Business Service Delivery and Procurement

# Business Days : 34.00

The contractor will work in office 3 to 5 days per week (40 St. Clair West, Toronto) as per OPS directive and LRC management guidelines

Must haves :

10+ years of experience as a BI / ETL Developer.
10 + years of experience developing and performance tuning SQL, T-SQL, PL / SQL and advanced SQL query optimization.
10+ years experience with Oracle tools : EXPLAIN PLAN, TKPROF, OEM, RMAN, etc.
5+ years Experience with relational database including Oracle including Oracle 11g and 19c.
3+ years of hands-on experience with Informatica PowerCenter v10.2 administration
2+ years of experience with Informatica Cloud (IDMC) including PC to IDMC migration; asset management; and configuration of secure agents, schedules, orgs and sub-Orgs, connections, users and roles
Hands-on Oracle 11g and 19c experience configuring, user roles setup, RMAN, data dumps, and Golden Gate synchronization
Proficiency in data modeling (OLTP, OLAP, dimensional modeling).
Experience with REST / SOAP APIs, system integration, and cloud platforms (Azure, AWS, GCP).
Experience with data replication, data cleansing, and data quality assurance.
Excellent analytical, problem-solving, and communication skills.

Description

To respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as needed basis.

The contractor will work in office 3 to 5 days per week (40 St. Clair West, Toronto) as per OPS directive and LRC management guidelines

Key Responsibilities :

Contribute to and support design, development, and maintenance of ETL processes using Informatica Cloud (IDMC).

Migrate Informatica PowerCentre v10.2 ETL code including embedded SQL and PL / SQL code developed using Oracle 11g and 19c

Test migrated embedded SQL code and PL / SQL based Stored Procedures.

Performance-tune and optimize SQL queries and PL / SQL code for performance and scalability.

Conduct root cause analysis and resolve ETL issues, including performance tuning and recovery to achieve optimum baseline-based performance

Perform data extraction, transformation, and loading (ETL) from various sources into data warehouses (star / snowflake schemas).

Translate technical specifications into fully tested applications and data pipelines.

Collaborate with vendor and entire project team for unit testing, debugging, and validation of ETL processes.

Document technical designs, deployment guides, and support materials.

Participate in Agile / Scrum development cycles and iterative delivery.

Ensure compliance with data governance, security, and access control policies.

Provide post-implementation support and participate in knowledge transfer sessions.

Provide database administration including configuration, backup / recovery, user roles, database

Experience and Skill Set Requirements

Desirable Skills :

Strong understanding of Agile, SDLC, and DevOps practices.

Experience with Azure DevOps and version control systems.

Familiarity with OPS (Ontario Public Service) methodologies and enterprise architecture.

Experience in public sector projects, especially in environmental or inter-jurisdictional data systems.

Understanding of Information Management principles and data governance.

Evaluation Criteria :

ETL Expertise (35%)

Design, develop, modify and enhance Oracle SQL and PL / SQL code for Oracle 11g and 19c

Performance-tune and optimize SQL queries and PL / SQL code for performance and scalability.

Conduct root cause analysis and resolve ETL issues, including performance tuning and recovery to achieve optimum baseline-based performance

Utilize Oracle tools : EXPLAIN PLAN, TKPROF, OEM, RMAN, etc.

Informatica Experience (25%)

Design, develop and maintain ETLs using Informatica PowerCentre v10.2 and IDMC

Administer Informatica PowerCentre and IDMC including asset management; and configuration of secure agents, schedules, orgs and sub-Orgs, connections, users and roles

Migration of Informatica assets from PowerCentre v10.2 to IDMC

Problem-Solving and Decision-Making (20%)

Demonstrated analytical skills in identifying issues and developing effective solutions in a timely manner.

Proven track record of meeting project deadlines and managing deliverables within project constraints.

Familiarity with structured methodologies for software development and the ability to adapt to emerging technologies in GIS.

Demonstrated experience of Oracle 11g and 19c administration including Golden Gate synchronization

Collaboration & Communication (15%)

Strong verbal and written communication skills for effectively engaging with technical and non-technical stakeholders.

Proven ability to collaborate with both vendor and project cross-functional teams throughout the project.

Proven experience of technical documentation and communication to stakeholders

OPS Experience (5%)

Prior experience working with OPS as a senior ETL Developer

Prior experience working with Public Sector as a senior ETL Developer

Créer une alerte emploi pour cette recherche

Senior BI ETL Developer • Toronto, ON, Canada

Offres similaires

Senior Data Analyst — ETL, SQL & Python Insights

Swiss Re • Toronto

Temps plein

A leading reinsurance company in Toronto seeks a Business Analyst to collaborate with stakeholders and deliver data-driven insights. Responsibilities include translating business requirements, devel...Voir plus

Dernière mise à jour : il y a 2 jours • Offre sponsorisée

Senior Data Analyst — Hybrid BI & Analytics Leader

Sun Life Financial • Toronto

Temps plein

A leading financial services company in Toronto is looking for a Senior Data Analyst to support data and insights needs within their Advanced Analytics team. The role involves building reporting and...Voir plus

Dernière mise à jour : il y a 7 jours • Offre sponsorisée

Senior Backend Data Engineer — ETL & Analytics

S&P Global • Toronto

Temps plein

A global analytics company based in Toronto is seeking a seasoned professional for a role focused on managing product backlogs and collaborating on data integration projects.The successful candidat...Voir plus

Dernière mise à jour : il y a 4 jours • Offre sponsorisée

Senior ETL Developer

Encore Technical Solutions Inc. • Markham

Temps plein

A degree in Computer Science, Software Engineering, or comparable professional experience.CDC techniques, and crafting / optimizing SQL queries. MS SSIS / SSDT and Pitney Bowes migration utilities.Famil...Voir plus

Dernière mise à jour : il y a 12 jours • Offre sponsorisée

BI Developer - Power BI, Snowflake & ETL Automation

Pet Valu • Markham

Temps plein

A retail pet supply company located in Markham is seeking a skilled Business Intelligence Developer.This role involves developing high-quality BI solutions with a focus on automation, scalability, ...Voir plus

Dernière mise à jour : il y a 22 jours • Offre sponsorisée

Senior ETL & Databricks Data Platform Engineer

LanceSoft • Toronto

Temps plein

An established industry player is seeking a Senior ETL Developer / Specialized IT Consultant to join their dynamic team.In this role, you will leverage your extensive experience in developing and man...Voir plus

Dernière mise à jour : il y a 5 jours • Offre sponsorisée

Senior ETL Engineer — Azure Databricks & Power BI

Rubicon Path • Toronto

Temps plein

A leading technology consulting firm in Toronto, Canada is seeking a Senior Software Developer specialized in ETL.This hybrid position requires 5+ years of experience in data engineering with exper...Voir plus

Dernière mise à jour : il y a 22 jours • Offre sponsorisée

Senior MSSQL DB Architect / Developer - Data & ETL Leader

CI Financial • Toronto

Temps plein

A financial services provider in Toronto is seeking a skilled Senior Database Architect / Developer (MSSQL) to manage and optimize SQL databases. Responsibilities include data purging, index optimiz...Voir plus

Dernière mise à jour : il y a 22 jours • Offre sponsorisée

Senior BI & Analytics Lead — Hybrid

Mackenzie Investments • Toronto

Temps plein

A leading Canadian wealth management firm seeks a Senior Specialist in Business Intelligence & Analytics.This strategic role involves shaping reporting frameworks, optimizing analytical processes, ...Voir plus

Dernière mise à jour : il y a 7 jours • Offre sponsorisée

ETL Developer

Fidelity Canada • Toronto

Temps plein

You will be working on a 100% remote schedule as part of Fidelity’s dynamic working arrangement.Current work authorization for Canada is required for all openings. At Fidelity, we’ve been helping Ca...Voir plus

Dernière mise à jour : il y a 22 jours • Offre sponsorisée

Senior Data Engineer — Cloud Analytics & ETL

Investment Management Corporation of Ontario • Toronto

Temps plein

A leading investment management firm in Toronto is seeking a Senior Data Engineer to design and support a cloud-based data infrastructure. This role requires extensive experience in data warehousing...Voir plus

Dernière mise à jour : il y a 22 jours • Offre sponsorisée

Senior ETL Architect - Azure Databricks & Data Lakehouse

Bevertec • Toronto

Temps plein

A leading data solutions company in Canada and Ontario is looking for a Data Engineer to design and develop scalable Medallion Data Lakehouse architectures. The role involves optimizing ETL / ELT pipe...Voir plus

Dernière mise à jour : il y a 18 jours • Offre sponsorisée

Senior BI Developer : Data Storytelling & Dashboards

Rakuten Kobo Inc. • Toronto

Temps plein

A leading digital bookseller in Toronto is seeking a Business Intelligence Developer to enhance reporting via Google BigQuery and visualization tools like Tableau. The ideal candidate will have over...Voir plus

Dernière mise à jour : il y a 22 jours • Offre sponsorisée

Senior Data Solutions Lead - SQL, ETL & Azure

TD Bank • Toronto

Temps plein

A leading financial institution is seeking a Senior Data Management Lead in Toronto.This role requires providing technical leadership across diverse data analysis functions, including SQL, ETL, and...Voir plus

Dernière mise à jour : il y a 3 jours • Offre sponsorisée

Ab Initio Developer - ETL & Data Integration (Banking)

Astra North Infoteck Inc. • Toronto, ON, ca

Temps plein

Quick Apply

Ab Initio Developer | ETL & Data Integration (Banking).Design, develop, and implement ETL solutions using.GDE, EME, PDL, Meta programming). Stonebranch, Control-M, Autosys.Write complex queries ...Voir plus

Dernière mise à jour : il y a 2 jours

Senior ETL Developer - Azure SQL & D365 (Hybrid)

Source Code • Toronto

Temps plein +1

A leading software firm is seeking a skilled Sr.Software Developer specializing in ETL processes for a 6-month contract in Downtown Toronto. The ideal candidate will have over 5 years of experience ...Voir plus

Dernière mise à jour : il y a 17 jours • Offre sponsorisée

Ab Initio ETL Developer

Adastra Corporation • Markham

Temps plein

Join our team at Adastra as a Senior Ab Initio ETL Developer and be at the forefront of enterprise data solutions.In this role, you will lead ETL development, provide expert guidance, and collabora...Voir plus

Dernière mise à jour : il y a 22 jours • Offre sponsorisée

BI / Reports Developer

Avanciers Inc. • Toronto

Temps plein

Avanciers Incorporated is hiring a.Job Title : BI / Reports Developer.This is an active job and application deadline is February 20, 2026. This posting may close earlier if a suitable candidate is foun...Voir plus

Dernière mise à jour : il y a 4 jours • Offre sponsorisée