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 experience
Opportunity Details

Client Reference
 RQ10057

# of Openings
 2

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 Street, Toronto, 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 / Redshift 50%
  • ​​​​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 35%
  • ​​​​​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 10%
  • ​​​​​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.

  • 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...


  • 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...


  • Toronto, Ontario, Canada Software International Full time $110,000 - $145,000 per year

    Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US. We are currently hiring for a Senior Software Developer Agentic Application Development for our global IT M&A client in the Toronto area.Role: Senior Software Developer Agentic...


  • Toronto, Ontario, Canada Software International Full time US$100,000 - US$130,000 per year

    Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US. We are currently hiring for a Senior Software Developer Agentic AI Experimentation & Prototyping for our global IT M&A client in the Toronto area.Role: Senior Software Developer Agentic...


  • Toronto, Ontario, Canada Beacon Software Full time $75,000 - $120,000 per year

    Senior Software Engineer SnailWorks is a vertical SaaS platform purpose-built for the direct mail and marketing industry. We provide real-time visibility into USPS-delivered campaigns by ingesting, translating, and enriching scan data at scale. Our customers rely on us for mission-critical tracking—outbound mail, inbound reply workflows, analytics...


  • Toronto, Ontario, Canada Beacon Software Full time US$120,000 - US$200,000 per year

    Beacon Software is a permanent capital holding company which acquires and grows essential businesses. We are a profitable series B+ firm that combines great technologists, operators and M&A professionals to accelerate the scale of the ambition of the dozens of businesses we own and operate. We are supported by capital from tier-1 venture capital, crossover,...


  • Toronto, Ontario, Canada Beacon Software Full time $150,000 - $200,000 per year

    Beacon Software is a permanent capital holding company which acquires and grows essential businesses. We are a profitable series B+ firm that combines great technologists, operators and M&A professionals to accelerate the scale of the ambition of the dozens of businesses we own and operate. We are supported by capital from tier-1 venture capital, crossover,...


  • Toronto, Ontario, Canada Banyan Software Full time $90,000 - $115,000 per year

    Job Title: Senior .NET Developer Location: Burlington, Greater Toronto Area (Hybrid)Job Type: Full-TimeCompany: boostCX (A Banyan Software Portfolio Company)Salary Range: CAD 90,000-115,000 per annum About boostCX: boostCX is a customer experience technology provider focused on empowering organizations with intuitive, scalable tools that drive engagement,...


  • Toronto, Ontario, Canada Beacon Software Full time $90,000 - $120,000 per year

    Senior Software Engineer MAP Policy Partners is a Beacon Software portfolio company and a leader in MAP (Minimum Advertised Price) enforcement automation. With over 15 years of industry experience, we've engineered a streamlined, automated solution for MAP monitoring and enforcement, built to detect, investigate, and act on violations across millions of...


  • Toronto, Ontario, Canada Banyan Software Full time $120,000 - $180,000 per year

    Banyan Software provides the best permanent home for successful enterprise software companies, their employees, and customers. We are on a mission to acquire, build and grow great enterprise software businesses all over the world that have dominant positions in niche vertical markets. In recent years, Banyan was named the #1 fastest-growing private software...