Software Developer ETL 8658

Foilcon

  • Toronto, ON
  • Permanent
  • Temps-plein
  • Il y a 2 mois
Job Description:HM Note: This hybrid contract role is three (3) days in office. Candidates resume must include first and last name.DescriptionThe 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).
SkillsExperience and Skill Set RequirementsTechnical 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
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

Foilcon