Data Integration Engineer

Role: Data Integration Engineer

Contract Term:
12 months, renewable

Location:
Hybrid: 3 Days Remote/ 2 Days In-office (Vaughan, Ontario)

Hours:
35 per week

Rate:
Negotiable

Our Utilities client is one of Ontario's leading energy providers, committed to building a smarter, more sustainable future.
They are a technology-driven organization focused on building scalable, secure, and intelligent data ecosystems - With a mission is to empower business decisions through seamless data integration and cloud innovation.
We are in search of a Data Integration Engineer to help unlock the full potential of their data ecosystem. If you thrive in collaborative environments, love solving complex problems, and want to make a real impact in the utilities sector, this role is for you.

Role Overview

As a Data Integration Engineer, you'll be responsible for designing, developing, and maintaining enterprise-grade data pipelines using Informatica on Azure. You'll work closely with cross-functional teams to ensure data flows reliably across systems, enabling analytics, reporting, and operational efficiency.

Key Responsibilities

• Develop and maintain ETL/ELT workflows using
  Informatica Cloud or PowerCenter
• Build scalable data pipelines on
  Azure
  , leveraging services like
  Azure Data Lake
  ,
  Blob Storage
  , and
  Azure SQL
• Integrate data across cloud and on-prem systems, ensuring high performance and reliability
• Collaborate with business analysts, data architects, and application teams to understand integration requirements
• Monitor, troubleshoot, and optimize data flows for latency, throughput, and accuracy
• Document integration architecture, data mappings, and transformation logic
• Support data governance, quality, and compliance initiatives

Required Skills & Experience

• ETL Workflow Development:
• Proven experience designing and implementing
  end-to-end data pipelines
  using Informatica. This includes:
• Extracting data from diverse sources such as relational databases, APIs, flat files, and cloud platforms
• Applying complex
  transformation logic
  to cleanse, enrich, and standardize data
• Loading data into target systems like
  Azure SQL
  ,
  Data Lake
  , or
  Synapse Analytics

• Building reusable mappings, workflows, and parameterized tasks to support scalable integration patterns

• Data Cleansing & Quality Assurance:

• Strong understanding of
  data profiling
  ,
  cleansing
  , and
  validation techniques
  to ensure high-quality, trustworthy data. Responsibilities include:
• Identifying and resolving data anomalies, duplicates, and inconsistencies
• Implementing business rules for data standardization and enrichment
• Collaborating with data stewards and governance teams to align with quality benchmarks

• Leveraging Informatica's built-in tools for
  data quality monitoring
  ,
  error handling
  , and
  exception reporting

• Performance Optimization:

• Ability to tune ETL jobs for
  efficiency and scalability
  , including:
• Managing large volumes of data with partitioning and parallel processing
• Monitoring job execution and troubleshooting bottlenecks

• Implementing best practices for resource utilization and error recovery

• Documentation & Collaboration:

• Comfortable documenting technical specifications, data flow diagrams, and transformation logic. Able to work cross-functionally with business analysts, data architects, and application teams to translate requirements into actionable solutions.
• Hands-on expertise with
  Informatica
  (Cloud or PowerCenter)
• Strong understanding of
  Azure cloud services
  and
  data architecture
• Proficiency in
  SQL
  ,
  JSON/XML
  , and
  REST APIs
• Experience with
  data modeling
  ,
  data warehousing
  , and
  metadata management
• Excellent problem-solving and communication skills

Nice to Have

• Experience working in or integrating systems within the
  utilities sector
  (e.g., energy, water, infrastructure)
• Familiarity with
  Azure Data Factory
  ,
  Logic Apps
  , or
  API Management
• Knowledge of
  data governance frameworks
  and
  compliance standards