--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.