RQ08658 - Software Developer - ETL - Senior

Maarut Inc; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading company in the IT sector is seeking a developer to translate technical specifications into applications, focusing on ETL processes using Informatica Powercentre. The ideal candidate will have extensive experience in public sector projects and be proficient in Oracle database scripting. This role involves collaborating with various stakeholders to ensure effective data exchange, requiring a solid background in web services and XML development.

Qualifications

• 5+ years experience with Informatica Powercentre ETL toolset.
• Experience in data mapping and XML parsing.
• Demonstrated experience in a public sector environment.

Responsibilities

• Design, code, test, and implement ETL jobs using Informatica.
• Support data exchange initiatives with multiple government agencies.
• Maintain and conduct unit tests on developed applications.

Skills

Informatica Powercentre

Web Services

XML Development

Data Mapping

XML Parsing

Tools

SQL

SOAPUI

Oracle PL/SQL

Job description

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

Requirements

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.