OppenheimerFunds, Inc. has been helping investors achieve their financial goals since 1960. We are one of the nation's largest and most respected asset management companies.
OppenheimerFunds' success has and will continue to be driven by our greatest asset: our people. For nearly 50 years, OppenheimerFunds' employees have helped shape a winning, entrepreneurial-based culture fueled by a commitment to our shareholders and our Corporate Values of Excellence, Integrity, Team Spirit and Caring.
Position Purpose:
The Senior ETL Architect is responsible for the design, development, maintenance and support of the Enterprise Data Warehouse and Data Marts. This 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.
Principal Responsibilities:
· 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 Erwin and PowerDesigner for data modeling
· Experience mentoring and training others on Informatica and tuning
· Role may require more than 40 hours per week including weekend / evening / holiday hours
· Ability to interface with customers on requests or projects as well as offshore resources
· Strong aptitude to translate business requirements into technical designs
· Experience working with data for shareholder accounting, fund accounting, and other financial 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
· Experience with IDQ and First Logic Software for data cleansing
· Experience as a team member in an Agile SCRUM environment
Competencies for Success/Requirements:
· 4 year college degree in Computer Science or Engineering or equivalent
· 5-7 years of experience working in an Oracle, Informatica, UNIX production data warehousing environment as a Data Warehouse developer
· 3-5 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
OppenheimerFunds is a thriving organization which provides a positive work environment, professional challenges, competitive compensation, and work/life balance.
