Lead Teradata Developer

DMS Vision • Frisco, TX

7h • Onsite

About The Position

The Lead Teradata Developer will design and develop complex SQL queries, stored procedures, and macros in Teradata; implement ETL workflows; and optimize query performance in large-scale data environments. The role collaborates with data architects and business analysts to turn requirements into technical solutions, performs data validation and troubleshooting, and helps ensure compliance with data governance and security standards.

This is an onsite position in Pleasanton, California. The job posting describes it as a 6+ month contract, W2 only, and says relocation is available. It calls for 12+ years of professional experience with leadership capabilities and hands-on coding expertise.

Requirements

• 12+ years of professional experience.
• Proven leadership capabilities and hands-on coding expertise.
• Strong experience with Teradata SQL, joins, indexes, and explain plans.
• Hands-on experience with Teradata utilities, including FastLoad, MultiLoad, TPT, and BTEQ.
• Knowledge of ETL tools such as 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.

Responsibilities

• Design and develop complex Teradata SQL queries, stored procedures, and macros.
• Implement ETL workflows using tools such as Informatica, BTEQ, and Teradata utilities.
• 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, troubleshoot issues, and resolve them.
• Ensure compliance with data governance and security standards.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed