ETL Developer (IBM DB2)
Posted Today by TekWissen UK
Negotiable
Undetermined
Hybrid
London, England, United Kingdom
Summary: The role of AI/ML Engineer / ETL Developer (IBM DB2) involves migrating payment processing capabilities from a legacy system to a new environment for a global professional services company. The position requires hands-on experience in data migration within banking environments, particularly in payments systems, and emphasizes the execution of ETL pipelines while ensuring minimal disruption to business operations. The candidate will also be responsible for troubleshooting data defects and supporting the go-live process. This is a hybrid position based in London, England.
Key Responsibilities:
- Migrate payments processing capabilities from a legacy setup to a new target environment.
- Execute ETL pipelines and migration runs.
- Troubleshoot data defects and support dress rehearsals and go-live.
- Ensure minimal disruption to business operations during migration.
- Perform data mapping, extraction strategies, and validation of migrated datasets.
- Design safe extraction processes to avoid disruption to BAU payment processing.
Key Skills:
- Hands-on experience in data migration in banking environments, specifically in payments systems.
- Strong expertise in IBM DB2 on Mainframe.
- Experience with indexing, clustering, partitioning, and query optimization in high-volume environments.
- Large scale systems experience with high-throughput data extraction.
- Capability in data mapping, extraction strategies, and reconciliation of datasets.
- Ability to work independently in ambiguous environments and proactively identify issues.
Salary (Rate): undetermined
City: London
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Role: AI/ML Engineer / ETL Developer (IBM DB2)
Location : Fenchurch Street, London EC3M 4BT
Work Type: Hybrid
Duration: 4 Months
Overview: TekWissen Group is a workforce management provider throughout the UK, Europe and many other countries in the world. The client below is a global professional services company with leading capabilities in digital, cloud, and security. Combining unmatched experience and specialized skills across more than 40 industries
Job Summary Programme Overview
The programme involves migrating payments processing capabilities from a legacy setup operated via a third-party into a new target environment within the client. Immediate ObjectiveExit the existing third-party dependency quickly by re-establishing connectivity and processing capability in the target environment with minimal disruption and limited redesign. Execute ETL pipelines and migration runs, troubleshoot data defects, and support dress rehearsals and go-live.
Mandatory Skills & ExperienceHands-On Experience Delivering data migration in banking environments, specifically within payments or similarly critical transaction systemsIBM DB2 on Mainframe Strong Expertise Required Indexing, clustering, partitioning and archiving- Query optimisation in high-volume environmentsLarge Scale Systems Experience Working with high-throughput systems where data extraction must be performed without impacting live processingDemonstrated Capability Data mapping and lineage- Extraction strategies from complex and congested tables- Reconciliation and validation of migrated datasets ETL processes in controlled production environmentsSafe Extraction Design No disruption to BAU payment processing Controlled handling of production riskSeniority Requirements Ability to work independently in ambiguous environments Proactive identification of issues- Early and clear escalation of risks TekWissen® Group is an equal opportunity employer supporting workforce diversity