RQ10057 | Software Developer, Senior ETL x2MERAK Systems Corporation • Toronto, Ontario, Canada

RQ10057 | Software Developer, Senior ETL x2

MERAK Systems Corporation • Toronto, Ontario, Canada

29 days ago

Job type

Full-time

Job description

Software Developer Senior - ETL x2

8 years experience

Opportunity Details

Client Reference

RQ10057

# of Openings

Start Date

December 15 2025

End Date

March 31 2026

Days for Contract

Extension

1 time

Assignment Type

Hybrid

Days in Office

4 days a week

Location

5700 Yonge StreetToronto ON

Cluster

Health Services Cluster

Ministry

Ministry of Public and Business Service Delivery and Procurement

Must Haves

IDMC Designs robust mappings uses reusable transformations parameterization environment configs

Nice to Haves

N / A

Rated Requirements

Public Sector Experience 5%

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

IDMC / Cloud Data Integration / Redshift50%

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 knowledge35%

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 Skills10%

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.

Description

Responsibilities

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.

If you are interested in this opportunity please use the Apply To This Job button at the top.

NOTE : AI tools may be used during the application process for development formatting and review of resumes and other Applicant materials. Applicant identifiers will be made anonymous.

NOTE : By submitting profile information to MERAK you consent to receive email notifications regarding information updates and communications about subcontracting work opportunities and personalized communication as needed. You are able to revoke this consent at any time through the unsubscribe link or pause notifications if you have accepted an external work opportunity by reaching out to us via email at any time.

Required Experience :

Senior IC

Key Skills

SQL,Pentaho,PL / SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle

Employment Type : Full Time

Experience : years

Vacancy : 1

Create a job alert for this search

Senior Software Developer • Toronto, Ontario, Canada

Similar jobs

RQ10035 - Software Developer - Senior

Source Code • Toronto, ON, Canada

Full-time +1

Quick Apply

RQ10035 - Software Developer - Senior.Onsite / 21 College Street, Toronto.Justice Technology Services - Ministry of Public and Business Service Delivery and Procurement.Design, development and...Show more

Last updated: 20 days ago

Senior Analyst

Vaco by Highspring • Richmond Hill, Ontario, Canada

Temporary

Our client is sourcing a Senior Analyst for a 6-month contract.Responsible for month-end, quarter-end, and annual close process in accordance with company requirements. Responsible for expense reimb...Show more

Last updated: 20 days ago • Promoted

Senior Software Engineer, Embedded Hybrid - Toronto

Motive • Toronto, ON, Canada

Full-time

Motive empowers the people who run physical operations with tools to make their work safer, more productive, and more profitable. For the first time ever, safety, operations and finance teams can ma...Show more

Last updated: 30+ days ago • Promoted

ETL Informatica Developer

Cognizant • Toronto, Canada

Full-time

We are Cognizant Artificial Intelligence : .Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better than ever before....Show more

Last updated: 24 days ago • Promoted

QE - ETL Testing

Iris Software Inc. • Toronto

Full-time

Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Iris Software Inc.Design, develop, and execute test plans, test cases, and test scripts for ETL proc...Show more

Last updated: 1 day ago • Promoted

Mid-Senior SQL Developer - ETL, SSIS / SSRS & Data Modeling

Tata Consultancy Services • Toronto

Full-time

A global IT services leader in Toronto is looking for a Mid-Senior level professional with expertise in Microsoft SQL Server and ETL processes using SSIS. You will develop SQL code, design data mode...Show more

Last updated: 3 days ago • Promoted

Senior Data Integration & ETL Development Lead

Scotiabank • Toronto

Full-time

A leading financial institution in Toronto is seeking a Sr.Data Integration and Development Engineer.This role involves ETL process analysis and development, as well as collaboration with cross-fun...Show more

Last updated: 6 days ago • Promoted

Senior Software Developer

CI Financial Corp. • Toronto, ON, CA

Full-time

At CI, we see a great place to work as one that is a safe place for everyone to have a voice, where people are empowered to take ownership over meaningful work, where there is an opportunity to gro...Show more

Last updated: 30+ days ago

Senior ETL Developer - AWS, Kafka, Netezza

Astra North Infoteck Inc. • Toronto, ON, ca

Full-time

Quick Apply

Required Skills : Netezza~Sybase Database~SQL Server 2012 Reporting Services(SSRS)~SQL Server 2012 Integration Services (SSIS). Essential Skills : ETL Developer.Resource have strong data warehouse tec...Show more

Last updated: 19 days ago

Senior Software AI Developer

PowerToFly • Toronto

Full-time

The Autodesk access group is responsible for connecting customers to their products and data, the team is driving the transformation of Autodesk’s business models, account & user management.We solv...Show more

Last updated: 7 days ago • Promoted

Senior ETL Developer

LanceSoft, Inc. • Toronto

Full-time

Tech Talent Acquisition Specialist | Tailoring Talent Solutions to Meet Business Needs | Specializing in IT and FinTech Industry. Hybrid - 2201 Eglinton Ave East Ecosystem 3, Scarborough – 3 days / we...Show more

Last updated: 7 days ago • Promoted

ETL Developer

CloudVital • Toronto

Full-time

We are currently seeking an ETL developer to design, develop, and maintain ETL processes for data integration and transformation. This is an onsite role located in Toronto, requiring you to work in ...Show more

Last updated: 30+ days ago • Promoted

Software Developer - ETL - Senior

Connvertex Technologies Inc. • Toronto, ON, Canada

Full-time

Quick Apply

Experience and Skill Set Requirements Responsibilities / Assignment Deliverables Senior ETL Developer ...Show more

Last updated: 30+ days ago

Senior ETL SDET

J&M Group • Toronto

Full-time

Be among the first 25 applicants.Good knowledge of Testing Life Cycle, SDLC and Defect Management processes for application support and development. Good knowledge with QE Processes, Methodologies a...Show more

Last updated: 28 days ago • Promoted

Senior Data Engineer — Scalable ETL, Multi-Cloud Pipelines

ACV Auctions • Toronto

Full-time

A dynamic technology company in Toronto is seeking a Senior Data Engineer to build and maintain ETL pipelines, ensure data reliability, and drive performance improvements in a fast-paced, collabora...Show more

Last updated: 28 days ago • Promoted

Senior Back-end Software Developer

Nelson Education LTD] • Toronto, Ontario, Canada

Full-time

As the largest Canadian-owned and operated K-12 publisher, Nelson Education Ltd.Canada's only heritage education content provider, known for its innovative products and solutions catering to learne...Show more

Last updated: 17 days ago • Promoted

Senior ETL Consultant

Maarut Inc • Toronto

Full-time

Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Maarut Inc. Participate in the review of project, work request and m...Show more

Last updated: 28 days ago • Promoted

Software Developer - Senior

Connvertex Technologies Inc. • Toronto, ON, Canada

Full-time

Quick Apply

Experience and Skill Set Requirements Core Skills and Experience - 40 % 10+ years of experience as a designer and developer in ...Show more

Last updated: 30+ days ago