Monday 13 April 2015

TERADATA DEVELOPER RESPONSIBILITIES TO KEEP IN RESUME (FEW)

-- FOR MORE EXPLANATION TALK TO VINAY SIR ------------------------

1.Analyze and discuss the adaptations (client requirement) prepared by the functional team. Clarifications and conclusions follow.

2.Work on various Business and Technical documents (Business Map, Business Change , Unit Testcase ,High level etc...)

3.Focused on Truncate & Load ,Incremental (includes SCD) and Change Data Capture Loading by using various scripts.

4.Experienced in writing Bulk load Uscripts by using Fastload and Multiload

5.Written BTEQ scripts for normal table-table loading other generic operations such as error handling ,branching etc...

6.Experienced in writing queries by using SQL commands, keywords, functions, Sub Queries and  joins

7.Participated in otimization process by identifying bottlenecks at query and script level.

8.Used Explain request modifier for trouble shooting and performance improvements (Join ,Hash Indexes, Join Strategies, Skewness)

9.Managed various tables in Teradata (error, derived, volatile etc...) , implemented restartable and rollback  methods.

9.Reviewed & Tested scripts, fixing bugs (if any) using teradata SQL Assistant and BTEQ.

10.Used Unix commands to run ,monitor ,reconciliate and manage scripts.

11. Do Unit & integration testing of the application.


12.Maintained versioning in Version Tools such as PVCS, TFS ,Sharepoint Server etc...

13.Acquired good knowledge on Data Warehousing and Data Model Fundamentals.

14.Attended trainings on Teradata 14 version.
------------------------------------------------------------------------

3 comments: