Informatica consltant available for projects nationwide

 

 

PROFESSIONAL SUMMARY:

 

·         About 6yrs work experience with Business Users to analyze the business process model and made necessary changes to schema objects to cater users reporting needs.

·         Extensive experience in ETL methodologies for supporting Data Migration, Data Exchange, DataTransformationusing Informatica Power Center v 8.x/7.x/6.x/5.x Suite

·         Implemented Informatica Naming standards and Best Practices for the full life cycle of data warehouse projects, right from design to development through go-live and support

·         Experience in documenting the Informatica mapping with comments in various objects

·         Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer, Workflow Manager and Monitor.

·         Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles (Kimball/Inman) - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization

·         Data modeling experience in designing and implementing Data Mart and Data Warehouse applications using Erwin.

·         Experience in integration of various data sources like Oracle, DB2, IMS, COBOL copybooks, MQ, VSAM, datacom, SQL Server, Flat Files, Excel, and XML files

·         Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data.

·         Extensively used various Performance Tuning techniques to improve the performance for data loads

·         Experience interacting with Business users and Architecting high level requirements, high level design and detailed level design documents.

·         Strong Quality Assurance and debugging skills in ETL Process

·         Solid understanding of OLAP concepts and challenges with large sets of data

·         Good Project Coordination skills, onsite coordination and offshore team management.

·         Quick learner and adaptive to new and challenging technological environments

·         Proficient in Toad, SQL navigator, and UNIX Shell Scripting

 

TECHNICAL SKILLS:

 

ETL Tools	Informatica 8.x/7.x/6.x/5 (PowerCenter/PowerMart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)
Data Modeling	Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.
Databases	Oracle 10g/9i, MS SQL Server 2005/2000, MS Access
Languages	SQL, PL/SQL,C, Oops concepts, Unix Shell Script
Web Technologies	HTML, XML, Java Script,CSS
Tools	SQL plus, PL/SQL Developer, Toad, SQL* Loader
Operating Systems	Windows NT/2000/2003/XP/Vista/7, UNIX, MS-DOS and Linux

--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To post to this group, send email to sureshotjobs@googlegroups.com.
To unsubscribe from this group, send email to sureshotjobs+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sureshotjobs?hl=en.