Sr Mainframe Developer / Engineer
Job Description
Vytwo is seeking a Sr Mainframe Developer / Engineer to support banking-focused work in a hybrid role based in Dallas, TX. You will help turn business needs into robust data and integration solutions, with a strong focus on test data strategy, data quality validation, and mainframe production support.
What you’ll do
- Work 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 rules into logical and physical data models, source-to-target mappings, and data integration specifications.
- Define and implement test data strategies for functional, regression, integration, performance, automation, and modernization testing.
- Design and govern reusable test data patterns, including test data provisioning approaches, masking strategies, synthetic data solutions, and environment refresh processes.
- Apply data modeling fundamentals, including entities, attributes, relationships, schemas, primary and foreign keys, indexes, and constraints.
- Interpret Entity Relationship Diagrams, database schemas, data dictionaries, and end-to-end data flow diagrams to identify data dependencies and business impact.
- Conduct data discovery and analysis across databases, tables, files, and source systems using SQL, Easytrieve, and other query and extraction tools.
- Validate data quality, integrity, consistency, and accuracy through reconciliation results, transformation logic, and business rule checks across systems.
- Support analysis of data movement patterns across real-time and batch processing, including event-driven approaches, APIs, messaging queues, pipelines, and file-based interfaces.
- Collaborate with architecture, development, testing, and operational teams for impact assessment, problem resolution, and test automation enablement.
- Ensure test data solutions align with data privacy, protection, retention, classification, and regulatory requirements for sensitive customer and financial data.
- Document data models, test data design patterns, source-to-target mappings, provisioning processes, and standards for repeatable enterprise use.
Requirements
- Banking experience is required.
- 10+ years of experience is required.
- Strong hands-on skills with COBOL, CICS, DB2, DB2 utilities, SQL, JCL, and MVS utilities, plus experience with production support.
- Experience using CA7 scheduling tool.
- Ability to assess the as-is and propose a to-be design.
- Use of Jira.
- Bachelor’s degree in Computer Science, Information Technology, Data Management, Engineering, or related field, or equivalent practical experience.
- Strong experience across 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.
- Ability to translate business rules and system behavior into data requirements, mappings, and test data needs.
- Strong communication skills for explaining complex data concepts to technical and non-technical stakeholders.
- Experience working in Agile delivery environments and collaborating across product, engineering, quality, architecture, and operations teams.
Technologies
- COBOL, CICS, DB2, SQL, JCL, MVS Utilities, CA7, Jira
- SQL JCL, Easytrieve, SPUFI, DB2 utilities
- SQL Server, Oracle, PostgreSQL
Benefits
- Flexible work from home options available.
Nice to have
- 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.
Banking domain knowledge (preferred)
- Experience working within banking, payments, credit card, deposits, lending, or customer/account data domains.
- Understanding of core banking platforms, transaction processing flows, customer and account hierarchies, and regulatory reporting requirements.
- Ability to trace, analyze, and map data across upstream and downstream applications, databases, files, APIs, and enterprise data platforms.
- Familiarity with batch and real-time processing architectures and data movement across interconnected banking systems.
- Experience with enterprise test data management platforms, data masking, synthetic data generation, data subsetting, and automated data provisioning.
- Understanding of data governance, data classification, retention requirements, and regulations for sensitive customer and financial data (storage, transmission, and protection).