Teradata Architect

Remote • Posted 1 hour ago • Updated 1 hour ago
Contract Corp To Corp
Contract Independent
Contract W2
12 Months
No Travel Required
Remote
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • ETL

Summary

Teradata Architect
Location: Barrington, RI or Remote
Duration: Long Term


Visa:
or EAD's 

Skills:
12+ years of experience in Data Modeling/Data Warehousing.
8+ years of experience in Teradata architecture and design, including PI/PPI design, indexing strategies, and workload management.
Expert in Teradata SQL, query tuning, and Teradata utilities (BTEQ, TPT, FastLoad, MultiLoad, FastExport).
Hands-on experience with ETL/ELT tools such as Informatica or DataStage, and Unix/Linux shell scripting.
Experience with cloud platforms like AWS, Azure, and Google Cloud Platform, and with migrating Teradata workloads to cloud data platforms.
Knowledge of Teradata security, capacity planning, and system monitoring using Viewpoint.

Responsibilities:
Define and own the architecture of Teradata enterprise data warehouses, including logical and physical data models, layered data architecture, and integration patterns.
Lead performance tuning and optimization, including Primary Index and Partitioned Primary Index (PPI) design, join indexes, statistics collection, and query optimization.
Design and govern ETL/ELT frameworks using BTEQ, TPT, FastLoad, MultiLoad, and tools such as Informatica or DataStage.
Manage workload management, capacity planning, space management, security, and role-based access on Teradata systems.
Assess existing Teradata workloads and define modernization and migration strategies to cloud platforms such as Snowflake, Databricks, and Teradata Vantage on cloud.
Establish development standards, code reviews, and best practices, and mentor Teradata developers.
Collaborate with business and technology stakeholders to translate requirements into scalable data solutions.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91162571
  • Position Id: 9142576
  • Posted 1 hour ago

Company Info

About TekDallas

TekDallas offers outsourced product development, managed services solutions and business process management to organizations seeking higher operational effectiveness, greater flexibility, and cost savings.

We help create a virtual extension of our clients’ enterprise with an operational framework which is simple, flexible and resilient.

TekDallas enables its clients to extend current capabilities and build value-added services by providing global access to resources and diverse skill sets, including best practices in multiple processes and technology domains. Our services are designed to aid businesses improve their operational efficiencies, performance and reduce costs.

About_Company_OneAbout_Company_Two
Contact the job poster
PR

Prashanth Reddy

Recruiter @ TekDallas

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.