ETL Developer
University of Arizona - Tucson, AZ

This job posting is no longer available on University of Arizona. Find similar jobs:ETL Developer jobs - University of Arizona jobs

Department

9501-UITS-Computing and Information Technology

College/Division

University Information Technology Services

Posted Rate of Pay

DOE

Exempt / Non-Exempt

Exempt

Category

Appointed: Professional

Departmental Contact

Monica Tacconi

Departmental Contact Phone

520-626-0965

Departmental Contact Email

tacconi@email.arizona.edu

Job Open Date

12-07-2012

Job Close Date

Open Until Filled

Review begins on (Continues until position filled)

12-14-2012

Benefits Eligible

Yes

Full Time/Part Time

Full Time

Days and Schedule to be Worked

Number of Hours Worked per Week

Limited to current UA employees only

No

Documents required to be attached electronically with this application

Letter of Interest Resume

Documents that may be attached electronically or mailed directly to department per instructions below

Additional application instructions (include instructions for submission)

Position Summary

The Enterprise Information and Analytics team within the University of Arizona is looking for an experienced IBM DataStage/Ascential developer to support the PeopleSoft EPM Data Warehouse. The Enterprise Data Warehouse (using OBIEE+ and Fusion Intelligence) combines data from various transaction systems including PeopleSoft HCM, PeopleSoft Campus Solutions, Kuali KFS, and Kuali Coeus. The person working in this position will primarily focus on designing, developing and implementing the ETL processes for the PeopleSoft and Kuali contents of the data warehouse. This person will be paired with a subject matter expert to deliver all the data warehousing and business intelligence functionality to support the implementation of new modules. Outstanding UA benefits include health, dental, and vision insurance plans; life insurance and disability programs; paid vacation, sick leave, and holidays; UA/ASU/NAU tuition reduction for the employee and qualified family members; state and optional retirement plans; access to UA recreation and cultural activities; and more! whyUA? http://employment.arizona.edu/

Duties and Responsibilities

  • Writing DataStage 8.x jobs for the new EPM warehouse; * Creating and reviewing dimensional data models; * Acting as an ETL consultant for other areas or teams; * Providing input and support for upgrades, capacity planning, and "best practices" * Possibly gathering and analyzing business, data and reporting requirements, plus documentation and specification of requirements; * Varied work hours, which may include evenings, weekends, and holidays.
Arizona Board of Regents Minimum Qualifications

Not applicable for this position.

Additional Minimum Qualifications

  • Bachelor's degree in Computer Science or related field AND two years of experience developing data warehouse ETL jobs with IBM/Ascential DataStage; OR, Any equivalent combination of experience, training and/or education; * Two years or more of Oracle RDBMS; * Work experience in Human Resources, financial and/or student system fields; * Experience in using a scheduling tool like Autosys or Control-M to schedule Datastage Jobs.
Preferred Qualifications

  • Two or more years of experience with IBM/Ascential DataStage * Significant experience creating DataStage 8.x jobs * Experience with IBM Metadata Workbench and Oracle Business Intelligence Enterprise Edition (previously Siebel Analytics) * Strong technical understanding of ERP data structures and how they relate to establishing data warehousing, data management, and analytic architectures * Ability to develop business requirements and translate them into a data warehouse dimensional model * Effective communication skills * Ability to multi-task and meet negotiated timelines * Demonstrated ability to work independently, as well as function as a team member
Pre-employment Screening Requirements

The University of Arizona conducts pre-employment screening for all positions, which includes a criminal background check, verification of academic credentials, licenses, certifications, and work history. In addition, a check of names and identification documents is conducted on all new employees to ensure they are legally authorized to work in the United States.

What kind of criminal background check is required for this position?

This position is security sensitive due to title or department and requires a finger-print criminal background check

Supplemental Pre-Employment Screening

None

Job Category

Computer, Engineering and Technical

Departmental Home Page

Click Here

Quick Link

www.uacareertrack.com/applicants/Central?quickFind=206181

About this company
156 reviews