TERADATA_PROFESSIONAL_SUMMARY/TERADATA DEVELOPER RESPONSIBILITIES (SOMEPOINTS)

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.

------------------------------------------------------------------------

IMPORTANT POINTS TO KEEP IN PROJECTS (FEW POINTS)

 As an Associate I involved in getting documents, understanding, analysing documents, writing scripts (BTEQ,FL,ML) and queries according to those.

•    In case of changes we follow CR document procedure of the client

•    Different types of Data Loading (Direct, Incremental, SCD Type2  et...) implemented   

      using scripts and used configuration files.

•    Handled, reported errors in error tables.

•    Written SQL queries and delivered results as per the client requirement

•    Observed the Execution plan ,monitored statistics ,Join strategies and various types    

     of  indexes.

•    Writing various queries (duplications, tops, aggregate operations etc...) as part of      

      reconciliation and business logics Validation.

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

•    Performance tuning of scripts when necessary.

•    Adhoc and Unit testing for scripts and queries.