• Around 9+ years of professional experience in ETL Informatica Development ,Oracle PL/SQL program for industries like Pharma, Insurance, Hospitality, etc., • Having good experience in the implementation of Data Warehousing and Database business systems. • Data warehousing experience using Informatica Power Center, B2B DataTransformation, B2B DataExchange, Power Mart, and Power connect, Designer, Workflow Manager, workflow Monitor, ETL, Data mart, OLAP, OLTP. • Experience in designing and developing complex and efficient DataTransformation code for convert excel and binary files to XML format. • Experience in setting file extraction on demand in B2B Data Exchange. • Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, web services, Unstructured Data Transformation, SQL, Router, Filter, Expression, Aggregator, Joiner, Update Strategy ,Key generation etc. • Created Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2, and Type 3) mappings. • Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, XML, Excel, MQ Series) to load into data warehouse/data mart targets. • Experienced in Performance Tuning of sources, targets, mappings, transformations and sessions. • Written complex SQLs using joins and sub-queries. • Database experience using Oracle ,TOAD, SQL, PL/SQL, SQL*Plus, SQL*Loader • Extensive development, support and maintenance experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data warehousing and Business Intelligence. • Experience in Modeling Transactional Databases and Data Warehouses Data Modeling using Erwin. • Involved in developing mass upload procedures and scripts that used to validate business rules and load data from source files to target data base. • Good exposure to Development, Testing, Debugging, Im