Job Details

Top Three Skills:

6-7 Years Informatica Experience
SQL / TSQL Server 
Data Modeling 

Job Description:

Required Skills
Informatica PowerCenter tool experience 
· Develop new Informatica jobs to capture additional data from BoS Operational Data Stores 
· Performance tune existing Informatica jobs to reduce run times and amount of resources used on shared Informatica servers 
· Troubleshoot existing Informatica jobs for production defects and make corrections
· Ability to connect Informatica to web services, XML, CSV, DB2, SQL Server, and Oracle sources 

Strong SQL Skills 
· Develop SQL overrides with Informatica PowerCenter
· Develop views joining multiple tables with complex relationships
· Complex queries troubleshooting data issues


Desirable knowledge
MS Excel
MS Access
Control-M 
Autoflow
Perl or other scripting languages
KSH or other Linux shell scripting 
Service Management Change Process