State Street Data Warehouse Developer in Quincy, Massachusetts

This position is for a Senior Developer working in the proprietary Data warehouse (ESP) implementation team for Investment Manager Services Business Unit. The position requires a strong background in application development, a good understanding of leading IT technologies in particular PL/SQL, Oracle and Unix. The person in this role will be completely hands-on and will work with cross-functional teams. The work will require a candidate to be competent in all aspects of the software development lifecycle.

Job Description

  • Meet with users across multiple Business domains and platforms and work with them to translate their business requirements into a technical design

  • Able to support the entire IMS Suite of applications and work with various development teams

  • Provide guidance to the development teams on various implementations

  • Able to define data structures and data models

  • Able to perform ETLs and validating results with the Business reps

  • Capable of reviewing the database performance and implement the necessary optimization techniques

  • Able to work independently on Oracle database related issues

  • Provide technical direction on several IMS implementation teams

  • Provide design documentation to capture high level data flows, facts, and dimensions Experience:

  • Must have a sound understanding of relational data structures, dimensional data modeling, SQL skills

  • Must have experience in Data warehouse and reporting techniques

  • Proven ability to lead the design and development of Data Warehouse based platforms

  • Experience with Exadata and oracle

  • Experience working with business partners to conduct business analysis and requirement definition workshops.

  • Technical ability to be able to not only manage an effort, but to develop the solution is important. This is a technical role with a high percentage of time spent in development.

  • Strong understanding of PL/SQL and SQL Tuning required. Qualifications

  • 3 Years of Software Development experience

  • 2 years working with Oracle 11g/12c databases including PL/SQL development, SQL, and performance tuning.

  • 1+ years working with exadata appliances

  • 2 years working on Data Warehousing projects including design and development

  • Bachelors of Computer Science degree

  • Excellent Communication Skills

  • Posted 10 Days Ago

  • Full time
  • R-587034