Job Description :
Teradata Developer ,

Plano, TX (Long term Contract )

Responsibilities :

Teradata Developer with excellent skill in development and maintenance of SQL applications.

Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc

Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.

Good in UNIX programming to enable job execution and scheduling.

Automated data warehousing and datamart refreshes using Transportable table space option.

Worked on creating and managing the partitions.

Performed database health checks and tuned the databases using Teradata Viewpoint.

Refreshed the data by using fastexport and fastload utilities.

Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.

With the in-depth 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 (PI and USI and NUSI and JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.