Strong hands on experience in Teradata 15 and above.
Excellent SQL and PL/SQL skills.
Knowledge of BI, Data Warehousing and Teradata architecture.
Experience in Data Migration projects- preferably from Oracle to Teradata.
Hands on experience in UNIX.
Experience in writing Teradata Procedure and Macros.
Experience with performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics.
Experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions and ETL data pipelines
Expertise in the Teradata cost-based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
Strong verbal, articulation, and analytical skills.
Exposure to onshore-offshore delivery model.
Identifying long-running queries, scripts, and tuning.
Requirements gathering.
Understanding various indexes and using appropriately in the queries
As a Teradata developer, responsible for maintaining all DBA functions (development, test, production) in operation 24×7.
Move databases between machines.
Installed patch sets and upgraded Teradata.
Work on creating and managing the partitions.
Create Schemas and Tables as per the business requirements.
Deliver new and complex high-quality solutions to clients in response to varying business requirements and create and manage user accounts in Teradata.
Install Teradata drivers for the Teradata utilities.
Loading data from various data sources and legacy systems into Teradata.
Acted as a liaison between the offshore and onsite teams.
Create and Modify databases, perform capacity planning, space allocation, and manage access rights for all objects within databases.
Performed database health checks and tune the databases using Teradata Manager.