• EDD and developed ETL technical specifications
• Designed the ETL mappings to load data into Marketing and Sales data Mart
• Developed mappings, mapplets in the PowerCenter Designer.
• Coordinated with the Business Analyst to sign off the ETL requirements
• Used Informatica PowerCenter Transformations like Expression, Lookup, Aggregator, router, update strategy.
• Developed test scenarios and test cases to test the Data Mart load by going through the External Design Document (EDD) and Internal Design Documents (IDD
• Reviewed and executed Test Plans against the Developed mappings
• Developed test cases based on use cases
• Supported pre production of Data Warehouse load
• Created Telesales Representatives (TSR) and other administrative users id through Organization
Administration Console (OAC) and assign roles for the user ids and test the ids are picking all the roles
• Managing user access for users to the web portals by using Slingshot portaler – User Access Control Center.
• Adding a new Store to a particular portal by using Portal Control Center (PCC – Slingshot)
• Functional verification testing of the Common Commerce Engine Versions. 5.2, 5.3, and 6.0 Web
Application and Tools for www.ibm.com
• Functional verification testing of Multichannel Sales Center (MSC), a Graphical User Interface (GUI) for
Telesales Representatives (TSR) and other administrative users who have a need to perform order entry
and order management.