Teradata Admin/ Developer

8+ Years of experience with DWH design and implementation using Teradata Configure, manage, and troubleshoot Teradata database. Analyze and identify potential migration pain areas, and recommend solutions Perform activities like performance Tuning, Backup/Restoration & Space Management Technical/Functional Skills Expert in Teradata Solution Methodology for data warehouse implementation process Knowledge is assessing, monitoring and administrating all aspects of the Teradata environment relating to optimization and performance Expert in reading, understanding and interpreting Teradata Explain Plans. Experience on Teradata SQL Assistant, BTEQ, ETL tools Teradata Parallel Transporter, Fast Load, Multi Load, Tpump and Fast Export scripts. Experience with Unix and Autosys. Good to have ERSTUDIO and Teradata Studio experience. Experience with GoldenGate is a plus. Expertise in Teradata Joins, Indexes, Statistics, Stored procedures, Triggers, macros Capacity Planning, and Performance tuning. Experience in Oracle 11g Excellent interpersonal and communication skills, including strong listening skills Experience in working on large Data Warehousing environments Demonstrated competency in all phases of business intelligence and multi-terabyte data warehousing projects, from inception to production deployment. Experience writing complex SQL is strongly preferred Experience working in an agile environment is required SAP experience would be a plus