Experience Summary 34 months of experience in Data warehousing, with 32 months on ETL Tool Informatica Power Center 9.1 in life Science Vertical Technical Expertise on Data warehousing forte, Teradata and Oracle Database and related technologies gained through years of hands on work at all levels. Good experience in Data Analysis, Design, Development and Implementation of DataMart and Data Warehouse using Informatica. Strong skills of Informatica Power center – Designer, Workflow manager, Workflow monitor, mapping designer, warehouse designer, various transformations such as source qualifier, expression, joiner, normalizer, router, aggregator, lookup and update strategy. Expertise in working with different data sources like Oracle, Teradata and Flat Files.Role and Responsibilities• Involved in Production Support of ODS WxDM Process, Incentive Compensation Process and Retail monthly sales crediting activities.• Involved in ETL enhancement in order to automate the manual validations using query.• Reached the Eternity of maintaining delivery consistency in the Retail Processes.• Worked in Sales and marketing Data warehouse framework to avoid manual query validations.• Providing On call 24*7 support and providing Root Cause Analysis (RCA) for any Severity 1/2 issue to business.• Involved in Teradata Encryption testing for the workflows in QA test environment that helped in tackling different issues in the workflow level.• Requirement and impact Analysis of minor enhancements.• Creating design for new code developments• Development of new objects.• Bug Fix and Enhancement on existing objects• Automation of manual process• Performance tuning of existing Informatica and Teradata codes• Review of code developed or modified by peer• Unit, Integration and Regression Testing of new and modified codes• Documentation of changes made for existing objects and new objects. Including updates on existing documents whenever required.