!! DIRECT CLIENT NEED !!
Job Title: Teradata/Netezza and Unix Shell scripting
Location: Charlotte, NC
Duration: 6-12 months Contract
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.khanna@itbtalent.com
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.khanna@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.khanna@itbtalent.com
Princeton Forrestal Village,116 Village Blvd,Suite 200
Princeton, NJ 08540
Voice : (929) 268-0690
Email: neil.khanna@itbtalent.com
You received this message because you are subscribed to the Google Groups "softwarejobs_US" group.
To unsubscribe from this group and stop receiving emails from it, send an email to softwarejobs_us+unsubscribe@googlegroups.com.
To post to this group, send email to softwarejobs_us@googlegroups.com.
Visit this group at http://groups.google.com/group/softwarejobs_us.
For more options, visit https://groups.google.com/d/optout.
Postar um comentário