Bachelor's Degree in a field of study related to technology or finance. Work experience can substitute on a year for year basis for the degree.
Experience
Candidate MUST have a minimum of 7 years of experience in multiple IT areas and 2-3 years of relevant architecture experience. Candidate 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, chaining jobs between predecessors and dependents, and column delimited flat text file structures are required for this position. Candidates with resumes reflecting experience with Cool GEN, COBOL, DB2 z/OS, and DB2
Primary Job Duties/ Tasks
The submitted candidate must be able to perform the following duties and/or tasks. Duties of the selected candidate will include, but not be limited to: 1. Analyze and document existing computing assets, including technical specifications and established business rules. 2. Assist with debugging and trouble shooting existing processes when needed. a. Diagnose and resolve issues after performing root cause analysis. 3. Provide guidance and assist with remediating and upgrading legacy assets. a. Coordinate with business analysts, other developers, and products owners to remediate to the new state-wide accounting system. b. Coordinate with database administrators in analyzing and remediating existing data structures. 4. Participate in code and design reviews to ensure quality and performance. 5. Perform knowledge transfer with technical staff of the office of the Comptroller. 6. Read and document Mainframe FOCUS queries and convert them to T-SQL queries. 7. Convert Focus mainframe programs using mainframe flat files as a data source to use database tables instead.
Job Specific Knowledge, Skills, and Abilities
FOCUS:
1. Experience with master files. 2. Experience with complex queries involving multiple data sources. 3. Experience with reading, creating, and updating flat files. 4. Experience with multiple include statements.
JCL:
5. Reading, editing, and creating JCL jobs. 6. Experience with reading, creating, and editing flat files. 7. Experience with running multiple programs from single JCL jobs. 8. Experience with multiple RC Types 9. Experience with scheduling JCL jobs as well as reviewing executed jobs. 10. Experience with submitting ad-hoc jobs.
Applications Development KSAs:
11. Knowledge of the SCRUM Framework. 12. Knowledge of financial systems such as an ERP. 13. Experience with Entity Relationship Diagrams. 14. Experience with documenting and communicating technical requirements. 15. Experience in coordinating with Business Analysts to capture business requirements. 16. Ability to bridge the gap between technical and business language.