Informatica Developer

Responsiblties:

• 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.

Key Skills:

• Data warehouse.
• SQL.
• Data analysis.
• Creativity.
• Collaboration.
• Troubleshooting.
• Problem solving.