ETL lead
TCS
Total years of experience :16 years, 6 Months
Informatica 9.1, Oracle, Netezza
Performed impact analysis for systems.
Requirement gathering and interaction with external users.
Design project and logical model.
Interaction with application users for administration of applications.
Lead Rapid response team.
Developed improvement and problem solving strategies Coached and followed-up with the ETL developers and testers.
Using ETL process to Extract, Transform and Load the data into stage area and data warehouse.
Mentoring junior members in data Extraction and loading process of ETL.
Business requirement gathering and analysis with Business users.
Query tuning and involved in solving performance issues.
Support various Informatica application as L3 support.Direct interaction with users on data and project related issues.
Impact analysis on systems and application.
Informatica 7.1, Oracle 10g.
Project summary :
The WIZ Systems project caters to Personal Systems Group (PSG) HP customers in the EMEA (Europe, Middle East and Africa) region. It tracks the service/repair information of various HP products from the EMEA region. Servicing of products is done by partners of HP, namely, Anovo, Compal, Comserve, Infocare, etc. to name a few. These partners send information of every month transactions in the form of flat files. Data loading is done with informatica jobs.
Roles and Responsibilities:
•Monitoring application load events.
•Worked on Code migration using Repository Manager.
•Involved in new application setup and administration of existing applications
•Application support and worked on user issues
•Worked on repository user, group creation and privileges using Workflow Manager and admin console.
•Used admin console for creation of application services and setting up privileges and admin activities.
•Creation of users, services, setting permissions
•Interaction with application users for administration of applications.
•Testing of mapping and application.
•Interaction with application users for administration of applications
Informatica 7.1, Oracle 9i, BO 6.5, Windows NT
from