Informatica Powercenter Developer

MetaSense Inc

7 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Intermediate

Remote

Java

Databases

ETL

Data Mapping

Data Warehousing

IBM DB2

Database Queries

Java Platform Enterprise Edition (J2EE)

Failover

Java Database Connectivity

SQL Stored Procedures

PL-SQL

SQL Databases

Workflow Management Systems

Data Logging

Scripting (Bash/Python/Go/Ruby)

Enterprise Software Applications

Azure

Informatica Powercenter

Experience developing with Informatica PowerCenter, designing and developing Informatica workflows for enterprise system(s), deployment of Informatica to production environment, and writing scripts to manage/move/schedule files in accordance to Informatica integration.
Minimum 5 or more years of experience working in a medium or large operating environment supporting Informatica.
Minimum 4 years of SQL experience (ability to develop, modify, troubleshoot and optimize complex queries and stored procedures).
Deep understanding of relational/dimensional data modeling and data mapping design, integration, migration and warehousing.
Design and Implementation of ETL solutions with effective design and optimized performance, ETL Development with industry standard recommendations for jobs recovery, fail over, logging, alerting mechanisms.
Preferred development background with Java, J2EE, Database building, SQL scripting and Management: DB2, SQL, PL/SQL, JDBC, Mapping and Workflow Tools.
Preferred experiencing developing with Azure Data Factory.
Previous experience in the banking and insurance industry preferred.