Senior Data Engineer
Role details
Job location
Tech stack
Job description
Data Engineer - Payments Migration (Contract)We're working with a leading consulting firm, who are delivery a key payments migration programme for a leading financial services firm, moving processing from a third-party provider into an in-house environment. The immediate focus is to stand up core processing and connectivity quickly, with minimal disruption - so this role needs someone who has done this before in live, high-volume systems. What you'll be doing:Supporting data migration activity within a payments environmentBuilding and executing ETL pipelines and migration runsTroubleshooting data defects and issuesSupporting dress rehearsals and go-liveDesigning safe data extraction approaches from live systems
Requirements
Experience required:Proven experience delivering data migration in banking or payments systemsStrong hands-on expertise with IBM DB2 on mainframe, including:Indexing, clustering, partitioning, archivingQuery optimisation in high-volume environmentsExperience working in large-scale, high-throughput systems where:Data extraction cannot impact live processing You'll need to be confident with:Data mapping and lineageExtracting data from complex, congested tablesReconciliation and validation of migrated datasetsRunning ETL processes in controlled production environments Key considerations:Delivering extraction with zero impact to BAU payments processingManaging production risk carefully and pragmaticallyWorking in environments where systems are complex and not always well documented What matters:Able to work independently in a fast-moving, ambiguous environmentProactive in identifying issues earlyComfortable escalating risks clearly and quicklyFocused on delivery and getting things done safely If you've delivered data migration in live payments environments and understand the risks involved, this is worth a conversation.