Job Title: Teradata Lead / Architect

Experience: 8–15 Years

Location: Pune, Bengaluru, Hyderabad, Kolkata, Mumbai, Noida and Chennai Job Summary

We are seeking an experienced Teradata Lead / Architect to design, develop, optimize, and support enterprise-scale data warehouse solutions. The ideal candidate should possess strong expertise in Teradata technologies, data warehousing concepts, ETL processes, and performance tuning, along with experience in contemporary cloud and big data platforms. The role involves leading technical initiatives, defining architecture, mentoring teams, and collaborating with business stakeholders to deliver scalable and high-performing data solutions.

Key Responsibilities

Design, develop, and maintain enterprise data warehouse solutions using Teradata.

Lead architecture discussions and recommend scalable, high-performance data solutions.

Develop and optimize complex SQL queries, stored procedures, and database objects.

Design and implement ETL/ELT processes using Teradata utilities.

Perform performance tuning, workload optimization, and query optimization.

Work with large-scale data migration, integration, and modernization initiatives.

Collaborate with business analysts, developers, architects, and stakeholders to gather requirements and translate them into technical solutions.

Ensure data quality, integrity, security, and governance across data platforms.

Monitor and troubleshoot production issues while ensuring system availability and performance.

Mentor team members and provide technical guidance on Teradata best practices.

Support cloud migration initiatives involving AWS, Azure, Snowflake, or hybrid data platforms.





Prepare technical documentation, solution designs, and architecture artifacts.

Required Skills

Strong experience with Teradata Database.

Expertise in SQL and database programming.

Hands-on experience with BTEQ, FastLoad, MultiLoad, TPT, and other Teradata utilities.

Strong knowledge of Teradata Viewpoint and workload management.

Experience in Performance Tuning and query optimization.

Good understanding of Data Warehousing concepts and dimensional data modeling.

Experience in designing and developing ETL/ELT solutions.

Knowledge of Linux/Unix environments and Shell Scripting.

Hands-on experience with Python for automation and data processing.

Experience working with Hadoop ecosystems.

Exposure to Snowflake and cloud platforms such as AWS or Microsoft Azure.

Strong analytical, problem-solving, and troubleshooting skills.

Excellent communication and stakeholder management abilities.

Preferred Skills

Experience with cloud-based data warehouse modernization projects.

Knowledge of CI/CD, DevOps, and automation practices.

Familiarity with Agile/Scrum methodologies.

Experience leading technical teams and mentoring developers.

Exposure to enterprise data governance and security practices.

Qualifications

Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field.

Key Competencies

Teradata Architecture & Design

Data Warehousing

ETL/ELT Development

SQL Development & Optimization

Performance Tuning

Data Modeling

Cloud Data Platforms

Technical Leadership

Solution Architecture

Stakeholder Management

Problem Solving

Team Mentoring

📌 Teradata Architect (India)
🏢 LTIMindtree
📍 India