Carrer

Hi

We have this finest Sr. Informatica Developer available for Projects nationwide. Please let me know if you have any suitable requirement.

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, Unix and Mainframes/SAS environments.
• Experience in Informatica Power Center 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, Normalization/De normalization.
• 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.
• Good understanding of IT Mainframe Applications written in JCL, COBOL/SAS and DB2 database tool (SPUFI).
• Hands-on experience in IBM tools like File-Aid, Changeman, Infoman, Endevor, Xpediter.
• 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.
• 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