Job Details:

Position: Data Analyst with ETL, COBOL, DB2 experience

Issued by:- Department of Social and Health Services, WA

Req. ID:- 1559-549

Duration:- Long Term

Location:- 724 Quince Street SE, Olympia, Washington.

Senior level staff must possess a minimum of 5 years’ experience within the last 8 years in the following skills and knowledge areas.

Please fill highlighted part

Candidate Experience

Experience Required



Experience developing in a system that supports the determination of eligibility for human services programs (e.g. TANF, Medicaid, Food Assistance)


Reverse engineering ETL (Extract, Transform, and Load) processes in COBOL to migrate to Infosphere DataStage.


Designing, developing, and testing ETL processes in COBOL (on z/OS and Windows environments) and InfoSphere DataStage.


Experience with IBM Cognos Impromptu applications and migration activities to IBM Cognos 10.


Experience with public sector Federal Reporting and requirements.


Experience with mainframes and skilled in the following: COBOL, DB2, IMS, and JCL


Experience with Windows and skilled in the following: VisualAge COBOL, DB2LUW, MS Access, Syncsort, and SQLDBX


Experience with ETL/Reporting and skilled in the following: Infosphere DataStage 9.1, IBM Cognos Report Studio 10.1, IBM Cognos Framework Manager 10.1 and IBM Cognos Impromptu 7.3


Experience analyzing and evaluating proposed changes and estimating work effort to implement those changes

Desired Skills:

•Knowledge of the Rational suite of tools such as Clear Quest, Clear Case and Requisite ProBasic understanding and working knowledge of Cypress Archival and Retrieval.
•Mentoring other workers

•Familiar with Project Manager practices and principles with a certificate in Project Management highly desired

•Strong written and verbal skills and ability to present complicated information to a wide variety of audiences

•Proficient with MS Office tools
•Experience with Data Warehousing and Business Intelligence projects