Leading national information technology firm seeking a well-qualified Informatica PowerCenter Developer for Waltham MA location. Position is six-month contract with possibility of extension or offer of permanent employment C2C or visa sponsorship not available. Candidates must be US citizens or green card holders. Position Details: • 7+ years of experience in Informatica Powercentre.required • Knowledge of 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. • 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). Compensation: Highly competitive compensation based upon experience. Possibility of extension or offer of permanent employment at conclusion of six-month contract.