The company is seeking to optimize data extracts and queries, manage overall system performance, and ensure the stability of the Teradata environment during a complex migration to a Databricks environment.
Requirements
- 5+ years’ hands-on experience in a production Teradata environment
- Strong command of Teradata SQL and Analytics functions
- Deep knowledge of Teradata utilities: FastLoad, MultiLoad, MLoad, TPump, BTEQ, and TPT
- User/security management, space management, backup/recovery, and system maintenance
- Familiarity with Unix/Linux shell scripting and basic system administration
- Proficiency with at least one enterprise ETL tool (Databricks, Informatica, IBM DataStage, SSIS, Talend etc.)
- Teradata Certified Professional (e.g., Teradata Certified Database Administrator)
Responsibilities
- Analyze and tune complex SQL queries for optimal response times
- Monitor system health and workload management (TASM, Resource Classes)
- Design, develop, and maintain load/unload processes using FastLoad, MultiLoad, MLoad, TPump, and BTEQ
- Build and manage Teradata Parallel Transporter (TPT) scripts for high-volume data movement
- Collaborate with ETL developers to design efficient data pipelines (DataBricks, DataStage, SSIS, Talend or equivalent)
- Troubleshoot and optimize ETL workflows for large-scale data loads
- Investigate and resolve conversion related incidents, service disruptions, and critical production issues
Other
- Excellent problem-solving and troubleshooting abilities
- Strong communication skills, able to explain technical issues to non-technical stakeholders
- Team player with a proactive, service-oriented mindset
