Technical Specialist
United States
Apply now
Job Description
Technical Specialist
Others, California

Job Summary

To conceptualize| design and deliver product / sustenance delivery through the team as per defined scope and standards in a particular technology

Job Title: Teradata Developer
Location: US (San Jose, Dallas)
Experience: [6+ years]
Employment Type: Full-time
 
Role Overview
We are seeking a skilled Teradata Developer to design, develop, and optimise data solutions on the Teradata platform. The ideal candidate will have strong SQL expertise, experience in ETL processes, and a deep understanding of Teradata architecture and performance tuning.
 
Key Responsibilities
•    Design and develop complex SQL queries, stored procedures, and macros in Teradata.
•    Implement ETL workflows using tools like Informatica, BTEQ, or Teradata utilities (FastLoad, MultiLoad, TPT).
•    Optimise queries and manage performance tuning for large-scale data environments.
•    Collaborate with data architects and business analysts to translate requirements into technical solutions.
•    Perform data validation, troubleshooting, and issue resolution.
•    Ensure compliance with data governance and security standards.
 
Required Skills & Qualifications
•    Strong experience in Teradata SQL, joins, indexes, and explain plans.
•    Hands-on experience with Teradata utilities (FastLoad, MultiLoad, TPT, BTEQ).
•    Knowledge of ETL tools (Informatica, DataStage, or similar).
•    Familiarity with data warehousing concepts and BI tools.
•    Proficiency in performance tuning and query optimisation.
•    Good understanding of Unix/Linux scripting.
•    Excellent problem-solving and communication skills.
•    CAWA Scheduler
 
Preferred Skills
•    Experience with Teradata Vantage and advanced analytics.
•    Exposure to cloud platforms (AWS, Azure, GCP) for Teradata integration.
•    Knowledge of Agile methodologies.

Key Responsibilities

1. To architect| design and develop (through Team) solution for product/project & sustenance delivery
2. To support as an SME
3. To ensure knowledge up-gradation and work with new technologies so that the solution is current and meets quality standards and the client requirements
4. To train and develop team so as to ensure that there is an adequate supply of trained manpower in the said technology and deliver risks are mitigated
5. To gather specifications and deliver solutions to the client organization based on understanding of a domain or technology
6. To review project deliverables.
7. To recommend client value creation initiatives and implement industry best practices (on specific technology/product)

Skill Requirements

null

Other Requirements

null
Maximum Salary (US):  168000
Minimum Salary (US):  110000
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 226,300 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending December 2025 totaled $14.5 billion.

Compensation and Benefits

A candidate’s pay within the range will depend on their skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year.