Senior BI / ETL Developer

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

Key Responsibilities :

Desirable Skills :

Evaluation Criteria :

ETL Expertise (35%)

Informatica Experience (25%)

Problem-Solving and Decision-Making (20%)

Collaboration & Communication (15%)

OPS Experience (5%)