*Only GC, Citizens* *Job title : Informatica ETL Developer *
*Location : TRENTON, NJ 08666* *Duration : 12 months* *Citizenship Requirements: *US Citizen preferred, Green Card considered *Education/Experience Requirements: MUST HAVE* · 7+ years of IT industry experience with 5+ year’s experience with Informatica · Extensive hands-on expertise using Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x and Erwin Data Modeler · Min 2+ years experience with Informatica PowerExchange Real-time CDC · Min 4+ years database experience with Oracle SQL/PLSQL – PL SQL is a must · Experience in writing shell scripting for various ETL needs and worked on integrating data from flat files (mainframe). · Experience with full Systems Development Life Cycle (SDLC). · Experience with User Acceptance Testing (UAT). *Skills Required:* • Involved in gathering requirements and create design documents and mapping documents. • Involved in design and development complex ETL mappings and stored procedures in an optimized manner. Used Power exchange for mainframe sources. • Created metadata queries which would help in restart and to find out any missing link conditions or disabled tasks in a workflow. • Fine-tune existing Informatica maps for performance optimization. • Debugging mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system. • Involved in Unit testing and System testing. Best Regards, *Tom Martin* Sr. IT Recruiter 459 Herndon Parkway Suite 11, Herndon, VA – 20170 tmar...@idexcel.com I www.idexcel.com Phone: 571-441-0419 l Fax: (703) 880-7584 -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/groups/opt_out.