ETL Informatica Developer

  • Job Category:

    IT Software- Programming

  • Industry:

    Information Technology

  • Location:

    Toronto, Ontario

  • Advertised:

    21-08-2020

  • Position Type:

    Closed

  • Job Term:

    6-Months

  • Rate:

    $70 Per Hour

  • Job ID:

    1322

DESCRIPTION 

Wirehead is seeking one (1) Informatica Developer for a 6-month contract in downtown Toronto (work remotely from home).


Deliverables; What you’ll do

  • Design, develop and test an Informatica Powercentre Workflow (Job) to take new or updated data from a view in an Oracle Database, on a daily schedule, and copy to a temporary data store and email a designated business resource on successful completion or failure (Daily Catalyst Extract) 
  • Design, develop and test an Informatica Powercentre Workflow (Job) to identify new & updated records in a temporary data store and then create & send a defined web service message to a specific target, on a scheduled basis (BN15 Search, BN15 Create, BN15 Update Messages) 
  • Design, develop and test an Informatica Powercentre Workflow (Job) to identify new & updated records in a temporary data store, create a txt file based on a defined layout, send to
  • a defined target via S/FTP, and email a designated business resource on successful completion or failure.(ISED NUANS File, SO Reporting Extract File, & WSIB data file)
  • Design, develop and test an Informatica Powercentre Workflow (Job) pick-up a file from an FTP location, extract & load the records into a temporary data store and then create & send a defined web service message to a specific target, on a scheduled basis for each record in the file, and email a designated business resource on successful completion or failure (CTAR T2 return loading, MOF Default Notices)


Requirements: What you'll need

 

Skills, Knowledge, Experience, and Qualifications;

  • Experience using Informatica Powercentre to create complex workflows that integrate notification emails & roll-backs 
  • 3+ years demonstrated experience with the Informatica Powercentre ETL toolset 
  • 3+ 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 
  • 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 
  • 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 
  • Experience working in a highly complex, unionized and multi-stakeholder environment. 
  • Understanding of OPS IT methodologies and standards 

 

 

HOW TO APPLY

 

Please apply for this opportunity by sending your resume directly to careers@wirehead.com

 

We thank all candidates for their interest, but advise that only candidates selected for interviews will be contacted directly. Rest assured that your resume will be kept on our database and will be considered for all future opportunities. 

 

For more information, please visit us at: http://www.wirehead.com

 

For a full list of our job postings: http://www.wirehead.com/current-jobs

***This opportunity is located in Toronto; preference will be given to local candidates. Wirehead does not offer a relocation package. 

 

We encourage you continue to refer to our Job Listing page as new opportunities become available and updated on a regular basis. Thank you again for your interest in Wirehead!

Request a Sales Call

  • Name
  • Phone
  • Email
  • Message

Ready to talk now?
416-504-5866 ext. 224