Informatica PowerCenter Developer needs 7+ years of experience in Informatica Powercentre. Informatica PowerCenter Developer requires:
• Skills: Informatica, Informatica Powercentre, PL/SQL, ETL, PCS, Data Warehouse
• PL/SQL is Must with hands-on experience
• Understanding the Business Requirements & ETL specification DocumentExtraction, Transformation and Loading (ETL) of data by using Informatica PCDesigned various mappings for extracting data from various sources involving flat files and relational tables.
• Good Concept of Data warehouse to be available.
Informatica PowerCenter Developer duties:
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.
• Checked and tuned the performance of Informatica Mappings.
• Testing and maintaining of Informatica Mappings Resolving if any issues in transformations and mappings with the help of technical specifications.
• Checked and tuned the performance of Informatica Mappings.
• Resolve and debugging any development issues.
• Involved in Creating Sessions, Workflows Using Workflow ManagerInvolved in testing the mappings (UNIT testing) and preparation of test cases.
• Ensuring proper Dependencies of loads (Incremental and Complete loads).