3 - 7 years

Hyderabad All india

Posted:8 months ago

Apply

Job Description

You will be responsible for designing, developing, and maintaining high-performance Teradata SQL queries, views, macros, and stored procedures to support reporting and analytics. Additionally, you will be building and operating ETL/ELT workflows using Teradata utilities such as TPT, FastLoad, MultiLoad, TPump, and BTEQ to load and transform large datasets reliably. Your role will involve performing query plan analysis and implementing query performance tuning, indexing, and partitioning strategies to meet SLAs. In case of production incidents, you will troubleshoot, perform root-cause analysis, and implement corrective actions to enhance data pipeline stability. Collaboration with data architects, BI developers, and stakeholders will be essential to translate business requirements into scalable data models and pipelines. Lastly, you will be expected to author technical documentation, unit tests, and provide assistance in release management, data validation, and deployment activities. **Qualifications Required:** - Proficiency in Teradata SQL, BTEQ, FastLoad, MultiLoad, TPump. - Experience in performing query performance tuning, indexing, and partitioning. - Strong problem-solving skills with the ability to troubleshoot production incidents effectively. In this role, you will utilize your skills in Teradata SQL, BTEQ, FastLoad, MultiLoad, and TPump to design, develop, and maintain high-performance Teradata SQL queries, views, macros, and stored procedures. Your expertise will be crucial in building and operating ETL/ELT workflows using Teradata utilities to load and transform large datasets reliably. You will also be responsible for query performance tuning, indexing, and partitioning to ensure SLAs are met. Additionally, troubleshooting production incidents, collaborating with various teams, and authoring technical documentation will be part of your responsibilities. You will be responsible for designing, developing, and maintaining high-performance Teradata SQL queries, views, macros, and stored procedures to support reporting and analytics. Additionally, you will be building and operating ETL/ELT workflows using Teradata utilities such as TPT, FastLoad, MultiLoad, TPump, and BTEQ to load and transform large datasets reliably. Your role will involve performing query plan analysis and implementing query performance tuning, indexing, and partitioning strategies to meet SLAs. In case of production incidents, you will troubleshoot, perform root-cause analysis, and implement corrective actions to enhance data pipeline stability. Collaboration with data architects, BI developers, and stakeholders will be essential to translate business requirements into scalable data models and pipelines. Lastly, you will be expected to author technical documentation, unit tests, and provide assistance in release management, data validation, and deployment activities. **Qualifications Required:** - Proficiency in Teradata SQL, BTEQ, FastLoad, MultiLoad, TPump. - Experience in performing query performance tuning, indexing, and partitioning. - Strong problem-solving skills with the ability to troubleshoot production incidents effectively. In this role, you will utilize your skills in Teradata SQL, BTEQ, FastLoad, MultiLoad, and TPump to design, develop, and maintain high-performance Teradata SQL queries, views, macros, and stored procedures. Your expertise will be crucial in building and operating ETL/ELT workflows using Teradata utilities to load and transform large datasets reliably. You will also be responsible for query performance tuning, indexing, and partitioning to ensure SLAs are met. Additionally, troubleshooting production incidents, collaborating with various teams, and authoring technical documentation will be part of your responsibilities.

Skills Required

multiload fastload tpump teradata sql bteq sql

Work Mode

On-site

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now
coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You