Sr. Specialist Developer - Pentaho "Kettle"

  • Competitive
  • Pittsburgh, PA, USA
  • Permanent, Full time
  • BNY Mellon
  • 17 Sep 17

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. Analyzes and estimates feasibility, cost, time, and compatibility with hardware and other programs.

Sr. Specialist Developer - Pentaho "Kettle"

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.

 

The qualified candidate will have strong experience as an Pentaho(Kettle) developer and will have experience working on large scale distributed systems backed by large data sets. Familiarity with data warehousing concepts and experience managing large sets of data.
The Pentaho ETL developer will provide support in all aspects of data movement for a data warehouse environment,
Design/Develop/code end to end technology solutions for BNY enterprise risk business including batch process, calculation engine, database modeling, testing and process automation
Interact with business users and understand enterprise risk business requirements, and analyze and come up with optimal technology solutions to business requirements
Work closely with offshore team to deliver projects on time and in a high quality manner
Conduct system analysis and work estimate for new tasks.
Write high level and low level design documents; Conduct peer code review
Collaborate with other internal or external teams on projects such as sourcing data feed
Qualifications
3 to 7 years’ experience with ETL tools such as Pentaho, Informatica and Datastage.
At least 2 years of experience with ETL tool Pentaho(Kettle)
Pentaho admin experience would be plus.
Proficient in SQL and experience with Oracle PL/SQL will be plus.
Data warehousing experience preferred
Experience of working with development of complex large scale systems required
Ability to work efficiently with our offshore team
Strong communication and interpersonal skills, excellent team player
Superb ownership mindset, strong work ethics, a habit of excellence
Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required
5 years of experience in software development required, experience in the securities or financial services industry is a plus
Qualifications

Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required, 8-10 years of experience in software development required, experience in the securities or financial services industry is a plus.