UCSD Home Page  IT Jobs @ UCSD

UC San Diego

Administrative Computing & Telecommunications  




Apply via Email
UCSD Benefits
UCSD Benefits
Applications Programmer/Analyst
Job Number 45820

Thank you for your interest in the Applications Programmer/Analyst 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 analysis, design, development and implementation of Data Warehouse ETL processes and methodologies using INFORMATICA, DB2 UDB and UNIX along with other tools and technologies. Specific duties could include the complete detail responsibility for one or more Data Warehouse sub-systems (e.g., student, financial). Duties include giving direction and assistance to other personnel on assigned projects, assisting campus departments with their Data Warehouse-based information needs, providing support for production systems. Development and support is performed on high-end server systems/databases using cutting edge technologies.

Duties
  • Complete detail responsibility for one or more Data Warehouse sub-systems (e.g., student, financial)
  • Give direction and assistance to other personnel on assigned projects
  • Assist campus departments with their Data Warehouse-based information needs
  • Provide support for production systems

Qualifications:

  • Technical knowledge in data warehouse tools and technologies such as INFORMATICA, SQL, DB2 UDB and Unix. Understanding on web technologies such as XML, XSL and Perl.
  • Proficiency in system analysis, design, development and implementation of Data Warehouse solutions.
  • Ability to think independently to provide solutions and procedures for ETL processes.
  • Ability to perform 24x7 production support activities, proven ability in production problem resolution.
  • Experience in understanding user requirements and ability to work in team environment to accomplish project goals.
  • Adaptable to new technologies and procedures. Experience with Autosys, Zena, Toad, Aqua Data and Control Center a plus.
Special condition of employment:
  • Background check required