What are the responsibilities and job description for the Teradata Architect position at Q1 Technologies, Inc.?
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 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