|
Data Warehouse Specialist
Job Number 45588
Thank you for your interest in the Data Warehouse Specialist position. To receive full consideration for this position, please include your answers to the
following questions when you apply.
- Describe your experience with ETL tool 'INFORMATICA' or any other ETL tool such as Business Objects Data Integrator and DataStage.
- Explain your skill level with DB2 UDB and SQL. If you do not have experience with DB2, describe your skill level with ORACLE and SQL Server.
- Describe your expertise in Data Warehouse, Unix Shell Scripting, Perl and production problem resolution.
Please send your responses to the above questions and a copy of your resume to actjobs@ucsd.edu.
Imagine working on a campus
ranked among the top leading research universities in the United States.
Imagine working with a team of IT professionals who develop the best technology
innovations in higher education. UCSD's commitment to excellence has resulted in
national recognition for
both our technology solutions and our management philosophy. Individual integrity, mutual respect and trust comprise the
foundation for our success.
Become part of UCSD’s IT Infrastructure team, a leading edge group who is responsible for supporting over 60,000 on-campus users. This team is consistently held up as a
model of how to implement advanced data warehouse methodologies and support data warehouse technology to other university teams.
This position is responsible for researching, recommending, mentoring internal staff and potentially implementing ETL processes and
methodologies using INFORMATICA, DB2 UDB and UNIX along with other and methodologies to support a highly diverse Data Warehouse
environment. In addition, duties would also include developing, implementing and maintaining server-based Data Warehouse systems.
Development and support is performed on high-end server systems using modern relational and data warehouse DBMS software.
Duties
- Complete detail responsibility for one or more Data Warehouse sub-systems (e.g., student)
- Give direction and assistance to other personnel on assigned projects
- Assist campus departments with their data warehouse-based information needs
- Provide presentations and support for production systems
Qualifications:
- In-depth understanding of data warehouse and business intelligence tools, technologies, architecture,
and trends in data and information management
- Proven ability to leverage extensive expertise in data warehousing and business intelligence to
develop 'best in class' strategic vision for data management
- Proficiency in business analysis, event modeling, data modeling including dimensional modeling,
logical and physical database design, database optimization, and load strategy design including
transformation, loading and cleansing
- Extensive knowledge of INFORMATICA, SQL and DB2UDB
- Ability to think independently to provide solutions and procedures to central administrative databases
- Proven project leadership ability and experience in directing other technical staff in the development
and implementation of complex computerized databases
- Minimum of six years of successful data warehousing project experience
- Experience in providing training and support to other technical staff. Strong facilitation,
influencing and team consensus-building skills
- Knowledge and experience with Data Warehouse ETL tools such as Informatica with a minimum of two years required
Special condition of employment:
- Background check required
|
|
