Job Details

Email to Friend Save Back

ETL Pentaho Analyst

PITTSBURGH-15213, PA, US
12/07/2016

-

Required Skills

Oracle PL

Company

Infinity Consulting Solutions, Inc

Experience

3 to 7 Year(s)

Job Description

Leading Investment Management firm is seeking a Data Analyst/Data Modeler who will be working with Pentaho data tools.

The Risk IT Group is in the middle of building out the new enterprise risk system.

It will have the ability to aggregate the risk measures across the firm, in support of regulatory as well as internal risk management requirements.

While the initial focus of the business functions is for counterparty credit risk, the system will provide measures for all other risk disciplines as well, including market, liquidity and operational risk.

The qualified candidate will have strong experience as a 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

Master's in Computer Science preferred. Bachelors in CS and related work experience.

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

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 ethic, 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

Third Party Applications Not Accepted