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 Form using one of the methods below.

All application materials are due in Human Resources by the application deadline. Application materials may include transcripts, licenses, and certifications. Please include all employment history on your application.

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.

All 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 – 4:30