Informatica/ETL Developer

This is a full time role with PNC Bank. USC/GC. 100% remote. Only EST/CST candidate. Avoid PA candidates.

5-8 years of development experience 4 - 6 Years

Advanced design and programming skills in Informatica power center 9.6 & above and Oracle SQL/PLSQL 4 - 6 Years

Designing HTTP Transformations 4 - 6 Years

Develop SCD mappings with difference source formats using necessary Transformations 4 - 6 Years

Experienced in handling the ETL Code deployments using DevOps Tools 4 - 6 Years

Formal experience in working in projects with a methodology (waterfall, agile) 4 - 6 Years

Hands on knowledge with UNIX shell scripting and CA7 job scheduler 4 - 6 Years

Intermediate level skills in data analysis and data modeling 4 - 6 Years

Performance tuning of Targets, Source, Mappings, Sessions, and Workflows 4 - 6 Years

Proficiency in developing and debugging the PL/SQL Code 4 - 6 Years

Describe the impact this role has within the bank/LOB:

The specific role is for an ETL lead who will work on data intensive Applications that support business and regulatory requirements.

Describe the required must have technical skills, tools, or experience:

5-8 years of development experience

Advanced design and programming skills in Informatica power center 9.6 & above and Oracle SQL/PLSQL

Proficiency in developing and debugging the PL/SQL Code

Performance tuning of Targets, Source, Mappings, Sessions, and Workflows

Develop SCD mappings with difference source formats using necessary Transformations

Design HTTP Transformations

Experienced in handling the ETL Code deployments using DevOps Tools

Hands on knowledge with UNIX shell scripting and CA7 job scheduler

Intermediate level skills in data analysis and data modeling

Formal experience in working in projects with a methodology (waterfall, agile)

Is there any skills you are willing to flex on if a candidate does not have it?

BI tools such as Microsoft Power BI / Tableau / Oracle BI

Hands on Knowledge using Teradata

Working knowledge of software design patterns and architecture

The role requires proficiency in leading, collaborating, designing, and programming data related changes from consumption to reporting.

Lead complex problem solving and provide technical guidance and support to colleagues and solution development.

Proposes, designs & codes software solutions to address complex business needs.

Oversees technical and procedural documentation as required.

Actively and independently strive to broaden technology and business knowledge.

Aligns business strategy with software solutions.

Displays an innovative approach to apply modern software development principles, methodologies, and tools to advance business initiatives and capabilities

Role Differentiator:

Describe what is different about this specific role compared to others hiring for the same skill set?

In this role there will be lots of opportunity to grow and learn the technologies. There is a good amount of exposure to the end-to-end processes lending itself to the ability to understand the full picture of the utilized applications. Despite being a large company, one is able to see the lay of the land across various business units and identify opportunities for career and knowledge growth.