POINTS TO KEEP IN PROJECT LEVEL (SSIS)

--PLEASE ADD LATEST JOB PROFILE RELATED RESPONSIBILITIES (WILDFIRE POINTS)-
       •    As an Associate I involved in getting documents, understanding, analysing documents, creating packages 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 packages and used configuration files.
•    Handled, reported errors in error tables and files.
        Using lookup ,derived, sort ,merge ,oledb command etc... transforms , various containers and tasks at control flow level.
•    Written SQL queries and delivered results as per the client requirement
•    Writing various queries (duplications, tops, aggregate operations etc...) as part of reconciliation and business logics Validation.
10.     Used Sql commands and queries to monitor ,reconciliate and manage packages.
•    Performance tuning of packages when necessary.
•    Adhoc and Unit testing for packages.