Informatica Power Center

Requirement ID:

10150469

Posted On:

Jul-03-2025

Role name:

Developer

Role Description:

Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.- Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.- Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).- Performs source system analysis as required.- Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.- Implements versioning of the ETL repository and supporting code as necessary.- Develops stored procedures, database triggers and SQL queries where needed.- Implements best practices and tunes SQL code for optimization.- Loads data from SF Power Exchange to Relational database using Informatica.- Works with XMLs, XML parser, Java and HTTP transformation within Informatica.- Works with Informatica Data Quality (Analyst and Developer)- Primary skill is Informatica PowerCenter

Competencies:

Informatica Powercentre, ORACLE SQL

Experience (Years):

6-8

Essential Skills:

Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.- Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.- Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).- Performs source system analysis as required.- Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.- Implements versioning of the ETL repository and supporting code as necessary.- Develops stored procedures, database triggers and SQL queries where needed.- Implements best practices and tunes SQL code for optimization.- Loads data from SF Power Exchange to Relational database using Informatica.- Works with XMLs, XML parser, Java and HTTP transformation within Informatica.- Works with Informatica Data Quality (Analyst and Developer)- Primary skill is Informatica PowerCenter

Desirable Skills:

Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.- Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.- Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).- Performs source system analysis as required.- Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.- Implements versioning of the ETL repository and supporting code as necessary.- Develops stored procedures, database triggers and SQL queries where needed.- Implements best practices and tunes SQL code for optimization.- Loads data from SF Power Exchange to Relational database using Informatica.- Works with XMLs, XML parser, Java and HTTP transformation within Informatica.- Works with Informatica Data Quality (Analyst and Developer)- Primary skill is Informatica PowerCenter

Country:

United States

Branch City Location:

TCS - Cincinnati, OH

COLUMBUS

Columbus, OH

BA Recruiter Name:

DEVIKA Madhu J

Start Date:

Jul-28-2025

Duration (Months):

6

Status:

Open

Keywords:

Informatica Power Center