*!! **DIRECT CLIENT NEED* *!!*
Job Title: Teradata/Netezza and Unix Shell scripting Location: Charlotte, NC Duration: 6-12 months Contract Required background: 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. *Note: Please reply me on my official E-Mail ID : **neil.kha...@itbtalent.com <neil.kha...@itbtalent.com>* Kindest Regards: Neil Khanna | Lead Professional Recruiter ITBrainiac Inc Princeton Forrestal Village,116 Village Blvd,Suite 200 Princeton, NJ 08540 Voice : (929) 268-0690 Email: neil.kha...@itbtalent.com -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.