Sr. Specialist Developer - ETL/Informatica Sr. Specialist Developer - ETL/Informatica …

BNY Mellon
in New York, NY, United States
Permanent, Full time
Last application, 02 Apr 20
BNY Mellon
in New York, NY, United States
Permanent, Full time
Last application, 02 Apr 20
Sr. Specialist Developer - ETL/Informatica
Clearing, Markets &Issuer Services Technology (CMIST) is responsible for application development andsupport for more than 350 critical business systems including Repo Edge(collateral management), Enterprise Payment Hub (multi-currency payment processing),and Broker Dealer Clearance (securities clearing).

Issuer Services Technology supports theCorporate Trust and Depositary Receipts businesses, which provide world-classequity and debt servicing. This includes application development, maintenanceand risk management for the portfolio of proprietary and third-partyapplications used by the $1.3B Corporate Trust business. Focuses include clientrelationship data integration to provide a complete view of data acrossbusiness lines and enhancing the client experience through digitization andautomated onboarding. The Issuer Services Technology group also supports thebroad spectrum of intranet-based systems for BNY Mellon award-winningDepositary Receipts business.

This position is within the GovernmentDevelopment Services Group, a high performing group within Corporate TrustTechnology that supports U.S. Government contracts. The perfectcandidate will be a part of an interactive team that works with varioustechnologies and business partners to provide efficient, user friendlyapplication for internal and external clients. The applicationsmust have high availability and be scalable in order to support growingportfolio.

Sr. Specialist Developer->> Consults with internal business groups to provide appropriate application software development services or technical support. Analyzes, defines and documents requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks, controls, and outputs using BNY Mellon's standard development methodology. 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. Contributes to defining time tables and project plans. Analyzes and estimates feasibility, cost, time, and compatibility with hardware and other programs. Takes lead for establishing, implementing and monitoring 'best practices' for technical development methodologies and tools. Proposes innovative, creative technology solutions. Contributes to the achievement of area objectives.


  • Bachelor'sdegree in computer science engineering or a related discipline, or equivalentwork experience required

  • 8to 10 years of experience in software development required with ETL development experience with Informatica 10.x product

  • Must be well versed withdesigning ETL workflows, administration and deployments

  • Must be well versed withWeb Service Hub (WSH) exposing the workflows as web services, and it is must.

  • Must be well versed withpower center/power exchange

  • Must be well versed withdatabase concepts and integration with Oracle, Mainframe and salesforce

  • Must be well versed withwriting complex SQL queries by using advanced SQL functions

  • Must have good debuggingskills

  • Must have goodexperience in understanding the business/functional requirements

  • Must be a team player,and must have experience working with a large team.

  • Ability to work within ateam and lead database efforts and to document customer requirements, translateinto technical designs, and explain technical issues clearly and accurately toboth technical and nontechnical audiences.

  • Strong problem-solvingand interpersonal skills, as well as strong written and oral communicationsskills and demonstrated ability to adjust to changing priorities and handlemultiple tasks simultaneously.

  • Experiencein the securities or financial services industry is a plus.

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-New York-New York
Internal Jobcode: 45172
Job: Information Technology
Organization: Clearing Markets ISS Svcs Tech-HR16624
Requisition Number: 2000318