Senior Teradata Engineer
Location--Basking Ridge NJ
Role
We are seeking an experienced Senior Teradata Engineer with deep expertise in Teradata SQL, BTEQ, and ETL utilities (FastLoad, MultiLoad) to lead and optimize enterprise data warehouse solutions. The ideal candidate will have strong experience in legacy refactoring, performance tuning, schema migration, and driving cloud migration initiatives (preferably to Google Cloud Platform).This role requires both hands-on technical expertise and leadership capabilities to modernize legacy systems and deliver scalable, high-performance data solutions.
Role and responsibilities
Design, develop, and optimize Teradata-based data warehouse solutions
Lead development of complex Teradata SQL queries, stored procedures, and macros
Architect and manage ETL processes using BTEQ, FastLoad, MultiLoad (MLoad), and TPump
Drive performance tuning and optimization (query plans, indexing, partitioning, workload management)
Define and execute schema migration strategies for large-scale data transformation
Drive Teradata to cloud migration programs (preferably Google Cloud Platform BigQuery)
Ensure data quality, reconciliation, and validation frameworks
Troubleshoot and resolve complex production issues and performance bottlenecks
Collaborate with data architects, business teams, and cross-functional stakeholders
Implement best practices for code standardization, version control, and deployment
Mentor junior engineers and drive technical excellence within the team