*Hi Partners,* *Hope You are doing great!*
*Please help me with the below requirements and send me suitable resumes of your consultants ASAP !* * * *Positions : **Sr. Informatica Developer* *Location : **Trenton, NJ* *Duration : 12+ months* *US Citizen preferred, Green Card considered * Local candidates would be ideal, but not mandatory and their communication skills must be very strong… 9/10. *Citizenship Requirements: US Citizen preferred, Green Card considered * *Short Project Description:* The State and Local Government Organization of HP is seeking an *Informatica ETL Developer* for a Motor Vehicle modernization project. The person who is chosen must be *on site 5 days a week in Trenton, NJ*. * * *Education Requirements:* - 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 2+ 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). *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. *Thanks & Regards *J * * *Adam ** Clear Thought Solutions LLC | **[image: Phone]: 919-342-0824 [image: cid:image004.jpg@01CB484A.1ABFD370] 347-296-3797 | E-mail : **a...@clearthoughtsolutions.com*<a...@clearthoughtsolutions.com> ** *| URL :**www.clearthoughtsolutions.com*<http://www.clearthoughtsolutions.com/> ** *[image: cid:image001.png@01CC0414.3E7517E0] : adam.bradads [image: cid:image001.jpg@01CCC931.DF84BAE0] : Adam.cts1* *LinkedIN : **http://www.linkedin.com/pub/adam-brad/31/636/713*<http://www.linkedin.com/pub/adam-brad/31/636/713> USA |*Lakewood *New Jersey *Cary *NC | *Partners in your thought… Gateway to Success* * * We respect your Online Privacy. This is not an unsolicited mail. Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a remove in the subject line and mention all the e-mail addresses to be removed with any e-mail addresses which might be diverting the e-mails to you or click on this link to be removed. Remove link: mailto:a...@clearthoughtsolutions.com?subject=Remove_me<a...@clearthoughtsolutions.com?subject=Remove_me>We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "US_IT_ Jobs" group. To unsubscribe from this group and stop receiving emails from it, send an email to chandrakants+unsubscr...@googlegroups.com. To post to this group, send email to chandrakants@googlegroups.com. Visit this group at http://groups.google.com/group/chandrakants?hl=en. For more options, visit https://groups.google.com/groups/opt_out.