Data Warehouse / Teradata Architect (Lansing)

Part-time

System Soft

Lansing, MI

Data Warehouse / Teradata Architect

Lansing, MI

Hybrid

12-15+ Months Contract

Virtual Interview via MS Teams video

Required Experience:

10+ years of experience into Teradata, ETL
Strong experience in Teradata SQL, joins, indexes, and explain plans.
Hands-on experience with Teradata utilities (FastLoad, MultiLoad, TPT, BTEQ).
ETL/ELT processes and data migration strategies
Knowledge of ETL tools (Informatica, DataStage, or similar).
Familiarity with data warehousing concepts and BI tools.
Proficiency in performance tuning and query optimisation.
Good understanding of Unix/Linux scripting.
Excellent problem-solving and communication skills.
Proficiency in Teradata tools and utilities TPT BTEQ FastLoad MultiLoad
Experience Teradata database, Teradata backup & recovery
Performance tuning and resource optimization
Experience with upgrades, provisioning, software maintenance, scripting – BASH, Perl, Python, Glink
Hands on with Teradata ecosystem health monitoring, Teradata node management, Teradata Viewpoint administration, PSIM (Platform Service Intelligent Monitoring) administration, Teradata vendor upgrades, Teradata workload management, Unix/Linux knowledge, Cloud computing fundamentals, resource allocation, networking, preferably MS Azure

Responsibilities:

Lead the design and architecture of enterprise data warehouse solutions using Teradata
Design and develop complex SQL queries, stored procedures, and macros in Teradata.
Implement ETL workflows using tools like Informatica, BTEQ, or Teradata utilities (FastLoad, MultiLoad, TPT).
Optimise queries and manage performance tuning for large-scale data environments.
Collaborate with data architects and business analysts to translate requirements into technical solutions.
Perform data validation, troubleshooting, and issue resolution.
Develop reusable Python scripts for automation data transformation and validation

Apply

Vacancy posted 17 hours ago

Similar jobs that could be interesting for youBased on the Data Warehouse / Teradata Architect (Lansing) in Lansing, MI vacancy

Data Warehouse Architect (Lansing)
...Job Title- Data Warehouse Architect 3 Only Michigan Based Candidates Job Responsibilities: Responsible for complex Common Batch Framework... ...user access to the groups and sudos) Responsibility for Teradata security and access. Conduct data architecture reviews and...
Suggested
Full time
For contractors
Immediate start
RICEFW Technologies Inc
Lansing, MI
17 hours ago
Data Warehouse Architect
...Description Job Description Job Description Job Title: Data Warehouse Architect 3 Job Location: Lansing, MI (Hybrid) Job Type: Contract Job... ...warehouse environments and ETL processes. Work with Teradata data warehouse systems, security, access, and data...
Suggested
Contract work
Global Information Technology
Lansing, MI
7 days ago
Data Warehouse Architect 5
...Data Warehouse Architect 5Location: Lansing MI (Hybrid) (Local Only)Position Type: Contract C2CClient: STATE OF MICHIGANGeneral Summary:DHHS is the agency... ...DTMB developers to better understand how to use the Teradata and BI development tools to create and implement reporting...
Suggested
Permanent employment
Contract work
For contractors
Local area
Argyle Infotech
Lansing, MI
3 days ago
Data Warehouse Architect 5
...Data Warehouse Architect 5Job Location: Lansing, MI (Hybrid)ContractJob Description/Requirement:Minimum 12 years Teradata experience.Minimum 10 years SQL experience.Minimum 10 years shell scripting experience.Minimum 5 years Linux experience.Supporting the loading of data...
Suggested
Global Information Technology
Lansing, MI
3 days ago
Data Warehouse Architect 5
...access to the groups and sudosResponsible for Teradata security and accessResponsible for... ...Scheduler to ensure current and reliable data is available for critical business processes... ...and decision makingResponsible for Data Warehouse change management infrastructure and all...
Suggested
Samprasoft
Lansing, MI
3 days ago
Data Warehouse Architect
...Job Description Job Title- Data Warehouse Architect 3 \n Only Michigan Based Candidates \n Job Responsibilities: \n \n Responsible... ...user access to the groups and sudos)\n Responsibility for Teradata security and access. \n Conduct data architecture...
For contractors
Immediate start
RICEFW Technologies Inc
Lansing, MI
16 days ago
Data Architect II
...Competitive salary Opportunity for advancement Job Title: Data Architect II / Senior Enterprise Data Architect Location: Auburn... ...data architecture, Master Data Management (MDM), Data Warehouse (DW), reporting, and analytics solutions. Required Skills...
Contract work
Select Minds LLC
Lansing, MI
7 days ago
Senior Lead Data Governance Architect
$132.23k - $175.31k
...the AI‑powered world, connecting people, data, and applications through our expansive... ...technically adept Senior Lead Data Governance Architect to lead delivery of its data governance... ...(for example, the enterprise data warehouse, Databricks, and Palantir Foundry), with...
Full time
Temporary work
Work at office
Remote work
Lumen
Lansing, MI
1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Warehouse / Teradata Architect (Lansing). Be the first to apply!