BNY is seeking to modernize its data integration platform, including migration to Informatica Cloud and alignment with strategic platforms like Data Warehousing, Pentaho, Snowflake, Oracle, and PySpark. The role aims to provide technical expertise and leadership for data integration, transformation, and distribution within the department's investment analytics core platforms.
Requirements
- Expertise in implementing large-scale data integration solutions leveraging Informatica Power Center across a fully diverse set of data master repositories, sources and targets.
- Expertise in Informatica Power Center – Version 10.x preferred.
- Experience in cloud based database strictures, Mongo, Snowflake, Azure, etc.
- Application development proficiency in Informatica, DB2, SQL Server, and Oracle.
- Experience in .Net cloud based database strictures, Mongo, Snowflake, Azure, etc.
- Application development experience with Informatica, Java, .Net, and/or Python
- 10-14 years of experience in software development required
Responsibilities
- Provide technical expertise and leadership in the implementation and support of data integration, transformation, and distribution of all data sets in to and out of the department’s investment analytics core platforms.
- Participate as the lead technologist of the investment data integration team to design, develop, configure, and install data integration ETL workflows and associated components per business requirements.
- Manage /provide guidance on tasks for a mixture of applications on a variety of technical platforms; Windows, .net, Informatica, Java, Linux, Mainframe.
- Define roadmap to modernize the current data integration platform inclusive of – migration to Informatica Cloud, and define alignment to strategic platforms including Data Warehousing, Pentaho, Snowflake, Oracle, and Pyspark
- Own the end-to-end development lifecycle and provide occasional off-hours support as needed
- Manage platform architecture projects to upgrade, replace and ‘ever-green’ existing technical platforms to ensure stability and long-term viability.
- Contribute to architectural design and implementation, both as part of the team and as an independent contributor.
Other
- Senior Vice President, Lead Engineer Data Integration and Operational Systems – (Informatica / DB2, SQL / .Net)
- This role is located in Pittsburgh, PA – HYBRID.
- Provide technical leadership to an Agile team who are a mixture of technical developers and system analysts
- Successful candidate will have a proven track record as a self-starter, will be equally at home working as a contributor as well as providing technical leadership to a team.
- Candidate will have strong analytical skills and delivers quality results on complex implementations, including the informatica platform, with a minimum of post implementation issues.
- Candidate will have a proven record of introducing new and innovative solutions to issues such as web service integration, data warehousing and cloud integration and processing efficiencies.
- Bachelor's degree in computer science or a related discipline, or equivalent work experience required, advanced degree preferred
- experience in the securities or financial services industry is a plus.
