Job Description :
Position : Mainframe Developer/Analyst
Location: Oakland, CA
Duration: 6+ Months Contract

Job Description

The mainframe developer/analyst position is in the Enterprise Application Services team which is responsible for the development and maintenance of several system wide University applications. The small team of developers is responsible for several back end transaction processes as well as data transformation for key interface files.
The back end transaction processes are written in COBOL batch jobs and IBM Data Stage ETL processes. COBOL batch jobs execute native DB2 functions and stored procedures. The IBM Data Stage ETL processes are used to transform the file format as well as specific data elements.
The incoming data sets into the COBOL batch jobs and IBM Data Stage ETL processes are generated from a new source system. You will analyze the new data sets to confirm adherence to specific business rules and perform data validation by using comparison tools. Further batch processing will post the new data sets to the system, comparison tools will be used to compare the new data sets with existing data sets to determine any discrepancies. Analysis is performed to determine the root cause of the discrepancies.
Responsible for developing unit, regression and acceptance testing scenarios and plans and document the results of the scenarios. Perform project management functions by ensuring team members are on track with their deliverables.

Required Qualifications

Minimum of 5 years experience, 2 of those years should be recent experience in analysis of complex data sets that support critical business functions. Ability to operate in the Mainframe DB2 environment using TSO/ISPF and SQL.
The candidate should also be knowledgeable in ETL concepts and have experience in IBM Data Stage.
Demonstrates an understanding of complex, data-driven application development and strong analytical skills with the ability to draw conclusions in a logical, systematic way.
Excellent oral and written communication skills to effectively convey and explain technical information to non-technical customers and to draft clear and concise technical specifications.
Demonstrates the ability to operate under general direction, develop creative solutions to problems and tackle issues in a self-motivated manner in line with the direction of the team and the organization.
Collaborate with core team members, subject matter experts and business partners. Excellent interpersonal skills as demonstrated by the ability to interact with others in a consistently positive manner, exercising discretion and tact.
Flexibility to provide support for installed systems outside of normal business hours.

Published Description:
The mainframe developer/analyst position is in the Enterprise Application Services team which is responsible for the development and maintenance of several system wide University applications. The small team of developers is responsible for several back end transaction processes as well as data transformation for key interface files.
The back end transaction processes are written in COBOL batch jobs and IBM Data Stage ETL processes. COBOL batch jobs execute native DB2 functions and stored procedures. The IBM Data Stage ETL processes are used to transform the file format as well as specific data elements.
The incoming data sets into the COBOL batch jobs and IBM Data Stage ETL processes are generated from a new source system. You will analyze the new data sets to confirm adherence to specific business rules and perform data validation by using comparison tools. Further batch processing will post the new data sets to the system, comparison tools will be used to compare the new data sets with existing data sets to determine any discrepancies. Analysis is performed to determine the root cause of the discrepancies.
Responsible for developing unit, regression and acceptance testing scenarios and plans and document the results of the scenarios. Perform project management functions by ensuring team members are on track with their deliverables.

Required Qualifications

Minimum of 5 years experience, 2 of those years should be recent experience in analysis of complex data sets that support critical business functions.
Ability to operate in the Mainframe DB2 environment using TSO/ISPF and SQL.
The candidate should also be knowledgeable in ETL concepts and have experience in IBM Data Stage.

Demonstrates an understanding of complex, data-driven application development and strong analytical skills with the ability to draw conclusions in a logical, systematic way.
Excellent oral and written communication skills to effectively convey and explain technical information to non-technical customers and to draft clear and concise technical specifications.
Demonstrates the ability to operate under general direction, develop creative solutions to problems and tackle issues in a self-motivated manner in line with the direction of the team and the organization.
Collaborate with core team members, subject matter experts and business partners. Excellent interpersonal skills as demonstrated by the ability to interact with others in a consistently positive manner, exercising discretion and tact.
Flexibility to provide support for installed systems outside of normal business hours.