Description

You will develop and optimize data warehouse solutions using Teradata architecture and utilities.

Responsibilities

• Write and optimize complex SQL queries using Primary, Secondary, Partition, and Join indexes.
• Execute Teradata utilities including BTEQ, MLOAD, FASTLOAD, FASTEXPORT, and TPUMP.
• Manage data movement using the Teradata Parallel Transporter.
• Perform performance tuning on complex queries to improve efficiency.
• Run Teradata utility scripts across both Unix and Mainframe environments.

Required Skills

• 5+ years of experience in Teradata development.
• Deep understanding of Teradata Architecture and data warehouse concepts.
• Expertise in Basic and Advanced Teradata SQL.
• Proficiency with Teradata utilities: BTEQ, MLOAD, FASTLOAD, FASTEXPORT, and TPUMP.
• Experience with Teradata Parallel Transporter.
• Hands-on experience handling Geospatial Data Types, XML, JSON, and Array data types.
• Ability to work in Unix and Mainframe environments.

Preferred Skills

• Experience with Teradata Vantage analytical features such as Path and SentimentExtracter.

Key Skills

Education

Any Graduate