Title: Senior Enterprise Data Warehouse Developer
Skills: EDW Design, Oracle, Informatica
Date: 10-26-2009
Description: OppenheimerFunds, Inc. is one of the largest and most respected mutual fund managers in the United States. With more than 60 mutual funds and more than 6 million shareholder accounts, Oppenheimer has been serving the investment needs of financial advisors and their clients since 1960.
Position Purpose:
The Senior Enterprise Data Warehouse Developer is responsible for the design, development, maintenance and support of the Finance Data Mart. The developer function includes all phases of data warehousing, including requirements gathering, data warehouse design, logical modeling, data acquisition design, development, testing, and deployment, as well as documentation.
Experience and Education:
4 year college degree in Computer Science or Engineering or equivalent experience
5-7 years of experience working in an Oracle, Informatica, UNIX production data warehousing environment as a Data Warehouse developer
5-7 years of experience of data modeling using Erwin or PowerDesigner
5-7 years of experience designing and implementing ETL processes using Informatica PowerCenter
5-7 years of experience with Oracle databases (10g or higher preferred) and expertise in SQL and PL/SQL programming and performance tuning on UNIX
5-7 years of experience developing UNIX shell scripts to support initiating and monitoring ETL processes
Required Competencies:
Must have experience and be comfortable engaging and working with all levels of business stakeholders
Demonstrated understanding of concepts, best practices and functions of a data warehouse in the corporate environment
Ability to troubleshoot and resolve performance issues with overall infrastructure
Ability to write advanced PL/SQL programs (performance tuning, packages, triggers, exceptions, collections)
Experience developing maintainable, high performing ETL processes
Experience designing, implementing and supporting high performance database architectures with large volumes with the abilities to maximize performance, data integrity and recoverability
Expertise in developing star schemas (dimensions, facts, and measures)
Experience designing and implementing Operational Data Stores and OperMarts
Strong proficiency for analyzing source data and creating staging designs and dimensional data models
Experience with IDQ and First Logic Software for data cleansing
Experience with Erwin and PowerDesigner for data modeling
Desired/Optional Competencies:
Experience working with data for shareholder accounting, fund accounting, and other industry related data
In depth knowledge of Cognos, including framework and report design, development and implementation
Experience with Oracle running on Linux
Experience with high availability for Oracle (RAC) and Informatica
OppenheimerFunds is a thriving organization which provides a positive work environment, professional challenges, competitive compensation, and work/life balance.
Please visit us at www.oppenheimerfunds.com to learn more about our company and career opportunities.
APPLY TO INSTRUCTIONS:
Please submit resumes to oppjobs@oppenheimerfunds.com
Oppenheimer Funds Inc
Centennial, CO 80112
Web: http://www.oppenheimerfunds.com
