Informatica PowerCenter Developer

5 Star Recruitment; Waltham (MA); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading recruitment agency is seeking an experienced Informatica PowerCenter Developer to play a key role in ETL processes. The ideal candidate will have over 7 years of experience in Informatica, strong skills in PL/SQL, and a solid understanding of data warehouse concepts. Responsibilities include developing mappings, managing workflows, and tuning performance. If you have a passion for data management and a proven track record, we encourage you to apply. This opportunity is based in Waltham, Massachusetts.

Qualifications

• 7+ years of experience in Informatica PowerCenter.
• Must have hands-on experience with PL/SQL.
• Good understanding of ETL processes.

Responsibilities

• Develop mappings for data extraction from various sources.
• Tune and check the performance of Informatica mappings.
• Create and manage sessions and workflows using Workflow Manager.

Skills

Informatica PowerCenter

PL/SQL

ETL

Data warehouse concepts

Job description

About the job Informatica PowerCenter Developer

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).

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.