Sr. Teradata Engineer

Requirements 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.