Informatica, Informatica Powercentre, 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 Powercentre. • 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). Additional Notes: • Please submit the candidate's resume in PDF format. • Please remove the candidate's LinkedIn 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.