Informatica PowerCenter Developer – Banking

Job Description

Required Skills

· Informatica Power Center

· Oracle

· SQL

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 Power Center 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 Power Center.

Experience: 6-8 years

Requirements
Required Skills
• Informatica Power Center
• Oracle
• SQL

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 Power Center 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 Power Center.

Experience:

6-8 years