RQ08658 - Software Developer - ETL - Senior

S M Software Solutions Inc; Toronto; Hybrid; CAD 85,000 - 120,000; Full time

Job summary

A leading IT consulting firm is seeking a skilled Senior Software Developer specializing in ETL using Informatica for a hybrid role. The successful candidate will streamline data exchanges and enhance application development for public sector clients. Candidates should have extensive experience in data mapping, web services, and Oracle databases, along with a strong understanding of OPS IT standards.

Qualifications

• 5+ years experience with Informatica Powercentre.
• Familiar with data mapping and XML Parsing.
• Experience in complex, unionized, multi-stakeholder environments.

Responsibilities

• Design, code, test, implement ETL jobs in the Informatica tool.
• Support data exchange jobs with government agencies.

Skills

Informatica Powercentre

ETL script development

Web services

XML

PL/SQL scripting

Job description

RQ08658 - Software Developer - ETL - Senior

1 day ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Client: Ministry of Public and Business Service Delivery and Procurement

Work Location: 222 Jarvis St, 5th Floor, Toronto, Ontario, Hybrid

Estimated Start Date: 2025-07-21

Estimated End Date: 2026-03-31

#Business Days: 173.00

Extension: Probable after the initial mandate

Hours per day or Week: 7.25 hours per day

Security Level: No Clearance Required

Must Haves

• Experience using Informatica Powercentre to create complex workflows
• Experience with Web services and XML development and design
• Experience with data mapping and XML Parsing

Description

The resource is 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, maintaining, and conducting unit tests.

Responsibilities Will Include

• Design, code, test, implement, and support data exchange jobs in the Informatica ETL tool deployed within the Ontario Business Registry environment
• Support agreements between MPBSD and agencies like CRA, ISED, WSIB, and MOF through data exchanges

Experience And Skill Set Requirements

Technical Tools - 45%

• 5+ years experience with Informatica Powercentre and ETL script development
• Experience with inbound and outbound web services using Informatica

Programming Experience - 30%

• Experience with Web services, XML, WSDL, SOAP, and related development tools

Oracle Database Experience - 20%

• Experience with Oracle 12X, PL/SQL scripting, DML/DDL

Public Sector Experience - 5%

• Experience in complex, unionized, multi-stakeholder environments and understanding of OPS IT standards

Note

• Hybrid work: 3 days onsite / 2 days remote

Eligibility and Application Steps

Interested candidates should send the following documents to [e-mail]:

• Updated Resume (Word format)
• Skills Matrix and References
• Expected hourly rate
• Visa Status
• LinkedIn Profile

Only applications with all mandatory documents will be considered. Feel free to share or tag suitable candidates. For questions, contact [phone].

Additional Information

• Senior level: Mid-Senior
• Employment type: Full-time
• Job function: Engineering and IT
• Industries: IT Services and Consulting