Mainframe Developer

Job Summary

About the role

The Mainframe Developer is responsible for designing and building relational database models and defining data requirements to meet the business needs. They 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.

Responsibilities

• Translate business requirements, processes, and rules into logical and physical data models, source-to-target mappings, and data integration specifications
• 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

Requirements

• COBOL
• CICS
• DB2
• DB2 utilities
• SQL
• JCL
• MVS Utilities
• Experience doing Production Support
• Use of CA7 Scheduling tool
• Need to be able to do analysis on the as-is and come up with design of the to be
• Use of Jira

Skills

• 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
• Able to build technical relationships and lead design efforts that deliver innovative solutions

Work Environment

Location: Hybrid in Hopkins, Minnesota
Hybrid: Onsite 3+ days per week - 2 remote

Compensation & Benefits

Pay Range: The approximate pay range for this position is between $44.00 and $63.00 per hour. Please note that the pay range provided is a good faith estimate. Final compensation may vary based on factors including but not limited to background, knowledge, skills, and location.
We comply with local wage minimums.
Medical, Dental, & Vision Insurance Plans
Employee-Owned Profit Sharing (ESOP)
401K offered

About KellyMitchell

About KellyMitchell: At KellyMitchell, our culture is world class. We're movers and shakers! We don't mind a bit of friendly competition, and we reward hard work with unlimited potential for growth. This is an exciting opportunity to join a company known for innovative solutions and unsurpassed customer service. We're passionate about helping companies solve their biggest IT staffing & project solutions challenges. As an employee-owned, women-led organization serving Fortune 500 companies nationwide, we deliver expert service at a moment's notice.