Title: Teradata Architect
Location: Barrington, Rhode Island (Day 1 Onsite) or Remote
Contract : Long Term
Roles & 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.
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 with migrating Teradata workloads to cloud data platforms.
• Knowledge of Teradata security, capacity planning, and system monitoring using Viewpoint.