Data Architect Mainframe Migration & Modernization
- Hiring Organisation
- Stackstudio Digital Ltd
- Location
- London, United Kingdom
- Employment Type
- Contract, Work From Home
- Contract Rate
- From £500 to £550 per day
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 Change Data Capture: CDC design and operations … 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 ...