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).
MUST HAVE:
7+ years of experience in Informatica Powercentre.
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.
Numbers & Facts
Location
Waltham, Massachusetts
Skills
Data Warehousingunmatched
Database Extract Transform and Load (ETL)unmatched
Debugging Skillsunmatched
Informaticaunmatched
Network Routersunmatched
Oracle PL-SQLunmatched
Performance Tuning/Optimizationunmatched
Problem Solving Skillsunmatched
Test Caseunmatched
Testingunmatched
Unit Testunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.