Senior COBOL / Mainframe Data Analyst

All IT Solutions is a technology and workforce solutions company serving government and commercial organizations. The company is seeking a Senior COBOL / Mainframe Analyst to support an enterprise-wide Legacy Replacement program through data analysis, VSAM-to-SQL mapping, conversion, validation, and data quality initiatives.

Responsibilities:

• The Senior Data Analyst will primarily be responsible for detailed field level analysis, metadata analysis, profiling, and mapping of VSAM files into relational/dimensional SQL tables as well as conversion/validation efforts as part of an enterprise-wide Legacy Replacement program
• The Senior Data Analyst must be available to work a minimum of 40 hours per week and will be subject to onsite and /or remote work in accordance with our client policies in effect for the duration of the project
• Develop complex SQL data validations based on STTMs and target Data Models
• Provide technical and analytical support to our client data integrity and quality initiatives
• Collaborate with SME’s and technical leads in identifying and addressing data quality gaps
• Work with IT partners to remediate identified gaps using both manual and automated solutions
• Support processes that proactively detect, correct, and prevent invalid data values

Requirements:

• Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments
• Experience creating data dictionary documentation with business terms, valid values, and definitions
• Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases
• Minimum of three (3) years of recent experience developing applications using IBM DataStage ETL
• Experience extracting field references and calculated data from COBOL programs
• Experience with BMC Control-M workload automation software
• Experience with GIT version control software
• Minimum of three (3) years of recent experience with Pension Administration systems
• Strong SQL knowledge working with complex queries and stored procedures
• Proficiency in SSRS reports' development
• Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose a suitable solution that adheres to the team's methodology
• Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server
• Proficiency in mainframe applications encompassing COBOL, CICS and DB2Understanding of data structures and their relationship to ETL applications
• Ability to develop complex SQL data validations based on STTMs and target Data Models
• Excellent analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities