logo

View all jobs

Programmer/Developer - Level 2

Toronto, Ontario
Qualification:
  • 3+ years experience with the Informatica Powercentre ETL toolset and script development where they have successfully designed and implemented complex workflows that integrate notification emails & roll-backs
  • Demonstrated experience with Web services and XML development, SOAPUI, SQL Query
  • Experience with Oracle 12x and in developing complex Oracle PL/SQL scripts to retrieve and format data to meet business requirements and design
Responsibilities
  • 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)
  • 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.
  • General Skills
  • Experience in programming and analysis at the specified experience level
  • Ability to collaborate with IT Professionals throughout the Software Development Life Cycle
  • Experience in structured methodologies for the development, design, implementation and maintenance of applications
  • Experience in design, code, test, debug and document applications
  • Experience in the use of object and/or third generation language development tools
  • Experience in one or more programming languages
  • Experience in application design, latest design patters, deployment and troubleshooting
  • Experience with relational and hierarchical database technologies

Share This Job

Powered by