Software Developer ETL 8658-2412

Foilcon; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading company, Foilcon, is seeking a Software Developer ETL to design and support data exchange jobs using Informatica in a hybrid setting. This mid-senior level contract role requires extensive experience in ETL tools and web services, core to supporting various governmental agreements.

Qualifications

• 5+ years of experience with Informatica Powercentre ETL toolset.
• Experience in Oracle PL/SQL script development.
• Experience in a multi-stakeholder public sector environment.

Responsibilities

• Design, code, test, implement, and support data exchange jobs.
• Develop detailed programming specifications and conduct unit tests.
• Create complex workflows that integrate notification emails & roll-backs.

Skills

Informatica Powercentre

Web services

XML development and design

Data mapping

XML Parsing

Job description

Join to apply for the Software Developer ETL 8658-2412 role at Foilcon

3 days ago Be among the first 25 applicants

Join to apply for the Software Developer ETL 8658-2412 role at Foilcon

HM Note: This hybrid contract role is three (3) days in office. Candidates resume must include first and last name.

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 that is currently deployed within the Ontario Business Registry environment
• These data exchanges support agreements between MPBSD and the Canada Revenue Agency (CRA), Innovation, Science and Economic Development Canada (ISED), Workplace Safety and Insurance Board (WSIB) and Ministry of Finance (MOF).
  
  

Skills

Experience and Skill Set Requirements

Technical Tools - 45%

• Experience using Informatica Powercentre to create complex workflows that integrate notification emails & roll-backs
• 5+ years demonstrated experience with the Informatica Powercentre ETL toolset
• 5+ years demonstrated experience with ETL script development
• Demonstrated experience using Informatica tools to read inbound data from a web service
• Demonstrated experience using Informatica tools to create outbound web service messages from a traditional data source
  
  

Programming Experience - 30%

• Experience with Web services and XML development and design
• Experience with software development tools such as SOAPUI, SQL query, Web Services
• Description Language (WSDL), SOAP
• Experience with data mapping and XML Parsing
  
  

Oracle Database Experience - 20%

• Experience with Oracle 12X
• Experience in developing complex Oracle PL/SQL scripts to retrieve and format data to meet business requirements
• Experience with Oracle Database DML/DDL script development
  
  

Public Sector Experience - 5%

• Experience working in a highly complex, unionized and multi-stakeholder environment.
• Understanding of OPS IT methodologies and standards
  
  

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

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Engineering and Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Foilcon by 2x

Sign in to set job alerts for “Software Engineer” roles.

Software Engineer, Backend (All Levels / All Teams)

Software Engineer I, Entry Level (Fall 2024-Spring 2025) - Toronto

Graduate 2025 Software Engineer I, Canada

Software Developer Full Stack (Junior) 9063-1115

Software Engineering Intern (September 2025)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.