Assist and lead data warehouse initiatives.
Duties and Responsibilities:
- Serves as one of the subject matter experts of OBIEE and Informatica ETL.
- Models data warehouse tables.
- Leads Data warehouse initiatives.
- Configures and administers the OBIEE, Informatica and DAC repositories.
- Creates OBIEE reports of elevated complexity.
- Optimizes performance of processes and queries running on Oracle Database engine.
- Assists IT-Ops during the OBIEE/Informatica/DAC installation and migration.
- Implements Enhancements/bug fixes (development and support for existing functionality).
- Communicates and coordinates with other teams.
- Devises or modifies procedures to solve complex problems considering system capacity and limitations, operating time and form of desired results.
- Prepares detailed specifications from which programs will be written.
- Responsible for program design, coding, testing, debugging and documentation.
- Instructs, directs and checks the work of other system analysis and programming personnel.
- Responsible for quality assurance review.
- Responsible for directing and monitoring the work of team members.
- May be responsible for project completion and user satisfaction.
- Performs all other duties and projects assigned.
- Proactively communicates with all departments and other teams.
Supervisory Responsibilities:
- Mentors junior OBIEE and Informatica developers.
Minimum Qualifications:
- Bachelor's degree in Computer Science, a related field or equivalent work experience required.
- 5 + years of data warehousing experience
Requirements and General Skills:
- Excellent technical analysis, planning and problem solving skills..
- Ability to work in Agile team environment.
- Must be flexible, motivated and independent.
- Excellent communication and presentation skills.
- Personal leadership skills with successful track record of leading team to accomplish difficult objectives.
- Interacts with customers (internal and external) at all levels or organization.
- Proactively partners with other departments to provide information and feedback, analyze reports for continuous improvement and resolve issues.
- Occasional local and regional travel may be required.
- Knowledge of all phases of application systems analysis, design and programming activities.
- Has full technical knowledge of all phases of applications systems analysis and programming.
- Has good understanding of the business or function for which applications are designed.
- Must have legal right to work in the U.S.
Technical Skills:
- Ability to work/working knowledge in Siebel 8.
- 5+ years of ETL into OBIEE using Informatica, DAC.
- Experience with OBIEE 12c.
- 4+ years of experience with Informatica 9.
- 3+ years of performance optimization of OBIEE queries and processes on Oracle 11g Database.
- Experience with performance optimization of OBIEE queries and processes on Oracle 12c Database a plus.
- 5+ years of experience with Siebel Analytics.
- 3+ years of relevant consulting experience.
- Working knowledge of relational databases (Oracle 12c a plus), and object oriented programming languages.
- Hands on experience with server installation and administration of OBIEE 12c or OBIEE 11g.