IIB Data Power

Extensive Data Warehouse experience using Informatica PowerCenter v 8.6, 9.1, 9.5, 9.5.1, 9.6.X, 10.1.0, 10.2.0 HF 1 and 10.4. (Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Workflow Monitor, Source Analyzer, Transformations Designer, Warehouse Designer, Power- Exchange for Oracle, Power Connects for ERP) as ETL tool on Oracle, DB2 and SQL Server Databases. 7+ year of experience in managing the Metadata associated with the ETL processes used to populate the data warehouse of experience in analysis, designing, development, testing, debugging, documentation and maintenance of business Applications with four years of experience in Data Warehousing Informatica ETL (Power Center). Experience in upgrading the system from Informatica version 8.6.1 to version 9.1, 9.5, 9.5.1, 9.6.X, 10.1.0 ,10.2.0 HF 1 and 10.4. Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML files, Informix into the staging area. Data Modeling experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin. Performed some DBA Functionality by creating tables, constraints, granting permission, move data from one server to another etc. Communicated with DBAs, SAs, for major issue either via raising tickets or contacting them directly in emergency situations. Develop Architect design and Process flow across the End to End to data warehouse implementations. Experience in writing UNIX shell scripts and automated the entire processes using UNIX shell scripting. Experienced in overall data warehouse, database, ETL and OLAP tuning for better performance. Involved in identification of facts, measures, dimensions and hierarchies for OLAP models. Used Automation Tools like Autosys, Control M, Tivoli and UC4. Experience in data refreshes and data masking using Test Data Management (TDM). Bringing data from PROD to Non-Prod. Administrating the Denodo application. Very good experience with Active Batch which is a scheduler tool.