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