Job Duties : Excellent Informatica power centre, Informatica IDQ, SSIS and Amazon Redshift , Oracle (SQL, plsql), Linux, TERADATA development skills. Having hands on experience in REPOSITORY MANAGER, DESIGNER, WORKFLOW MANAGER and WORKFLOW MONITOR. Worked in slowly changing dimension tables. Proficient in ETL and DATAWAREHOUSE concepts used in BI. Extensively worked on Data Analysis, Design, Development, Implementation and Testing of ETL mappings. Worked on the development projects on Informatica in Oracle 9. Well experienced in extraction, transformation and loading of data from heterogeneous sources system like flat file, xml, Oracle. Having hands on experience in Informatica Designer component – Source Analyzer, Transformation Developer, Mapping and Mapplet Designer and strong experience on Workflow manager tool – Task Developer, Workflow and Worklet Designer. Worked on different types of transformations like Source Qualifier, expressions, router, filter, sorter, aggregator, update strategy, lookup, normalize, sequence generator, java Transformation. Have clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including development, testing and implementation. Experience in Data Warehouse development working with Extraction Transformation and loading using Informatica Power Center with Oracle, Flat file. Responsible for interacting with business partners to identify information needs and business requirements for reports. Knowledge in star and snowflake schemas, dimensional data modeling, Fact and dimensional tables, slowly changing dimensions.