Job Teradata consultant New York Teradata

Teradata consultant

Skills:Teradata       |  Location:New York  ,  United States Of America

Views:214



 Title                       : Teradata consultant with GreenPlum

Location               : Midtown Manhattan NY

Job Duration:      : 6+ Months 




Job Description



 Must possess good understanding of project management methodologies and
software development life cycle (SDLC.
  Perform physical modeling of large DBMS live, GreenPlum,DB2, and Teradata.
 Responsible for defining, designing, integrating, and re-engineering the
Enterprise Data warehouse and DataMarts in different environments, including
environments such as Teradata,GP as well as DB2, with multiple Terabytes of
size and various levels of complexity. 
 Work to increase performance of the database, as well as fine tune any
issues.
 Responsible for scheduling tools such as Autosys for automating and
scheduling jobs to run.
  Configure ETL Job for extraction, data messaging, and loading.
 Must be able to debug and build new code. Requires experience in design,
enhancement, and development of applications for OLTP, OLAP, and DSS using
dimension modeling with Teradata.
Requires experience with overall ETL design (from staging to presentation
layer) using market-leading ETL tool Informatica and experience with ETL tool
development in Perl.
Must possess advanced SQL skills, including use of derived tables, unions,
and multi-table inner/outer joins.
Requires knowledge of different schemas to fit reporting, query and
business analysis requirements.
 Must possess experience with XML parsing techniques, Perl and UNIX shell
scripting and programming, automated reports generation using job scheduling
tools such as Autosys, and experience with using code repository tools such as
CVS, VSS, Perforce, and RCS. 
Requires experience with export/import utilities in multiple databases,
including DB2, Teradata, Greenplum,using tools such as mload, bteq, DB2 load,
DB2 export, bcp, gpload, and copy.
 Requires experience with the usage of database interface applications such
as SQLAssistant and DBArtisan and familiarity with JIRA issue tracker and the
defect tracking system Quality Centre.
 Work with Development teams to ensure that all standards are correctly
followed. Responsible for performing database management, including updating,
quality assurance, metrics, writing user documentation, table level
specification documents, table process flow documents, and training.
Must be proficient in data warehouse development practices and processes,
including monitoring the database plant performance with tools such asTeradata
Viewpoint, Performance Monitor, and Teradata Administrator.
Requires working experience in physical modeling large DBMS live 
GreenPlum/DB2/Teradata and detailed experience in performance and tuning.
Requires experience with indexes, statistics, data partitioning, and query
plans.   

Name Email Skills
Resume Save me for future references

Submit

Registered users get access to all hidden jobs.


Check Similar Jobs



Create Job Alerts

Create Job Alerts
Skill
State
Email


Recent Gigs

Recruiter website-($25)
I will create recruiter website for your business.
Not rated
Will set up job pages in your website-($0)
I will set up job pages in your website.
You can start .
Not rated
Social Media Consultant -($20)
I want to help small business reach there full potential. <.
Not rated
Social Media Consultant -($20)
I want to help small business reach there full potential. <.
Not rated
set up job board website-($25)
with this gig, i will set up job board for your business. Not rated



Recent Projects

Link Building Opportunity-($10-$100)
Link Building Opportunity

I am currently looking
Social media API integration-($100-$500)


I have a website where in users can register in
Create a Facebook page-($100-$500)
Create a Facebook page

I need someone to help me
need a professional website-($1000-$2000)

We require a slick cool website to promote an event.
Facebook Advertising expert-($1000-$2000)
Facebook Advertising expert

We are looking for so