What are the responsibilities and job description for the Teradata Architect position at NuStar Technologies?
Must Have Technical/Functional Skills
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary Range: $110,000 - $120,000 a year
- 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)
- 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
- 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
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary Range: $110,000 - $120,000 a year
Salary : $110,000 - $120,000