TERADATA & INFORMATICA RESPONSIBILITIES TO KEEP IN RESUME (FEW)

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

Having total 3+ years of IT experience in Datawarehousing and Business Intelligence stream where more than 3 years worked on Informatica and  around 1 year of experience in Teradata as Datawarehose.

    Hands on knowledge on various databases (Oracle,Sqlserver etc...) and Files (Flat file,CSV file etc...)

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 mappings and scripts.

4.   Experienced in creating Bulk load mappings and writing bulk load scripts such as Fastload and 

      Multiload.

    Used various Transforms (Lookup, Expression, Router, Filter, UPD etc...) and  

    Tasks(Command,Session,Decision etc...) to implement business logics and flow.

    Participated in construction and usage of Mapplets, Reusable transforms and worklets.

    Implemented Pushdown Optimization and Session recovery.

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 mapping ,session , workflow and query 

       level.

      Used configuration or Parameter files to work with configuration  settings (mapping/session parameters) 

        in   Informatica and Teradata.

9.    Reviewed & Tested scripts, fixing bugs (if any) using Queries at database level and commands at OS 

       level..

10.  Used Unix commands to run ,monitor ,reconciliate and manage mappings and 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 Informatica and Teradata latest versions(corporate mandatory tranings).