At OppenheimerFunds, we've built a winning organization through a partnership between the Company and our employees. This reciprocal relationship provides the Company with the means to be successful in our competitive industry, while ensuring OppenheimerFunds' employees have a true stake in the Company's future and the opportunity to build a rewarding career.
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.
Job Purpose:
As a Senior Programmer within the firms internet development team, this individual will use a wide array of technology to solve business challenges while developing innovative and engaging web application interfaces for our internal clients.
This individual will be a member of a cross-discipline team of analysts and developers dedicated to developing and maintaining the firms internet sites.
Principal Responsibilities:
Participate in all aspects of the system development life cycle with specific focus on the design, estimation, construction, unit and integration testing of both service- and web-tier components
Collaborate with our business partners as well as other development-, infrastructure- and QA- groups to deliver business-focused solutions on time and within budget
Develop high-quality implementations following established development processes
Maintenance of existing and implementation of new web applications
Provide post implementation support and on call production support of application suite
Share past experience and mentor fellow team members in improving the teams implementation and development discipline.
Identify and implement monitoring and preventative maintenance as required.
Keep abreast of the latest developments in Internet technologies
Competencies for Success/Requirements:
8+ years of experience building and supporting Java / J2EE based production applications.
5+ years of experience working with MVC technologies including Struts, Spring MVC, JSF and JSP / JSTL
3+ years of experience in developing externally facing web applications using HTML. AJAX, JavaScript, CSS, DHTML and relevant open-source libraries
1-2 years of experience in alternate languages / frameworks including Groovy/Grails, Ruby/Rails, etc.
Experience with J2EE application servers, preferably BEA Weblogic
Experience working with Eclipse IDE and Apache Tomcat
Experience working with SVN and Maven in a continuous integration environment
Experience with unit and behavior driven testing frameworks
Experience in architecting and implementing multi-tiered web based systems
Proficient in SQL and RDBMs (Sybase, Oracle)
Proficient in UNIX
Proficient in XML and web-service related technologies, SOAP, XML Parsing, XPath and XSLT
Strong problem determination and trouble shooting skills
Demonstrated knowledge of Object-Oriented design including familiarity with design patterns and UML
Demonstrated ability to learn and apply new technologies as the need arise.
Excellent interpersonal and written & oral communication skills
Capable of working independently as well as in team environment.
Strong analytical and problem solving / trouble-shooting skills.
Education Requirements:
Bachelor degree in Computer Science or related technical field preferred
---------------------------------------------------------------
At OppenheimerFunds, we've built a winning organization through a partnership between the Company and our employees. This reciprocal relationship provides the Company with the means to be successful in our competitive industry, while ensuring OppenheimerFunds' employees have a true stake in the Company's future and the opportunity to build a rewarding career.
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.
Job 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
