Software Developer ETL 8658-2412

Dheya; Toronto; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A leading company based in Toronto is looking for an ETL Developer with extensive experience in Informatica PowerCenter and programming skills in SQL, Python, or Java. The successful candidate will be responsible for developing and supporting data exchange jobs, working in a hybrid role with three days in the office each week. This position requires strong technical knowledge and experience working with complex workflows and data mapping in a public sector environment.

Qualifications

• 5+ years of experience with Informatica PowerCenter ETL tools.
• Experience with Web services, XML development, and Oracle PL/SQL.
• Familiarity with public sector environments and OPS IT methodologies.

Responsibilities

• Design and support data exchange jobs in Informatica ETL.
• Develop programming specifications and maintain unit tests.
• Create complex workflows including notifications and roll-backs.

Skills

ETL Tools

SQL Programming

Data Warehousing Concepts

Python

Java

Cloud Integration

Agile Methodologies

Tools

Informatica PowerCenter

Oracle Database

SOAPUI

Job description

Skills Required :

• ETL Tools e.g. Informatica, Talend
• SQL Programming
• Data Warehousing Concepts
• Python or Java Programming
• Cloud Integration e.g. AWS, Azure
• Agile Methodologies

HM Note: This hybrid contract role requires three (3) days in the office. Candidates' resumes must include first and last names.

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 data exchanges that facilitate agreements between MPBSD and agencies such as CRA, ISED, WSIB, and MOF.

Experience and Skill Set Requirements

Technical Tools - 45%

• Experience with Informatica PowerCenter to create complex workflows, including notification emails and roll-backs.
• 5+ years of experience with the Informatica PowerCenter ETL toolset.
• 5+ years of experience with ETL script development.
• Experience using Informatica tools to read inbound data from web services.
• Experience creating outbound web service messages from traditional data sources.

Programming Experience - 30%

• Experience with Web services, XML development, and design.
• Experience with tools such as SOAPUI, SQL queries, Web Services.
• Knowledge of WSDL, SOAP.
• Experience with data mapping and XML parsing.

Oracle Database Experience - 20%

• Experience with Oracle 12c.
• Experience developing complex Oracle PL/SQL scripts for data retrieval and formatting.
• Experience with Oracle Database DML/DDL scripting.

Public Sector Experience - 5%

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

Must Haves:

• Experience using Informatica PowerCenter to create complex workflows.
• Experience with Web services and XML development and design.
• Experience with data mapping and XML parsing.

Didn't find the role you were looking for? Upload your resume now to get considered for future job opportunities at Foilcon.