Innovations technological

Hi

We have this excellent Informatica Consultant available on Bench. Please keep us updated on any requirements that would match his profile

Professional Summary

• Overall 8+ years of extensive experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center 9.X/8.X, SQL, PL/SQL, Oracle, DB2 and UNIX.
• Experience in Informatica PowerCenter 9.x/8.x with strong business understanding and knowledge of ETL of data from heterogeneous source systems like Flat files, Excel, XML and Oracle.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements, ETL design and implementation, and support for new and existing applications.
• Highly Proficient in Informatica Designer Components like Source Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Expertise in using Oracle 10g/11g and had hands on experience in building advanced relational database objects which uses Oracle 10g/11g database.
• Strong knowledge in Data Modeling (Relational dimensional, Star and Snowflake Schema), identifying FACT and Dimensions Tables, Physical and Logical Database design using ERWIN.
• Troubleshooting and problem solving applications with Informatica Debugger and performing code migration from Dev to Test.
• Experience in Slowly Changing Dimensions (Type 1, Type 2 and Type 3), OLAP, Data Reports and Surrogate keys.
• Designed complex mappings using Source Qualifier, Filter, Normalizer, Aggregator, Router, Update Strategy, Union, Unconnected and Connected Lookups, Joiner, Sorter and Stored Procedure Transformations.
• Developed various Data Documentation Standards and ETL Mapping Documentations.
• Designed Reusable Transformations and Mapplets for better usability and performance.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Knowledge of working with tools like Toad and utilities like SQL* PLUS, SQL Developer.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.
• Excellent team member with problem solving, troubleshooting skills and interpersonal skills.
• Extensive experience in documenting the ETL components. Experience in creating Technical Design Documents/Low Level Design Documents/Run Book.
• Worked closely with the business analyst team in order to solve the Problem Tickets, Service Requests.

Technical Summary

Thanks & Regards

RAHUL

Manager- Recruitment

Email: rahul@theappliedthought.com

IM: ka.rahul

Phone:   407- 574-3040

Fax:       407-641-8184