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

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