Investment Management Technology group is in need of a ETL Developer working with trade management and execution platform with experience of using Pentaho or similar ETL tools, to integrate with Oracle, flat files, APIs and numerous other data sources. The role provides the opportunity to have a uniquely critical role focused on integrating ETL tools with trading management and execution systems and numerous financial data providers. Responsibilities: Candidate would be responsible to interact with the business on identifying areas of improved automation and systemization of existing services and workflows. Candidate would consult the business on existing technologies and provide estimates on future work. Additionally, candidate would work on architecture roadmap to deliver new and improved technology for the business, improve user experience, enhance system processing, and eliminate technology debt. Consults with internal business groups to provide high-level application software development services or technical support. Provides comprehensive senior-level technical consulting to IT management and senior technical staffs. Evaluates compliance with the organization's technology standards . Actively participate in code reviews. Integrate software components into a fully functional software system. Apply security and privacy principles. Works with internal business groups on implementation opportunities, challenges, and requirements of various applications. Analyzes information and provides recommendations to address and resolve business issues for a specific business group. Guides and consults with IT management and technical staffs regarding use of emerging technologies and associated services. Participates in defining corporate implementation and integration strategies of new technologies. Active learning engagement. Complete all required mandatory training / policy awareness curricula on time. Use learning tools such as Pluralsight to complete both recommended and aspirational targets set in personal development plans. Stays abreast of emerging technologies. Advocates for innovative, creative technology solutions. Mentors junior level engineers. Relevant experience with Oracle 9i and PL-SQL, including index strategies, performance tuning and optimization and stored procedures. Database developers must be able to create Oracle reports and write complex SQL statements for large scale databases. Communications and organization skills; team work skills; possess stong analytical skills and interpersonal skills to support mentoring. Contributes to the achievement of area objectives Qualifications Qualification Experience with Pentaho is a preferred, will consider candidates with experience with other ETL tools, including Spark, Informatica, Data Mover, etc. Oracle database knowledge and experience is required, other database systems are a plus, including Mongo, PostgreSQL, SQL Server, etc. Experience, knowledge and understanding of metadata driven ETL architecture, design and development. Experience with Java/Python is preferred. Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required 9-11 years of experience in software development required; experience in the securities or financial services industry is a plus. Job holder must have understanding interdependencies and business impact of future IT plans. S/he must have prior lead experience selecting and implementing vendor-specific methodologies and prior consulting experience with structured methodologies. Extensive experience with developing and supporting mainframe applications required. Job holder must have broad experience with multi-platform development tools and toolkits. BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer. Minorities/Females/Individuals With Disabilities/Protected Veterans. Our ambition is to build the best global team – one that is representative and inclusive of the diverse talent, clients and communities we work with and serve – and to empower our team to do their best work. We support wellbeing and a balanced life, and offer a range of family-friendly, inclusive employment policies and employee forums. Primary Location: United States-Pennsylvania-Pittsburgh Internal Jobcode: 96093 Job: Information Technology Organization: Investment Management Tech-HR18028 Requisition Number: 2103002