Software Developer ETL

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 Power Center to create complex workflows, including notification emails and roll-backs.
• 5+ years of experience with the Informatica Power Center 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 Power Center 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.