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.