SQL Data Remediation and COBOL conversion - Hybrid

Codetech • Pearl River, NY

2d • Hybrid

About The Position

The Senior Software Analyst – Data Remediation & Legacy System Conversion will support a critical modernization initiative by developing data remediation programs and SQL scripts for the project’s conversion phase. The role also analyzes and documents business rules and embedded logic in COBOL and other platform-specific code on a long-standing mainframe system. Its documentation will help system integrators design and execute the migration of historical data to modern platforms. The role calls for strong knowledge of legacy technologies, analytical skills, and the ability to communicate complex technical concepts to technical and non-technical stakeholders.

Requirements

• Advanced proficiency in SQL, including stored procedures.
• Ability to produce clear, accurate technical documentation for system integrators and project stakeholders.
• Experience with SAR View, VSAM, DFSORT, and IDCAMS.
• Extensive experience supporting and enhancing long-standing mainframe systems in production environments.
• In-depth knowledge of COBOL and ability to interpret and document legacy system logic.
• Proficiency with QMF reporting, SPUFI, File Manager, and CA Intertest.
• Expertise in data mapping and functional workflow migration.
• Solid understanding of system conversion and data migration from legacy platforms to modern architectures.
• Strong analytical and problem-solving skills, including the ability to analyze complex legacy code and extract business rules.
• Strong hands-on experience with COBOL 6.4, CICS TS, and DB2 (v12.1).

Nice To Haves

• Learning agility and ability to quickly adopt new technologies and methodologies.
• Experience with CICS Web Interface, web services, and API management.
• Experience with MQ or similar messaging and queuing technologies.
• Experience with the SCANA application, including development of integration modules for work management systems.
• Experience with utility work management workflows or other utility workflows.
• Familiarity with additional programming languages such as Java, C++, or Python.
• Proficiency in PowerPoint and Visio for technical documentation and presentations.
• Working knowledge of Agile development methodologies and iterative delivery practices.

Responsibilities

• Develop data remediation programs and SQL scripts for the conversion phase of the project.
• Analyze and document business rules and embedded logic in COBOL and other platform-specific legacy code.
• Produce clear, comprehensive technical documentation to help system integrators design and execute historical data migration.
• Analyze complex legacy code and extract business rules.
• Support and enhance long-standing mainframe systems in production environments.
• Perform data mapping and support functional workflow migration.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed