Lean IT Inc.
Lead Teradata Developer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Lead Teradata Developer in Pleasanton, CA, lasting 6 months with a pay rate of "$X/hour." Requires 8+ years of experience in Teradata SQL, ETL tools, performance tuning, and Unix/Linux scripting.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
June 16, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
On-site
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Pleasanton, CA
-
🧠 - Skills detailed
#Unix #Informatica #DataStage #FastLoad #Security #SQL (Structured Query Language) #"ETL (Extract #Transform #Load)" #BTEQ #Teradata SQL #Data Governance #Compliance #Business Analysis #Data Architecture #BI (Business Intelligence) #MLOAD (MultiLoad) #SQL Queries #Linux #Teradata #Macros #Scripting
Role description
Role: Lead Teradata Developer
Location: Pleasanton, CA (Onsite)
Experience : 8+ Years
Visa : Any visa will work except H1B
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
Interested candidates can share your resume on saloni.dhawade@leanitcorp.com
Role: Lead Teradata Developer
Location: Pleasanton, CA (Onsite)
Experience : 8+ Years
Visa : Any visa will work except H1B
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
Interested candidates can share your resume on saloni.dhawade@leanitcorp.com
