RQ10057 - Software Developer - ETL - Senior

2 days ago

Toronto, Ontario, Canada Maarut Inc Full time US$80,000 - US$140,000 per year

Description:

Informatica IDMC ETL Development: Build ETL processes including mappings, workflows, sessions, reusable components. Apply parameterization, environment configs, scheduling, failure handling, and restartability in IDMC. 
AWS/Redshift Ingestion & Transform: design S3 landing/staging areas for data integration. Implement UPSERT/MERGE logic for dimension/fact loads. Configure CloudWatch dashboards/alerts. 
Data architecture: end-to-end data flow diagrams; data masking/PHI handling; row/column-level security design for Cognos & Redshift. 
Data modeling: conceptual/logical/physical models (star/snowflake), Redshift dist/sort keys. 
Data mapping: field-level mappings with business rules, transformations, lineage, data quality validations, and exception handling. 
Any other deliverables as assigned by the Project/Resource Manager.
Knowledge transfer to HSC staff in the form of a detailed guide or as per project requirements.

Requirements

Experience and Skill Set Requirements:

Must Haves:

IDMC Designs robust mappings, uses reusable transformations, parameterization, environment configs;

Skill Set Requirements:

Public Sector Experience:

Experience working in the Public Sector and familiarity with I&IT project management processes

IDMC/Cloud Data Integration / Redshift:

Build Informatica IDMC ETL processes including mappings, workflows, sessions, reusable components. Apply parameterization, environment configs, scheduling and failure handling.
Configuring, tuning and monitoring techniques for Amazon Redshift and Redshift ingestion.
Familiar with AWS services (S3, Athena, Lambda, Glue, Step Functions, CloudWatch etc).

Core skills, database and domain knowledge:

Relational database design and optimization experience.
Security controls to safeguard sensitive data (PI and PHI).
Query tunning.
Dimensional data modelling for data warehousing.
Advanced SQL and PLSQL (or equivalent).
Extract/Transform/Load data.

General Skills:

Proven troubleshooting and critical thinking skills
Strong interpersonal skills with ability to work with client stakeholders to understand, interpret business requirements and its technical implications.
Demonstrated ability to present technical solutions to client stakeholders, technical staff and to senior management.
A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.

  • RQ10057 | Software Developer, Senior

    2 days ago

    Toronto, Ontario, Canada MERAK Systems Corporation Full time US$100,000 - US$140,000 per year

    Software Developer, Senior - ETL x2 8+ years experienceOpportunity DetailsClient Reference RQ10057# of Openings 2Start Date December 15, 2025End Date March 31, 2026Days for Contract 73Extension 1 timeAssignment Type HybridDays in Office 4 days a weekLocation ​​​​5700 Yonge Street, Toronto, ONCluster Health Services...

  • RQ10057 - Software Developer - ETL - Senior

    2 days ago

    Toronto, Ontario, Canada Maarut Inc Full time US$1,000,000 - US$1,200,000 per year

    Description:Informatica IDMC ETL Development: Build ETL processes including mappings, workflows, sessions, reusable components. Apply parameterization, environment configs, scheduling, failure handling, and restartability in IDMC.  AWS/Redshift Ingestion & Transform: design S3 landing/staging areas for data integration. Implement UPSERT/MERGE logic for...

  • RQ09460 - Software Developer - ETL - Senior

    2 weeks ago

    Toronto, Ontario, Canada S M Software Solutions Inc Full time $120,000 - $180,000 per year

    Client: Ministry of Public and Business Service Delivery and ProcurementWork Location:595 Bay Street, Toronto, Ontario,OnsiteEstimated Start Date: Estimated End Date: #Business Days:130.00Extension:Probable after the initial mandateHours per day or Week:7.25 hours per daySecurity Level:CRJMC + Credit CheckMust Have5+ years of proven working experience in an...

  • RQ09886 - Software Developer - ETL - Senior

    2 weeks ago

    Toronto, Ontario, Canada S M Software Solutions Inc Full time $80,000 - $120,000 per year

    Client: Ministry of Public and Business Service Delivery and ProcurementWork Location:595 Bay Street, Toronto, Ontario,OnsiteEstimated Start Date: Estimated End Date: #Business Days:165.00Extension:Probable after the initial mandateHours per day or Week:7.25 hours per daySecurity Level:CRJMC + Credit CheckMust Have5+ years of proven working experience in an...

  • Senior Java/ ETL Software Developer

    1 week ago

    Toronto, Ontario, Canada Source Code Full time $80,000 - $120,000 per year

    Senior Java/ ETL Software Developer (Java, Informatica, ETL, SQL, PL/SQL,and Power BI)Toronto, Ontario - Hybrid, 3 days onsite - 87 Sir William Hearst Ave Toronto, ON M3M 0B4Contract, 9 months (with possibly of extension) Employment Ontario is one of the major programs delivered by the Employment and Training Division of the Ontario Ministry of Training,...

  • RQ10027 - Software Developer - ETL - Senior

    2 weeks ago

    Toronto, Ontario, Canada S M Software Solutions Inc Full time $80,000 - $120,000 per year

    Client: Ministry of Treasury Board SecretariatWork Location:222 Jarvis St., Toronto, Ontario,OnsiteEstimated Start Date: Estimated End Date: #Business Days:274.00Extension:130.00Hours per day or Week:7.25 hours per daySecurity Level:CRJMCMust HaveExperience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data...

  • Software Developer-ETL Senior

    2 days ago

    Toronto, Ontario, Canada Bevertec Full time US$80,000 - US$120,000 per year

    26652BEV123Software Developer-ETL Senior(IDMC Designs mappings, transformations, parameterization)Toronto, ONContract RoleDuration: The resource is required to be onsite 4 days per week and work remotely 1 day per week.Note:Must haveIDMC Designs robust mappings, uses reusable transformations, parameterization, environment configuration experience.Must...

  • Senior ETL Developer

    2 weeks ago

    Toronto, Ontario, Canada 2iSolutions Inc. Full time $80,000 - $120,000 per year

    RQ Software Developer - ETL – SeniorLocation:Onsite / 595 Bay Street, TorontoPeriod:  6-monthsMust-haves:·      5+ years of proven working experience in an ETL role;strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns. Understanding of data pipeline...

  • RQ10027 - Software Developer - ETL - Senior

    2 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time $100,000 - $120,000 per year

    Responsibilities:Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.Required to translate technical systems specifications into working, tested applications.This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs,...

  • RQ10027 - Software Developer - ETL - Senior

    2 weeks ago

    Toronto, Ontario, Canada Maarut Inc Full time $100,000 - $150,000 per year

    Responsibilities:Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities. Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs,...