Hi Partners,
For Detailed resume and contact details Please send Open Informatica positions to sai@netprologic.com.
Name : MB
Location : WI
Re-Location : Near by Locations
Availability : Immediate
*Summary :*
– IT Professional with 6 years of experience in gathering Business Requirements, GAP Analysis, Data Modeling Design, Data Analysis, Development and Implementation of various functionalities of Data Warehouse / Data Marts, using OLAP & ETL tools like Informatica PowerCenter, Oracle9i/8i, SQL and PL/SQL – Data warehousing experience using Informatica Power Center/Power Mart (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager, and Workflow Manager/Server Manager) – Extensive experience in database design for Data Warehouses with strong understanding of Dimensional Modeling, Star and Snowflake Schemas, Identification of fact and dimension tables, Normalization – Worked with different data sources non-relational Databases* *such as* *Flat files, XML files, and other relational sources* *such as Oracle, SQL Server – Extensive experience in developing Informatica Mappings / Mapplets using various Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup and Aggregator) for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & Tasks and scheduling using Workflow Manager – Worked extensively with Data migration, Data Cleansing, Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
· Instrumental in setting up standard ETL Naming standards & BEST Practices throughout the ETL process (Transformations, sessions, maps, workflow names, log files, bad files, input, variable, output ports)
· Worked with different Informatica performance tuning issues like source, target, mapping, transformation, session optimization issues and fine-tuned Transformations to make them more efficient in terms of session performance
· Developed a number of Complex Mappings and Reusable Transformations
– Experience in implementing the complex business rules by creating re-usable transformations, developing complex Mapplets and Mappings, PL/SQL Stored Procedure and Triggers – Expertise in providing end-to-end business intelligence solution by configuring metadata & building Analytics Repository, Business Models, dimensional modeling design, generating reports and creating Inter-active Business Intelligence Dashboards using OBIEE/Siebel Analytics.
· Experience with UML using tools like Microsoft Visio
– Involved in merging applications from Dev – Test – Prod for deployment
· Experience with Databases like Oracle 9i/10g, SQL Server 2000/2005 , MS Access
· Extensive business knowledge in Financial, Banking, Insurance, Healthcare and Industrial sectors
· Motivated, quick learning individual with excellent communication and interpersonal skills.
Thanks and Regards,
Sai
Netprologic
1101 West Iriving Park Rd
Bensenville Illinois 60106
Tel : *630-908-2515*
Email : sai@netprologic.com
www.netprologic.com