Job Opening - Civil Service
IT Technical Associate-DATA ARCHITECT
Classification specification from State of Illinois
- Code No.: 5031
- Probation Period: 12 Months
- Class Title: IT Technical Associate
- Effective Date: February 06 2013
- Occupational Area: Professional
- Promotional Line: None
- Work Area: AIMS (Administrative Information Management Systems)
- Application Deadline: March 01 2013
- Complete State Universities Civil Service System job specification
Additional Information:Completed application, transcript(s), and resume are due no later than 4:30pm on Friday, March 1st, 2013 in the WIU Human Resource Office, Sherman Hall 105, Macomb, Illinois, 61455. (309)298-1971. Preference may be given to Illinois Residents.
Additional Required Qualifications:
*Must have experience with Extract, Transform and Load tools (Pentaho or Ab Initio preferred).
-6 months of experience using Pentaho, Ab Initio, Data Stage, Oracle Warehouse builder, Informatica, or other ETL tool.
*Must be able to write and tune SQL statements.
-1 year of professional experience writing or maintaining SQL code.
*Have demonstrable knowledge of relational database design and normalization processes.
-1 year of professional experience using DB2, Oracle, Teradata, SQL Server, Informix, or other RDBMS.
*Also required is hands-on experience with software engineering processes and methodologies.
-1 year of professional experience in software development lifecycle
*Should know Relational Database Management Systems (RDBMS) concepts, DB2 LUW preferred.
-1 years of professional experience using DB2, Oracle, Teradata, SQL Server, Informix, or other RDBMS.
*Should be familiar with both normalized and dimensional data models.
-1 year using DB2, Oracle, Teradata, SQL Server, Informix, or other RDBMS.
*Familiarity with code repository check-in and check-out procedures.
-1 year professional experience in software development lifecycle
*Experience with Business Intelligence (BI) solutions and Linux is a plus.
-Any professional experience beneficial
*Experience with data modeling and OLAP cubes huge plus.
-Any professional experience beneficial
The starting salary for this position is $3,242.00/month
Civil Service Employment – Information & Instructions
Complete a Job Application online. Please include all employment history on your application.
For an application to be considered complete, supplemental application materials, which may include transcripts, licenses, certifications, and/or a copy of the DD214 (if applicable), should be submitted to the Human Resources Office.
Applicants with completed applications will be contacted to set-up an application evaluation appointment. During the application evaluation your qualifications will be reviewed. If you meet the minimum acceptable qualifications, an appointment for testing will be scheduled for a later date. If you have any questions regarding this process, you may call the Examination Division at (309) 298-1971.
If you believe that you may require a reasonable accommodation during the application evaluation or examination(s), please notify the Human Resource Office at (309) 298-1971, prior to date of the evaluation or examination appointment.
Applications will be reviewed and if you qualify you will be called to set-up an appointment for testing as soon as possible. If you have any questions in regard to this process, you may call the Examination Division at (309) 298-1971.
If you believe that you may require a reasonable accommodation during the application evaluation or testing process, please notify the Human Resource Office at (309) 298-1971, prior to date needed so that appropriate arrangements can be made.
Supplemental application materials can be delivered in person or sent to:
Human Resources Office
Sherman Hall Room 105
1 University Circle
Macomb, IL 61455
Fax: (309) 298-2300
Open: Monday - Friday 8:00 a.m. 4:30 p.m.
Western Illinois University is an Affirmative Action and Equal Opportunity employer with a strong commitment to diversity and a non-discrimination policy that includes sex, race, color, sexual orientation, gender identity and gender expression, religion, age, marital status, national origin, disability, or veteran status.