What are the responsibilities and job description for the Lead Teradata Developer position at HCLTech?
HCLTech is looking for a highly talented and self- motivated Lead Teradata Developer to join it in advancing the technological world through innovation and creativity.
Job Title: Lead Teradata Developer
Job ID: 84270
Position Type: Full-time
Location: Pleasanton, CA
Role/Responsibilities
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).
• Optimize 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 optimization.
• Good understanding of Unix/Linux scripting.
• Excellent problem-solving and communication skills.
• CAWA Scheduler
Pay and Benefits
Pay Range Minimum: $110,000/Annum
Pay Range Maximum: $168,000/Annum
HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to secure@hcltech.com for investigation.
Compensation and Benefits
A candidate’s pay within the range will depend on their work location, 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.
How You’ll Grow
At HCLTech, we offer continuous opportunities for you to find your spark and grow with us. We want you to be happy and satisfied with your role and to really learn what type of work sparks your brilliance the best. Throughout your time with us, we offer transparent communication with senior-level employees, learning and career development programs at every level, and opportunities to experiment in different roles or even pivot industries. We believe that you should be in control of your career with unlimited opportunities to find the role that fits you best.
Salary : $110,000 - $168,000