What are the responsibilities and job description for the W2 contract || Lead Teradata Developer position at Noblesoft Technologies?
Job Title: Lead Teradata Developer
Job Location: Pleasanton, CA (Onsite from day one)
Job Duration: 12 months
Minimum years of experience required: 12 years
Type of Hire: w2 contract
Job Details
Key Responsibilities-
Job Location: Pleasanton, CA (Onsite from day one)
Job Duration: 12 months
Minimum years of experience required: 12 years
Type of Hire: w2 contract
Job Details
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.
- 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