Lead Teradata Engineer

We are seeking a highly skilled Teradata Engineer with strong expertise in database engineering, administration, and optimization. The ideal candidate will have hands -on experience in Teradata SQL, UNIX shell scripting, system performance tuning, and advanced database administration. This role requires working with cross -functional teams to deliver robust, secure, and scalable enterprise data solutions.

Key Responsibilities:

• Design, develop, and maintain Teradata data warehouse solutions aligned with business requirements.
  
• Write and optimize complex SQL queries involving joins, subqueries, and window functions.
  
• Identify and manage indexing strategies, partitioning, and statistics management to ensure query efficiency.
  
• Develop, automate, and maintain ETL workflows and scripts using Teradata utilities (BTEQ, FastLoad, MultiLoad, TPT, FastExport).
  
• Build and maintain UNIX shell scripts for automation, monitoring, and operational efficiency.
  
• Monitor and manage system workloads using TASM (Teradata Active System Management) and Teradata Viewpoint.
  
• Perform Teradata database administration activities including:
  • Backup and recovery management
    
  • Disaster Recovery (DR) setup and testing
    
  • User access control and security enforcement
    
  • System health monitoring and maintenance
    
• Troubleshoot performance issues, resolve system problems, and ensure high data quality.
  
• Collaborate with architects, analysts, and business teams to deliver scalable, secure, and reliable solutions.
  
• Mentor junior engineers and enforce best practices for Teradata engineering and administration.
  

Required Skills & Qualifications:

• Bachelor’s degree in Computer Science, Engineering, or related field.
  
• 3+ years of experience working with Teradata in enterprise -scale environments.
  
• Strong expertise in Teradata SQL with complex query design (joins, subqueries, window functions).
  
• Proficiency in UNIX shell scripting for automation and system operations.
  
• Hands -on experience in indexing, partitioning, and statistics management.
  
• Strong knowledge of Teradata utilities (BTEQ, FastLoad, MultiLoad, TPT, FastExport).
  
• Experience with TASM and Teradata Viewpoint for workload and system management.
  
• In -depth knowledge of database administration: backup, DR systems, user security, and access management.
  
• Solid understanding of data warehousing concepts and data modeling.
  
• Strong problem -solving, analytical, and communication skills.
  

Preferred Qualifications:

• Experience with Teradata Vantage platform.
  
• Familiarity with cloud -based data platforms (AWS, Azure, GCP).
  
• Exposure to BI/Reporting tools (Tableau, Power BI, MicroStrategy, etc.).
  
• Knowledge of Python or other scripting languages for automation.