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
73
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
Rated Requirements
Public Sector Experience 5%
Experience working in the Public Sector and familiarity with I&IT project management processesIDMC / 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 skillsStrong 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