Teradata Developer/ETL Consultant

Teradata Developer/ETL Consultant

Posted Today by 1766130348

Negotiable
Outside
Remote
USA

Summary: The Teradata Developer role involves designing, developing, and optimizing data solutions on the Teradata platform. Candidates should possess strong SQL skills, experience with ETL processes, and a solid understanding of Teradata architecture and performance tuning. The position emphasizes collaboration with data architects and business analysts to create effective technical solutions. The role is remote and classified as outside IR35.

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.

Key Skills:

  • 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.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Teradata Developer to design, develop, and optimize data solutions on the Teradata platform. The ideal candidate will have strong SQL expertise, experience in ETL processes, and a deep understanding of Teradata architecture and performance tuning.

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.

Preferred Skills:

  • Experience with Teradata Vantage and advanced analytics.