Hi, *Please reply to prady...@sysmind.com <prady...@sysmind.com>*
Please go through the below job description and let me know - *Primary Skill:* Teradata/Netezza and Unix Shell scripting *Duration:* 6 Months (extension possible) *Location:* Charlotte, NC *Experience:* 6-8 yrs *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 and Regards *Pradyut Bhattacharya* *prady...@sysmind.com* <prady...@sysmind.com> Phone:609-897-9670 Extn 2166 Gtalk: praddy.staff...@gmail.com SYSMIND Address: 38 Washington Road, Princeton Junction, NJ 08850 -- You received this message because you are subscribed to the Google Groups "International SAP Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to international-sap-projects+unsubscr...@googlegroups.com. To post to this group, send email to international-sap-projects@googlegroups.com. Visit this group at http://groups.google.com/group/international-sap-projects. For more options, visit https://groups.google.com/d/optout.
