{"schemaVersion":"jobsearcher.job.v1","id":"61bd2089971fa69cab675443","url":"https://jobsearcher.com/jobs/61bd2089971fa69cab675443","canonicalUrl":"https://jobsearcher.com/jobs/61bd2089971fa69cab675443","title":"Lead Teradata Developer","description":"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 DeveloperJob ID: 84270Position Type: Full-timeLocation: Pleasanton, CARole/ResponsibilitiesKey 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 SchedulerPay and Benefits Pay Range Minimum: $110,000/AnnumPay Range Maximum: $168,000/AnnumHCLTech 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 BenefitsA 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 GrowAt 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.","company":"HCLTech","rawCompany":"hcltech","city":"Pleasanton","state":"CA","isRemote":false,"isActive":false,"createdAt":"2026-04-12T18:43:57.063Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Lead Teradata Developer","description":"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 DeveloperJob ID: 84270Position Type: Full-timeLocation: Pleasanton, CARole/ResponsibilitiesKey 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 SchedulerPay and Benefits Pay Range Minimum: $110,000/AnnumPay Range Maximum: $168,000/AnnumHCLTech 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 BenefitsA 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 GrowAt 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.","datePosted":"2026-04-12T18:43:57.063Z","dateModified":"2026-04-12T18:43:57.063Z","hiringOrganization":{"@type":"Organization","name":"HCLTech","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Pleasanton","addressRegion":"CA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"61bd2089971fa69cab675443"},"url":"https://jobsearcher.com/jobs/61bd2089971fa69cab675443"}}