Hi, *Please reply to [email protected] <[email protected]>*
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* *[email protected]* <[email protected]> Phone:609-897-9670 Extn 2166 Gtalk: [email protected] SYSMIND Address: 38 Washington Road, Princeton Junction, NJ 08850 -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.
