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 Strategy & governance

- Evaluate Teradata platform features and create technology roadmaps

- Establish platform standards , integration patterns and governance frameworks

- Perform 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