Hybrid Mainframe Developer - Data Modeling & SQL Expert

KellyMitchell Group; Hopkins (MN); Hybrid; USD 60,614 - 86,788; Full time

Benefits offered by this job

Medical, Dental & Vision Insurance

Employee-Owned Profit Sharing (ESOP)

401(k) offered

Job summary

KellyMitchell Group seeks a Mainframe Developer to join a leading financial services client in Hopkins, MN. You will design and build relational database models, define data requirements, and collaborate with stakeholders to meet business needs.

Responsibilities include translating requirements into data models, writing data manipulation scripts, establishing test data strategies, and ensuring compliance with privacy and regulatory standards while supporting production and modernization efforts.

Qualifications

• Must have COBOL, CICS, DB2 and SQL experience.
• Experience with JCL and MVS Utilities is required.
• Proven production support experience and CA7 scheduling familiarity.
• Analytical skills to design effective to-be systems from as-is data.

Responsibilities

• Partner with stakeholders to understand processes, data requirements, and data consumption needs.
• Translate requirements into logical/physical data models and mappings.
• Develop logical and physical database models and scripts for data manipulation.
• Design reusable test data patterns and provisioning strategies.
• Define test data strategies for multiple testing types.
• Document models, mappings, provisioning steps, standards, and best practices.
• Ensure test data solutions comply with privacy, retention, and regulatory rules.

Skills

COBOL

CICS

DB2

DB2 utilities

SQL

JCL

MVS Utilities

Production support

CA7 scheduling

Jira

Analytical skills

Tools

Mainframe tooling

Job description

KellyMitchell Group seeks a Mainframe Developer to join a leading financial services client in Hopkins, MN. You will design and build relational database models, define data requirements, and collaborate with stakeholders to meet business needs.

Responsibilities include translating requirements into data models, writing data manipulation scripts, establishing test data strategies, and ensuring compliance with privacy and regulatory standards while supporting production and modernization efforts.