Back to Jobs
Recently postedTechnology

Teradata Architect (Data Warehousing)

J-RAM IT Consulting Inc.United States🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationUnited States
SQLShellAWSETLSnowflakeCapacity PlanningDatabricksGoogle CloudAzureLinux

Job description

Job Title:     Teradata Architect (Data Warehousing)
Location:     Remote
Primary skills: Teradata Architecture, Enterprise Data Warehousing, Data Modeling, Teradata SQL, Performance Tuning
skills: Teradata Vantage, BTEQ, TPT, Informatica / DataStage, Unix/Linux Shell Scripting, AWS, Azure, Google Cloud Platform, Snowflake / Databricks Migration
Experience: 12+ Years of Experience in Data Engineering, Data Modeling/Data Warehousing and 8+ years in Teradata.
About the job:
We are seeking a highly skilled Architect with deep expertise in Teradata Data Warehousing and Data Modeling. The successful candidate will own the architecture, design, and performance of Teradata-based enterprise data platforms, and guide teams on modernization and migration to cloud data platforms where required.
Responsibilities
  • Define and own the architecture of Teradata enterprise data warehouses, including logical and physical data models, layered data architecture, and integration patterns.
  • Lead performance tuning and optimization, including Primary Index and Partitioned Primary Index (PPI) design, join indexes, statistics collection, and query optimization.
  • Design and govern ETL/ELT frameworks using BTEQ, TPT, FastLoad, MultiLoad, and tools such as Informatica or DataStage.
  • Manage workload management, capacity planning, space management, security, and role-based access on Teradata systems.
  • Assess existing Teradata workloads and define modernization and migration strategies to cloud platforms such as Snowflake, Databricks, and Teradata Vantage on cloud.
  • Establish development standards, code reviews, and best practices, and mentor Teradata developers.
  • Collaborate with business and technology stakeholders to translate requirements into scalable data solutions.
Requirements - Must Have
  • 12+ years of experience in Data Modeling/Data Warehousing.
  • 8+ years of experience in Teradata architecture and design, including PI/PPI design, indexing strategies, and workload management.
  • Expert in Teradata SQL, query tuning, and Teradata utilities (BTEQ, TPT, FastLoad, MultiLoad, FastExport).
  • Hands-on experience with ETL/ELT tools such as Informatica or DataStage, and Unix/Linux shell scripting.
  • Experience with cloud platforms like AWS, Azure, and Google Cloud Platform, and migrating Teradata workloads to cloud data platforms.
  • Knowledge of Teradata security, capacity planning, and system monitoring using Viewpoint.

Similar jobs