Teradata Developer

Responsibilities:

• Lead data engineering strategy across projects. Drive innovation in practices and optimization. Represent team in executive meetings. Develop long-term data plans.
• Hands on experience in Teradata development and proficient with BTEQ scripts, ability to understand complex logic-based SQLs, joins & Procedures.
• Must know Teradata Utilities Mload, FastLoad, TPUMP, FastExport, BTQMAIN, TPT Wrappers.
• Should have in-depth understanding of Teradata architecture & concepts - PE, Bynet, Vdisks, AMPs, Vprocs, Indexing, Hashing, Data Distribution/Duplication.
• Ability to choose the correct Indexes for a Database - NUPI, UPI, NUSI, USI to support Load and Extract Data operations to achieve optimal performance for storage and access to the Database.
• Experience in understanding Spool Space, Amp Skewness, Hot AMP issues and providing solutions to overcome it.
• Should be able to work with TDBA/Teradata Admin to understand solutions provided & transform it to technical/application level to implement the same to improve SQL performance.
• -Hands on experience in using performance tuning techniques - Collect Stats, usage of Partitioned Primary Index, Join Indexes, use of Secondary Indexes, avoiding FTS/all AMPs access operation.
• Expert in optimizing I/O & Storage Performance thru MVC/ALC/BLC.
• Responsible for implementation and ongoing administration of Teradata infrastructure Solutions.

Key Responsibilities:

• Design, develop, and maintain enterprise-scale data warehouse solutions using Teradata.
• Develop complex SQL queries, stored procedures, macros, views, and scripts to support business requirements.
• Perform Teradata database design, physical and logical data modelling.
• Create and optimize ETL/ELT processes for data extraction, transformation, and loading.
• Analyse source systems and perform data mapping, data profiling, and data validation activities.
• Monitor and optimize query performance, workload management, and database utilization.
• Work with business analysts, architects, and stakeholders to understand reporting and analytics requirements.
• Support Teradata database upgrades, migrations, and modernization initiatives.
• Implement data quality, data governance, and security best practices.
• Troubleshoot production issues and provide timely resolution.
• Participate in code reviews and ensure adherence to development standards.
• Develop and maintain technical documentation and data lineage documentation.
• Collaborate with cross-functional teams in Agile/Scrum environments.
• Execute test scripts against the modified scripts under supervision. You understand the role of testing and how it works.
• Deploy the refined solutions to the Prod after Testing & UAT/BAT.

Eligibility:

• Bachelor's degree with a minimum of 5-8 years of IT experience
• Hands on experience in Teradata development and proficient with BTEQ scripts along with Database Tuning experience.
• Strong database concepts.
• Excellent communication skills.
• Solution orientation and problem-solving skills.
• Strong analytical ability.
• Strong teamwork and interpersonal skills.