Informatica PowerCenter Developer – Banking

Not Interested
Bookmark
Report This Job

profile Job Location:

Toronto - Canada

profile Monthly Salary: Not Disclosed
profile Experience Required: 5years
Posted on: 15 hours ago
Vacancies: 1 Vacancy

Job Summary

Required Skills

Informatica PowerCenter

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


Experience: 6-8 years




Required Skills:

Required Skills Informatica PowerCenter 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 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. Experience: 6-8 years

Required Skills Informatica PowerCenter 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 Pow...
View more view more

Company Industry

IT Services and IT Consulting

Key Skills

  • Anti Money Laundering
  • Entry Level Sales
  • Asset
  • Application Engineering
  • Electrical & Instrumentation