Available ETL Informatica Developer

[Bhargav]

Hello,

I hope you are doing great.

I have an excellent ETL Informatica Developer consultant with.

• Over 6 years of IT experience with extensive Data Warehousing implementations across healthcare, Financial, Pharmaceutical and Product based Industries using Informatica Power Center 8.x/7.x/6.x and Oracle Database.
• 4+ years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center with client tools like Designer (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer), Repository Manager, Workflow Manager and Workflow Monitor.
• Experience in all the phases of Data warehouse life cycle involving Requirement gathering, Implementation & Design, Development, Testing and Deployment.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Designed complex ETL mappings like slowly changing dimensions, performed critical performance tweaking stages with partitioning, persistent cache and extensive use of mapplets.
• Strong knowledge of Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimensions Tables.
• Experience in integration of various relational and non-relational data sources like Oracle, SQL Server, and Flat Filesinto staging area.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Event Wait, Event Raise, Timer etc).
• Expert knowledge in Performance Tuning, identifying and resolving performance bottlenecks in various levels such as source, mapping, target and sessions to provide maximum efficiency and performance.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Experience in writing, testing and implementation of the PL/SQL packages, triggers, stored procedures and functions.
• Good understanding of Relational Database Management Systems (RDBMS) like Oracle 8i/9i/10g/11g.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Involved in Unit testing, Integration testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the business users by attending meetings with the clients in Requirements gathering phase.
• Coordinated and provided technical oversight to onshore and offshore team to implement the project.
• Excellent analytical/ communication skills and good team player.

TECHNICAL SKILLS:
Data Warehousing Tools Informatica Power Center 9.x/8.x/7.x/6.x
Languages SQL, PL/SQL, HTML, XML, C
Databases Oracle11g/10g/9i/8i/7i, MS SQL Server 2008/2005/2000
Operating System Windows 9x/NT/2000/XP, UNIX, Linux, MS-DOS
Tools/Utilities SQL*plus, SQL Developer, Toad 5.x/6.x/7.x/8.x/9.x
Scripting UNIX Shell Script


I would appreciate if you add bha...@tekwissen.com to your distribution list.


Please reply back to bha...@tekwissen.com


Note:- We work with direct client requirements.

Thanks & Regards

Bhargav
Technical Recruiter
TekWissen LLc


595 Forest Avenue Suite # 9B
Plymouth, MI - 48170
Email : bha...@tekwissen.com
Desk Number : 734.259.2181 Ext 255
Direct Number: 734.418.0075
Fax: 734.340.6033
www.tekwissen.com
http://www.linkedin.com/pub/bhargav-s/50/947/973
Gtalk: bhargav....@gmail.com
Y IM: bhargav....@yahoo.in
_________________________________________________________________
Confidentiality Note:
The information contained in this transmission is intended only for the individual to whom or entity to which it is addressed. It may contain confidential information which is protected by law. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering the message to the addressee, the reader is hereby notified that any use, dissemination, distribution, or copying of the information is strictly prohibited. If you have received this communication in error please notify our office immediately by telephone, fax, or electronic mail. Thank you.