Job Description :
W2 contract role- NO EMPLOYERS/ C2C Please

DIRECT CLIENT NEED
Location: Charlotte NC
Duration: 36 months
Interview: phone/webex

Must be USC, GC, EAD, TN visa, or H4 visa. Must be able to temporarily sit on our W2!!

Informatica Developer

Job Skills required:
Informatica 9.6.1, UNIX Shell scripting, Oracle 11g, ETL, Autosys, Data analysis

Job description/Duties:
Works closely with Information Technology staff, business, FLUs through the phases of design, coding and implementation of onboarding data source files providing clarifications and data quality as necessary. Maintains effective ongoing communications with the business and IT community and operational management regarding system plans, projects, ,and economic sanctions policies
Development experience at ETL development and ETL architecture using Informatica and understanding the flat file/Fixed file structures
Strong Oracle Database technical knowledge in building general SQL and PL/SQL, stored procedures, cursors, triggers etc…
Strong UNIX Shell scripting , Autosys, Informatica on Informatica Designer Components and development tools -Source Analyzer, Power center Designer, Power Center Repository Manager, PowerCenter Workflow Manager, PowerCenter Workflow Monitor using Unix
Perform Data analysis, data mapping, data loading, and data validation using informatica and oracle
Understand reusability, parameterization, Informatica workflow designs, and build Oracle reports
Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
Oracle Performance tuning and end-to-end lifecycle experience with Enterprise wide data and optimize the execution timings
Perform overall ETL solution design and creation of design specifications to implement changes
Perform Functional and technical impact analysis of potential changes to the clients ETL environment

MUST HAVES:
Informatica, Oracle and Unix Shell Scripting, 8+ years experience

Client : BANKING