Data Architect – Mainframe Migration & Modernization

DCV Technologies
London
3 days 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

Data Architect Mainframe Migration & Modernization

Data Architect

Postgres Data Architect

Data Architect

Data Architect

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 Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.

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

Thinking about switching into data science in your 30s, 40s or 50s? You’re far from alone. Across the UK, businesses are investing in data science talent to turn data into insight, support better decisions and unlock competitive advantage. But with all the hype about machine learning, Python, AI and data unicorns, it can be hard to separate real opportunities from noise. This article gives you a practical, UK-focused reality check on data science careers for mid-life career switchers — what roles really exist, what skills employers really hire for, how long retraining typically takes, what UK recruiters actually look for and how to craft a compelling career pivot story. Whether you come from finance, marketing, operations, research, project management or another field entirely, there are meaningful pathways into data science — and age itself is not the barrier many people fear.