Job Title

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 Ontarios 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, youll be responsible for designing, developing, and maintaining enterprise-grade data pipelines using Informatica on Azure. Youll 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 Informaticas 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