Teradata Architect

Teradata Architect

Must Have Technical/Functional Skills


Strong Background in Enterprise Data Warehouse (EDW) concepts, dimensional modelling & performance tuning


Proficiency in Teradata tools & utilities TPT,BTEQ,FASTLOAD,SASDI


Advanced SQL skills and Experience with ETL tools (Informatica, SAS DI)


Familiarity with Teradata Vantage features like QueryGrid, NOS, and clearScape Analytics


Hands on coding in Python or similar Scripting Languages


5+ Years of Experience in Teradata Solutions


Teradata certified Professional (preferred)

Roles & Responsibilities


Solution Design & Architecture


- Lead the design and architecture of enterprise data Wearhouse solution using Teradata


- Develop integration strategies and performance optimization technique


- Ensure solutions to comply with enterprise architecture standards and best practices


- Develop reusable python scripts for automation, data transformation and validation


Platform Startegy & governance


- Evaluate Teradata platform features and create technology roadmaps


- Establish platform standards , integration patterns and governance frameworks


- Pefrorm POC for new capabilities and onboard pilot projects


Technical leadership


- Provide guidance on Terada utilities


- Collaborate with cross functional teams


- Optimize queries, indexing and workload management for high performance


Data Management


- Oversee ETL/ELT Processes and data migration strategies


- Ensure Data quality , security and compliance with regulatory requirements


- Implement best practices for data lifecycle management and metadata governance

Salary Range- $110,000-$120,000 a year