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:

• 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).
  

Experience and Skill Set Requirements:

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
  

Skill Set Requirements:

Technical Tools:

• 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:

• 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:

• 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:

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