> Markdown version of [/jobs/ext/4750451-tera-data-consultant](https://www.wearedevelopers.com/jobs/ext/4750451-tera-data-consultant). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Tera Data Consultant - **Company:** SonSoft Inc. - **Location:** Charlotte, NC, United States - **Experience:** Experienced - **Contract:** Temporary contract - **Skills:** Adobe InDesign, Application Performance Management, Unix, Data Compression, Data Warehousing, Query Optimization, Software Engineering, SQL Databases, Teradata SQL, Information Technology - **Published:** November 16, 2026 - **Apply:** https://www.adzuna.com/details/5920375656 ## About the Role * 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 * Ability to ramp up in new technologies * Ability to work in a team, in diverse/ multiple stakeholder environment. * Experience in Financial domain * Strong analytical skills * Experience and desire to work in a Global delivery environment Qualifications Basic Qualification: * 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 * Flexibility to Self learn and understand the system, further assist with query tuning and application performance.