Data Architect – Mainframe Migration & Modernization

London
1 day ago
Create job alert

Position: Data Architect – Mainframe Migration & Modernization
Location: London, UK (Hybrid-2/3 days a week)
6 months contract position

The Role

As a – Mainframe Data Architect with data migration expertise, you will be responsible for moving critical data off the mainframe with zero surprises. Your responsibilities include designing robust Change Data Capture (CDC) strategies, ensuring accurate data landing and transformation, creating optimized data models, and executing a seamless cutover process.

Your responsibilities: (Up to 10, Avoid repetition)

  • Design and implement CDC pipelines using IBM CDC tools or equivalents, including subscription management, bookmarks, and replay strategies.

  • Handle complex data encoding transformations, such as EBCDIC to UTF-8 and packed decimal conversions, with validation test suites.

  • Utilize migration tooling for schema conversion and downstream analytics (Glue, Athena, Redshift), with infrastructure-as-code (Terraform) and CI/CD (GitLab).

  • Plan and execute cutovers with dual-run validation, reconciliation, rollback strategies, and data governance controls (masking, encryption, IAM).

  • Develop observability dashboards for lag, throughput, error rates, and cost using CloudWatch/Grafana, with operational runbooks and alerting.

  • Ensure data quality through pre-migration validation tests and reconciliation against golden sources.

  • Apply domain-driven design principles to model bounded contexts and aggregate roots.

  • Architect event-driven systems using CDC as event streams, with replay and orchestration patterns

  • Translate Db2 schemas to target pipelines (Aurora Postgress preferred), including logical and physical data modelling, referential integrity, and denormalization decisions.

  • Build integration pipelines from Db2 to target pipelines (Aurora Postgress preferred) via Kafka/S3, ensuring idempotency, ordering, and reliable delivery semantics.

    Your Profile

    Essential skills/knowledge/experience: (Up to 10, Avoid repetition)

  • Change Data Capture: CDC design and operations (IBM, Precisely, or equivalent); subscription management, bookmarks, replay, backfill.

  • Db2 & z/OS knowledge: Db2 catalog, z/OS fundamentals, batch windows, performance considerations.

  • Relational modelling: Data modelling; normalization, indexing, partitioning; OLTP vs. analytics trade-offs.

  • Integration patterns: Kafka/ hands-on, CDC-to-target pipelines, UPSERT/MERGE logic; Python/SQL; strong troubleshooting.

  • Data quality mindset: Write validation tests before migration; golden-source reconciliation.

  • Logical data modelling: Entity-relationship diagrams, normalization (1NF through Boyce-Codd/BCNF), denormalization trade-offs; identify functional dependencies and anomalies.

  • Physical data modelling: Table design, partitioning strategies, indexes; SCD types; dimensional vs. transactional schemas; storage patterns for OLTP vs. analytics.

  • Normalization & design: Normalize to 3NF/BCNF for transactional systems; understand when to denormalize for queries; trade-offs between 3NF, Data Vault, and star schemas.

  • Domain-Driven Design: Bounded contexts and subdomains; aggregates and aggregate roots; entities vs. value objects; repository patterns; ubiquitous language.

  • Event-driven architecture: Domain events and contracts; CDC as event streams; idempotency and replay patterns; mapping Db2 transactions to event-driven architectures; saga orchestration.

  • CQRS patterns: Command/query separation; event sourcing and state reconstruction; eventual consistency, when CQRS is justified for mainframe migration vs. overkill.

  • Database internals: Index structures (B-tree, bitmap, etc.), query planning, partitioning strategies; how Db2 vs. PostgreSQL differ in storage and execution.

  • Data quality & validation: Designing test suites for schema conformance; referential integrity checks; sampling and reconciliation strategies.

    Desirable skills/knowledge/experience: (As applicable)

  • IBM zDIH patterns, zIIP tuning.

  • COBOL copybook/VSAM ingestion experience.

  • Postgress SQL Data Architecture, PostgreSQL/Aurora data modelling

Related Jobs

View all jobs

Mainframe DB2 System Specialist

Infrastructure Specialist

Data Architect

Data Architect

Data Architect

Azure Data Architect

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

What Hiring Managers Look for First in Cloud Computing Job Applications (UK Guide)

anding a job in cloud computing can be highly competitive — especially in the UK market where demand far outpaces supply in many segments. Whether you’re aiming for roles in Cloud Engineering, DevOps, Site Reliability, Cloud Architecture, Security, Data/Analytics, or Platform Operations, hiring managers screen applications quickly and with specific priorities in mind. Hiring managers don’t read every detail at first; they scan for critical signals in the first 10–20 seconds. These early signals determine whether your CV gets read more closely, whether your LinkedIn profile gets clicked, and whether you’re invited to interview. This guide breaks down, in practical terms, exactly what hiring managers look for first in cloud computing applications — and what you should emphasise in your CV, cover letter and portfolio to stand out on www.cloudcomputingjobs.co.uk .

The Skills Gap in Cloud Computing Jobs: What Universities Aren’t Teaching

Cloud computing underpins almost every modern digital service. From financial systems and healthcare platforms to AI, e-commerce, government infrastructure and cybersecurity, the cloud is now the default operating environment for UK organisations. Demand for cloud professionals has grown rapidly, with roles spanning architecture, engineering, security, DevOps, platform operations and cost optimisation. Salaries remain high, and vacancies remain stubbornly difficult to fill. Yet despite a growing number of graduates with computer science, IT and software engineering degrees, employers across the UK report a persistent problem: Too many candidates are not job-ready for real cloud computing roles. This is not a question of intelligence or motivation. It is a structural skills gap between what universities teach and what cloud jobs actually require. This article explores that gap in depth: what universities do well, what they consistently miss, why the gap exists, what employers genuinely want, and how jobseekers can bridge the divide to build sustainable careers in cloud computing.

Cloud Computing Jobs for Career Switchers in Their 30s, 40s & 50s (UK Reality Check)

Thinking about switching into cloud computing in your 30s, 40s or 50s? You aren’t alone. Across the UK, employers are hiring professionals from diverse backgrounds to help organisations adopt, manage & optimise cloud technology. But let’s cut through the buzzwords. This guide gives you a practical, UK-focused reality check on cloud computing careers for career switchers — what roles exist, what you actually need to learn, how long it takes to retrain and, importantly, whether age matters. If you’re exploring a move into cloud computing, this article lays out what’s realistic and how to get there without falling for hype.