Information Technology - Toronto

Our Client in the Pensions industry is seeking a Informatica Admin & Developer for their downtown Toronto Office, for a 1 year contract, high possibility of extension.
Position Scope
o Scope of Position – Why does the position exist? As each job has a purpose, this section gives a brief summary of the job, covering the main responsibilities, framework within which the job operates and the main contribution to project.
The primary purpose of this position is to design, develop, implement and automate Informatica ETL processes to support the movement and integration of data between clients’ Legacy applications and the new Pension solution (and its multiple environments).

Key accountabilities
• Work closely with key project teams – Technical Foundations (TFT), Data Conversion and Testing – to assist in automating, optimizing and executing ETL processes for moving data into multiple target environments
• Using core Informatica skills & tools (e.g., PowerCenter Developer, Informatica Administration, Test Data Management) to design solutions to meet the requirements of converting, moving & refreshing data into multiple target test environments, each comprised of a combination of the following ERP applications: PeopleSoft, Sales force and Oracle EBS.
• Develop and document automation processes for existing ETL workflows to support the movement and conversion of data into the required target applications
• Administer, plan and support the implementation & execution of automated ETL processes related to Test Data Management strategies inclusive of data subsets to align with sizing constraints in lower environments


• Informatica (v9.6 & higher) – Admin and Developer
• Informatica PowerCenter & Informatica Cloud
• ETL Job Automation, Run Control & Optimization
• SQL (PL/SQL) Oracle experience
• Ability to document operational procedures (e.g., ETL runbook)
• Work experience planning and executing data conversion activities
• Experience developing ETL processes to/from ERP applications (preference is PeopleSoft)
To Apply, Please send your resume to:

Position Type Contract
Application Deadline February 9, 2018
Experience Required 1 year
Job Duration 1 year
Education Required Bachelors