Employment Opportunities
Job Details

Job Description

The ETL developer will provide support in all aspects of the design, mapping, development and testing of data movement with emphasis on the Extract-Transform-Load (ETL) process. S/he will develop technical specifications based on the data model that was created by the Data Modeler. They will be responsible for contributing to the design, development, testing, implementation, maintenance, and documentation as well as upholding of ETL standards. S/he will utilize Informatica as the ETL tool primarily against Oracle as the back end database.

S/he is responsible for identifying and implementing data warehouse features affecting history, post or future dated updates and error handling that will be used to load and access all operational data store, data warehouse, and other data structures.

The individual(s) in this role work as a member of the Administrative Technologies-AIM team as well as university staff in support of business intelligence to support and promote data usage within the University community.

Qualifications

1. Bachelor's Degree
2. Two or more years ETL design/development experience (e.g. Informatica, DataStage)
3. Two or more years experience with job scheduling tools (e.g. UC4, Autosys, Ctrl-M, TWS).
4. Advance knowledge of PL/SQL.
5. Knowledge of relational and dimensional data models and Oracle databases
6. If this position is Security Sensitive or if you are subject to a criminal background investigation based on University policy, employment is contingent upon you passing a satisfactory criminal background investigation. You may not begin work until the criminal background investigation results have been received and cleared by Human Resources.

Salary

Commensurate with experience

Links

ISU Jobs

Contact Information

University/Agency	Illinois State University
Department/College	Illinois State University
Contact	Jill Smith
Phone Number
Address
Comments	For full consideration, the application and all supplemental information must be submitted on-line. Please complete the entire employment application including the education and work history background. Please do not put "see resume" in the duties and responsibilities section of the work history. This will be considered an incomplete application and incomplete applications will not be considered. The employment application (not resume/cover letter) will be reviewed to determine if applicant meets minimum qualifications. Please be complete in the duties and responsibilities section for each position listed. The Civil Service examination for this classification is a credentials assessment. No participation other than submission of applicant materials is required from applicants that qualify to take the exam. Copies of transcripts (may be unofficial) MUST be submitted in order to receive full consideration for this position. If applicable, DD214 may be sent to Jill Smith by fax to 309-438-0011, or sent to Human Resources, Campus Box 1300 Normal, IL 61790-1300. Please upload a cover letter, resume and a reference list of three business references with name/mailing address/title/phone number. The active register for this classification will be voided after September 25, 2015 or when the position is filled. Illinois State University is an Equal Opportunity Employer. Minority/Female/Disability/ Veteran. If you are an individual with a disability and need a reasonable accommodation under the Americans with Disabilities Act (ADA) or other state or federal law you may request an accommodation by contacting the Assistant Director, Employee Accommodations in the Office of Equal Opportunity, Ethics, and Access at 309-438-3383. If you are having difficulty accessing the system, please call Human Resources at (309) 438-8311.