• Informatica PowerCenter 10.1.1, Informatica BDM 10.1.1 ,Informatica Data Quality 9.6.1 (IDQ), Informatica PowerExchange 10.x, 9.x, Hive, HDFS, Oracle, XML.• AWS S3, Glue (Using Scala), Redshift, RedshiftSpectrum, Lambda.• Developed AWS Glue jobs using Scala to handle multiple transformations to load data from one zone (Raw) to an another zone (Refined).• Developed different DataQuality checks using Drunken Data Quality API and integrated with AWS Glue job.• Created scripts to migrate transformed data into Amazon redshift from where data is exposed to business analysts using Spotfire and Tableau.• Developed hive scripts to dynamically alter and add new columns to hive tables.• Developed Informatica BDM applications to parse the raw data, populate staging tables and store the refined data in partitioned tables.• Developed numerous IDQ mappings using the various transformations including Address Validator, Association, Case Converter, Classifier, Comparison, Consolidation, Match, Merge, Parser etc.• Created HDFS connections in Informatica BDM for Integration with Hadoop.• Developed reusable framework in Informatica PowerCenter which eliminated data being loaded into multiple staging databases/ instances, thus improved performance for end user.

• Informatica PowerCenter 9.1, 9.6.1, Informatica Developer 9.5.1, 9.6.1 hot fix 1,2-Informatica Big Data Edition,Informatica Data Quality 9.6.1 (IDQ) toolkit, Hive, HDFS, Oracle, XML , XSD, GreenPlum, Attunity Replicate.• Developed Informatica BDE applications to parse the raw data, populate staging tables and store the refined data in partitioned tables.• Involved in creating Hive table, loading with data, writing hive queries to test the test cases.• Designed IDQ mappings which is used as Maplets in Power center • Developed numerous mappings using the various transformations including Address Validator, Association, Case Converter, Classifier, Comparison, Consolidation, Match, Merge, Parser etc.• Created HDFS connections in Informatica BDE for Integration with Hadoop• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD using Informatica BDE(in HIVE) and PowerCenter.• Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy using Informatica PowerCenter.• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.• Involved in peer-peer review of the code and was also involved in giving sessions to team members.