ITB Direct Client Teradata/Netezza and Unix Shell scripting Consultant *Please note: *We need only GC candidates for this requirement. Experience: 6-8 yrs
Job Title: Teradata/Netezza and Unix Shell scripting Duration: 6 Months (extension possible) Location: Charlotte, NC (GC holder) *Primary Skill: Teradata/Netezza and Unix Shell scripting* *Job Description:* Ø Candidate should have strong Data Warehousing / BI background / SQL knowledge. Ø Candidates with good Experience in Telecom/Cable Domain will be given preference Ø Candidate should have strong Unix shell scripting knowledge Ø Candidate should have strong knowledge in Netezza Ø Candidate should have good knowledge on loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, and FASTLOAD utilities. Ø In-depth expertise 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 (PI/USI/NUSI/JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance Ø Extensive use of transformations like Aggregate, Filter, Join, Expression, Lookup, Update Strategy, Expressions, Sequence Generator Transformations. Used debugger to test and fix mapping. Ø Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them Ø Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc. Ø Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system. Ø Use of various Teradata utilities. Ø Candidate should be flexible in working onshore/offshore model. *Thanks & Regards,* *Scott Norman- IT Recruiter,* *Direct: (609) 423-7945,* *E-mail: [email protected] <[email protected]>* *URL : www.itbrainiac.com <http://www.itbrainiac.com>* *Princeton Forrestal Village* *116 Village Blvd, Suite 200* *Princeton - New Jersey 08540* -- -- *************************************************************************************** For all SAP related tutorials,Articles,Faqs,Tips www.sapbrainsonline.com **************************************************************************************** You received this message because you are subscribed to the Google Groups "sapbrains" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sapbrains?hl=en --- You received this message because you are subscribed to the Google Groups "sapbrains" 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.
