Informatica Developer

Responsiblties:

• Excellent Informatica power centre, Informatica IDQ, SSIS and Amazon Redshift , Oracle Linux, TERADATA development skills.
• 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.

Key Skills:

• Data warehouse.
• Software development.
• Problem solving.
• SQL.
• Communication.
• Data analysis.
• SQL proficiency.
• Shell script.
• SQL Server.