Previous Job
ETL Developer
Ref No.: 18-10695
Location: Fremont, California
Position Type:Contract
Project Duration 12 months
Project Summary The scope of this project is to use the Informatica platform to "preprocess” and ETL to do data migration.
Role Informatica Developer
Responsibilities • Understand business and functional requirements to be developed.
• Develop mappings & workflows using Informatica PowerCenter
• Integrate Informatica Powercenter code with other components
• Support Dev/SIT/UAT/PFIX cycles & PROD support
Technical Skills - In Detail
(Essential Skills)
• Total Experience: 4-5+ years
• Informatica Powercenter tools ( designer,workflow manager, workflow monitor)
Experience in XML file transformation
• Experice in SWIFT message transformation (Optional)
• Experience in File processing & validation using Informatica.
• Powercenter transformations (look-up, xml, filter, router etc.)
• Powercenter debugger.
• Powercenter tasks, sessions, email tasks etc.
• Flat files, xls, csv , database as powercenter source and targets.
• Good database knowledge ( Oracle PLSQl)
• Shell scripting, MS Access
Technical Skills
(Desired Skills)
Experience in Banking & Financial Domain