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.
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).
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: firstname.lastname@example.org
|Application Deadline||February 9, 2018|
|Experience Required||1 year|
|Job Duration||1 year|