Teradata Engineer
Role summary
Seeking an experienced Senior Teradata Engineer with 8-12 years of experience in Teradata SQL, BTEQ, and ETL utilities (FastLoad, MultiLoad). This hybrid role requires deep expertise in optimizing enterprise data warehouse solutions, legacy refactoring, performance tuning, schema migration, and driving cloud migration initiatives, preferably to GCP. The candidate will lead development, architect ETL processes, ensure data quality, and troubleshoot production issues. This position also involves mentoring junior engineers and driving technical excellence, blending hands-on technical skills with leadership capabilities to modernize systems and deliver high-performance data solutions.
Role- Teradata Engineer
Location--Basking Ridge NJ Hybrid
Exp- 8-12 Year
About the 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 GCP).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 GCP – 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