Informatica Powercenter DeveloperÂ
Charlotte NC
6+ months contract
Additional Job Details:Â
Basic qualifications:Â
5+ years of experience in development, maintenance, and enhancement of Informatica Mappings, Workflows, and other processes using Informatica Powercenter 9.1Â
Developed efficient and effective solutions to diverse and complex business problemsÂ
Experience in data warehouse systems and its related implementations using InformaticaÂ
Must have experience in writing complex SQL queries and understanding PL/SQL Programs in Oracle 11g and/or 12g DBÂ
Experience in performance tuning of poorly performing data loads/ ETLsÂ
Worked with files containing a million plus recordsÂ
Worked with the following sources/targets: Oracle tables, views, queries, flat files, and COBOL filesÂ
Experience in resolving project/production problems and on call supportÂ
Strong problem solving and troubleshooting skillsÂ
Ability to work independently once guidance and goals are providedÂ
Developed original and/or complex code and provided coding guidance to less experienced staffÂ
Verified program logic by overseeing the preparation of test data, testing and debugging of programs. Participated in overall systems testingÂ
Strong interpersonal and communication skills; works well in a team environmentÂ
Bachelor's degree or equivalent work experienceÂ
Minimum Qualifications:Â
5+ years of experience using Informatica Powercenter 9.1 (or greater) and Oracle SQLÂ
Experience with UNIX shell scripting and Autosys is a mustÂ
Experience in performance tuning of slowly running data loads/ ETLs is a mustÂ
Worked with files containing over a million records is a mustÂ
Worked with the following sources/targets: Oracle tables, views, queries, flat files, and COBOL files is a mustÂ
Track record of 2+ full project lifecycle and development, as well as post-implementation support activitiesÂ
Excellent writing and documentation skillsÂ
Preferred skills:Â
Familiarity with SDLC methodologies, defect tracking (including tools)Â
Previous exposure to Accounting / Financial applicationsÂ
Experience with NDMÂ
Knowledge of Informatica related software installationÂ
Technical certifications and advanced degrees are a plus, but not a requirementÂ