- 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 :

1. Backup and recovery management

2. Disaster Recovery (DR) setup and testing

3. User access control and security enforcement

4. 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 :

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