Informatica PowerCenter Developer; Waltham, MA

Waltham, Massachusetts, United States ESR Healthcare

Job Openings Informatica Power Center Developer (10596-1) Waltham, MA

Informatica, Informatica Power centre, PL/SQL, ETL, PCS, Data Warehouse

If you post this job on a job board, please do not use company name or salary. Experience level:
Mid-senior Experience required: 7 Years Education level:
Bachelors degree Job function:
Information Technology Industry: Information Technology and Services Pay rate :

Total position: 1 Relocation assistance:
No Visa sponsorship eligibility:
No

Note:

• Only U.S. Citizens and Green Card Holders are eligible to apply.

Job Description:

• 7+ years of experience in Informatica Power centre.
• Knowledge of PL/SQL is Must with hands-on experience.
• Understanding the Business Requirements & ETL specification Document Extraction, 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 Manager Involved in testing the mappings (UNIT testing) and preparation of test cases.
• Ensuring proper Dependencies of loads (Incremental and Complete loads).

Additional Notes:

• Please submit the candidate's resume in PDF format.
• Please remove the candidate's Linked In URL from the resume; otherwise, the profile will not be considered.
• Please note that TCS does not consider former full-time employees (FTEs) for rehire. Additionally, individuals who have previously worked at TCS as contractors must observe a minimum waiting period of six months before being eligible for re-engagement.