Tera Data Consultant

Tera Data Consultant

Sonsoft, Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

• At least 4 years of experience in software development life cycle stages
• Certification in Teradata
• At least 4 years of experience in Project life cycle activities on development and maintenance projects
• At least 2 years of experience in Design and Architecture review
• At least 2 years of experience in application support and maintenance (including some experience on-call support)
• Ability to ramp up in new technologies
• Ability to work in a team, in diverse/multiple stakeholder environment
• High impact communication
• Experience in Financial domain
• Experience and desire to work in a Global delivery environment

• Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education
• At least 4 years of work experience in Information Technology
• At least 4 years of hands on Teradata experience
• Experience in full software development lifecycle of the Data Warehousing Project
• Strong knowledge of Teradata Architecture:
  Nodes (AMP &PE), VProcs, BYNETS
• Efficient usage of Teradata DDL Statements – Derived Tables, Volatile Tables and Global Temporary Tables
• Hands on Knowledge on Teradata Concepts – Primary Index, Partitioned Primary Index, Secondary Index, Join Index and Compression Techniques
• Understand the Concept of Locking Mechanisms in Teradata
• Experience on Query Tuning mechanisms using indexes & proper usage of Statistics in Teradata
• Efficient in Writing SQL's with complex joins, aggregations, UNIX Scripts
• Good understanding of Data Warehouse Modeling concepts
• Experience in using the built in Teradata Functions
• Efficient in writing Dynamic SQL's, creating a BTEQ Scripts and executing the scripts
• Hands on experience on creating scripts for Load Utilities Fast export, Fast Load, Multi Load, TPUMP and TPT for exporting and loading the data
• Responsible for writing efficient views based on user and reporting requirements
• Must be able to provide Solutions or Enhancements to fix the data issues quickly when reported by the clients or users

** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Note:

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply