Teradata Architect

Tata Consultancy Services; Charlotte (NC); On-site; USD 110,000 - 120,000; Full time

Job summary

Tata Consultancy Services in Charlotte, North Carolina is seeking a Teradata Architect to lead the design and implementation of enterprise data warehouse solutions.

The ideal candidate will have strong expertise in Teradata tools, advanced SQL, and Python scripting, along with at least 5 years of experience in Teradata solutions. The position offers a competitive salary range of $110,000-$120,000 a year.

Qualifications

• Strong background in EDW concepts, dimensional modelling & performance tuning.
• Proficiency in Teradata tools & utilities.
• Hands on coding in Python or similar scripting languages.

Responsibilities

• Lead the design and architecture of enterprise data warehouse solutions using Teradata.
• Develop integration strategies and performance optimization techniques.
• Ensure compliance with enterprise architecture standards.
• Oversee ETL/ELT processes and data migration strategies.

Skills

Enterprise Data Warehouse (EDW)

Teradata tools & utilities (TPT, BTEQ, FASTLOAD, SASDI)

Advanced SQL

ETL tools (Informatica, SAS DI)

Python or similar scripting languages

5+ years of experience in Teradata solutions

Teradata certification

Job description

Job Description

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