* Need US Citizen or Green Card Holder*
*Job Title: Informatica Developer with TeradataLocation: Parsippany, NJDuration: 6 Months contract* *Required Skills:* At least 5 to 7 years of working with Informatica Power Center At least 5 to 7 years of *in-depth Teradata development experience * 2+ years of experience with *Teradata Parallel Transporter * 3 years of experience with writing Teradata Stored Procedures 3 years of SQL Programming Experience in Teradata. Oracle and DB2 experience is plus. Expertise in Teradata SQL & Teradata Utilities like Multiload, Fastexport, BTEQ(Batch Teradata Query), Fastload, Teradata Parallel Transporter, TPump, VIEWPOINT, DATAMOVER Good experience with Teradata Performance tuning including collecting Stats, Primary Index, Primary Partitioned Index, Join Indexes, Secondary Indexes , analyzing explain plans In-depth knowledge in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (Primary Index, Unique Secondary Index, Non Unique Secondary Index and Join Index etc.) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance Experience in loading data from various data sources and legacy systems into Teradata warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica Strong DDL and DML writing skills are essential as well as being able to write complex SQLs for data analysis. Competency with Enterprise tools commonly used in an EDW environment such as TIBCO, Golden gate, etc. is a plus Data modeling skills in Teradata is a plus Experience with Teradata Administrator and Teradata Manager Tools for monitoring and control the system is a plus Certification in Teradata and Teradata SQL is a plus Experience with Unix Shell Experience working with Unix, Linux and Windows platforms Experience with tools like Data Profiling or Data Cleansing is a plus Familiarity with any BI tool, experience with Micro strategy is a plus Very Truly, *Ethan Hunt* |Sr. IT Technical Recruiter *CAT* Technology Inc. 411 Hackensack Avenue,7th Floor Hackensack, NJ 07601. Email : [email protected] [email protected] Voice : *201 257 5081 ext 151* | Fax:(201) 342-2385. Visit us at: www.catamerica.com | www.cattechnologies.com -- -- To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/CBE-Software-Engineer?hl=en --- You received this message because you are subscribed to the Google Groups "CBE Software Engineer" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
