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 "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.