Working as Lead ETL Developer using Informatica and PL/SQL to design high performance load/transform processes for a regulatory sanction application handling data from all geographies.

Worked as ETL Lead handling a compliance project for its delivery on new changes and enhancements.Also ensured the reference data platform is maintained as per the data warehouse design patterns.• Worked on Informatica – Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet and transformation Developer.• Designed and Customized data models for data warehouse supporting data from multiple sources.• Used most of the transformations such as the source qualifier, expression, aggregator, connected & unconnected lookups, Filter, Router, Sequence Generator, Sorter and Joiner.• Responsible for loading data from source systems into target tables using various transformations like Aggregators, Expression, Lookup, Sequence Generator, Update strategy etc.• Extensively used pre-SQL and post-SQL scripts for loading the data into the targets according to the requirement.• Created Unix shell scripts to modify the client description tables according to the requirement.• Created Mapplet to be re-used in Informatica mappings.• Handle slowly changing dimension based on the business requirements.• Maintained reference data platform with slow changing dimensions.• Extensively worked on solving Performance issues and optimization on both mapping level and session level.