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 Packages.
4. Experienced in creating simple, medium and complex packages by using normal and Fast load options
5. Working with Loop containers to continually repeat operations,Seqence container for transactional operations.
6. Extensively worked on Data Flow task various sources,transforms(Derived,Lookup,Conditional Split,Sort,Merge ectc...) and destinations.
6. Used Execute SQL task,Script task and Execute Package task when required.
7. Implementing error handling ,branching,check point operation ,configurations and parameterization.
8. Created simple ,Medium and complex reports based on Business Report Design documents.
9. Using variables,parameters and various expressions to implement business logics.
10. Using various visualizations such as Table,Matrix,Chart,List ,Indicator etc...
11. Creating Drill Down , Drill through and Parameterized reports
8. Participated in the bottlenecks elimination of various packages ,reports and implemented tuning standards.
6. Experienced in writing queries by using SQL commands, keywords, functions, Sub Queries and joins ,procedures etc...
9. Reviewed & Tested packages and reports (Unit test ,Report test and Reconciliation).
11. Maintained versioning in Version Tools such as TFS ,Sharepoint Server etc...
12. Acquired good knowledge on Data Warehousing and Data Model Fundamentals.
13. Attended trainings on MSBI2014 version.