Software Developer - ETL - Senior

LanceSoft

  • Toronto, ON
  • Permanent
  • Full-time
  • 2 months ago
Title: Software Developer - ETL - Senior
Location: Hybrid in Toronto
Duration: 6-8 monthsSkills
Experience and Skill Set Requirements
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 webservice
  • 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

LanceSoft