• 14+ years of IT Experience of Application Development, Support, and Maintenance. • Hands on experience in Informatica Power Centre, Oracle 9i/10g/11g, Teradata 14, SQL, PL/SQL.• Strong ETL experience of using Informatica Power Centre 8/9.X Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.• Good experience on Informatica Power Centre with strong business understanding and knowledge of Extraction, Transformation and Loading of data from heterogeneous source systems like SFDC, SAP, Flatfiles, Oracle, MS SQL, Mainframe, LDAP, Web services.• Worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.• Managing and identifying the mappings between source and targets. Creating the data mapping sheets for different sources interacting with system.• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. • Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.• Profiling the data using the DQ Analyser tool from the different sources as per business requirements.• Good understanding of the slow changing dimensions 1,2 &3, Star Schema and the snow flake schemas.• Interacting with the different teams involve in the project for the understanding of the data flows, mapping and the transformation of the data.• Experienced in UNIX work environment, file transfers, job scheduling and error handling. • Design and implement the data design models as per the requirements of the systems.