Mainframe Developer

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

Our client, a leading financial services provider, is seeking a Mainframe Developer to join their team. The Mainframe Developer is responsible for designing and building relational database models and defining data requirements to meet the business needs.

Core Responsibilities

• Partner with business stakeholders, product owners, SMEs, analysts, and development teams to understand business processes, data requirements, source systems, data mappings, and data consumption needs.
• Translate business requirements, processes, and rules into logical and physical data models, source‑to‑target mappings, and data integration specifications.
• Develop logical and physical database models.
• Write scripts and commands for data manipulation.
• Design and govern reusable test data patterns, provisioning approaches, masking strategies, synthetic data solutions, and environment refresh processes.
• Define and implement test data strategies that support functional, regression, integration, performance, automation, and modernization testing needs.
• Document data models, test data design patterns, source‑to‑target mappings, provisioning processes, standards, and best practices for repeatable enterprise use.
• Ensure test data solutions comply with data privacy, protection, retention, classification, and regulatory requirements for sensitive customer and financial data.

Required Skills / Experience (Must‑Haves)

• COBOL
• CICS
• DB2
• DB2 utilities
• SQL
• JCL
• MVS Utilities
• Experience doing production support
• Use of CA7 scheduling tool
• Analytical skills to design the to‑be system based on as‑is analysis
• Use of Jira

Preferred Skills / Experience (Nice‑to‑Haves)

• Banking domain knowledge
• Strong experience in data analysis, data architecture, database design, test data management, quality engineering, or software delivery
• Proficiency writing and optimizing SQL queries for data discovery, validation, reconciliation, and troubleshooting
• Experience analyzing relational databases, mainframe data structures, files, batch jobs, APIs, and downstream data consumers

Key Competencies & Behaviors

• Strong analytical and problem‑solving skills across complex, interconnected systems.
• Collaboration across product, engineering, quality, architecture, and operations teams.
• Data governance and compliance mindset.
• Clear documentation of data models, mappings, standards, and best practices for repeatable enterprise use.
• Ability to build technical relationships and lead design efforts that deliver innovative solutions.

Work Environment

• Location: Hybrid in Hopkins, Minnesota (Onsite 3+ days per week – 2 remote)

Compensation & Benefits

• Pay Range: $44.00–$63.00 per hour (approximate); final compensation may vary based on factors including background, knowledge, skills, and location. We comply with local wage minimums.
• Medical, Dental & Vision Insurance Plans
• Employee‑Owned Profit Sharing (ESOP)
• 401(k) offered