ETL Informatica Developer / Only on W2 role/ Hybrid (Pittsburgh, PA)

Unclassified - Pittsburgh, PA

Full-time - Mid Level

Hybrid - Pittsburgh, PA

About the position

The ETL Informatica Developer position involves working on credit card modernization initiatives within the Retail Lending sector. The role focuses on transitioning from mainframe systems to a service-based architecture, ensuring successful data transfer and integration between various systems, including Oracle and NoSQL databases like MongoDB.

Responsibilities

• Develop and maintain ETL processes using Informatica PowerCenter.
• Ensure successful data transfer between mainframe systems and other databases.
• Collaborate with teams in an Agile environment to support credit card modernization initiatives.
• Utilize SQL for data manipulation and querying.
• Work with Power Exchange to manage data flow from mainframe systems.

Requirements

• Advanced SQL skills.
• Proficiency in Informatica PowerCenter.
• Experience with Power Exchange and mainframe systems.
• Familiarity with Oracle databases.

Nice-to-haves

• Basic knowledge of Java for service integration.
• Experience with MongoDB.

Benefits

• Opportunity to work on a top initiative within the bank.
• Exposure to modern data technologies and practices.