POINTS TO KEEP IN INDIVIDUAL PROJECT -TERADATA (SOMEPOINTS)

 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.