Overview
Bachelor's Degree in a field of technology or finance. Work experience can substitute on a year-for-year basis for the degree.
7 years of experience in multiple IT areas and 2–3 years of relevant architecture experience are required. Must have advanced to expert level knowledge and understanding of architecture, applications systems design and integration, specifically Tibco Mainframe FOCUS and JCL, mainframe batch schedulers, and related concepts such as chaining jobs between predecessors and dependents and column-delimited flat text file structures. Candidates with resumes reflecting experience with Cool GEN, COBOL, DB2 z/OS, and DB2 Database will be given preference.
Primary Job Duties
The submitted candidate must be able to perform the following duties and/or tasks. Duties of the selected candidate will include, but are not limited to:
- Analyze and document existing computing assets, including technical specifications and established business rules.
- Assist with debugging and troubleshooting existing processes when needed. Diagnose and resolve issues after performing root cause analysis.
- Provide guidance and assist with remediating and upgrading legacy assets. Coordinate with business analysts, other developers, and product owners to remediate to the new state-wide accounting system. Coordinate with database administrators in analyzing and remediating existing data structures.
- Participate in code and design reviews to ensure quality and performance.
- Perform knowledge transfer with technical staff of the office of the Comptroller.
- Read and document Mainframe FOCUS queries and convert them to T-SQL queries.
- Convert Focus mainframe programs using mainframe flat files as a data source to use database tables instead.
Job Specific Knowledge, Skills, and Abilities (KSAs)
FOCUS:
- Experience with master files.
- Experience with complex queries involving multiple data sources.
- Experience with reading, creating, and updating flat files.
- Experience with multiple include statements.
JCL:
- Reading, editing, and creating JCL jobs.
- Experience with reading, creating, and editing flat files.
- Experience with running multiple programs from single JCL jobs.
- Experience with multiple RC types and scheduling JCL jobs as well as reviewing executed jobs.
- Experience with submitting ad-hoc jobs.
Applications Development KSAs:
- Knowledge of the SCRUM Framework.
- Knowledge of financial systems such as an ERP.
- Experience with Entity Relationship Diagrams.
- Experience with documenting and communicating technical requirements.
- Experience in coordinating with Business Analysts to capture business requirements.
- Ability to bridge the gap between technical and business language.
General Knowledge, Skills, and Abilities (KSAs)
The submitted candidate must be able to apply common knowledge, skills, and abilities in the following areas:
- Communication: Ability to clearly convey information, in both written and verbal formats, to individuals or groups in a wide variety of settings. Must have the ability to effectively listen and process information provided by others.
- Customer Service: Works well with clients and customers. Able to assess needs, provide information or assistance to satisfy expectations or resolve a problem.
- Decision Making: Makes sound, well-informed, and objective decisions.
- Flexibility: Open to change, new processes or process improvements, and new information. Adapts in response to new information, changing conditions, or obstacles; comfortable receiving and giving constructive criticism and maintaining effective work relationships.
- Interpersonal: Shows friendliness, courtesy, understanding, and politeness to others.
- Leadership: Motivates, encourages, and challenges others; adapts leadership styles as appropriate.
- Problem Solving: Identifies, evaluates, and uses sound judgment to generate and evaluate alternative actions and make recommendations accordingly.
- Team Building: Encourages, inspires, and guides others toward accomplishing the common goal.