At a Glance
- Tasks: Migrate payment processing capabilities and execute ETL pipelines with minimal disruption.
- Company: Join a global professional services company leading in digital, cloud, and security.
- Benefits: Hybrid work model, competitive pay, and opportunities for skill development.
- Other info: Dynamic role with opportunities for growth in a diverse workplace.
- Why this job: Make a real impact in banking environments while working with cutting-edge technology.
- Qualifications: Experience in data migration, IBM DB2, and high-throughput systems required.
The predicted salary is between 50000 - 70000 £ per year.
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 is a global professional services company with leading capabilities in digital, cloud, and security.
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 Objective:
- Exit 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 & Experience:
- Hands-On Experience delivering data migration in banking environments, specifically within payments or similarly critical transaction systems.
- IBM DB2 on Mainframe strong expertise required.
- Indexing, clustering, partitioning and archiving - Query optimisation in high-volume environments.
- Large Scale Systems Experience working with high-throughput systems where data extraction must be performed without impacting live processing.
Demonstrated Capability:
- Data mapping and lineage.
- Extraction strategies from complex and congested tables.
- Reconciliation and validation of migrated datasets.
- ETL processes in controlled production environments.
- Safe Extraction Design with no disruption to BAU payment processing.
- Controlled handling of production risk.
Seniority Requirements:
- Ability to work independently in ambiguous environments.
- Proactive identification of issues and early and clear escalation of risks.
TekWissen® Group is an equal opportunity employer supporting workforce diversity.
ETL Developer (IBM DB2) in London employer: TekWissen UK
Contact Detail:
TekWissen UK Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land ETL Developer (IBM DB2) in London
✨Tip Number 1
Network like a pro! Reach out to folks in the industry on LinkedIn or at local meetups. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by practising common ETL and IBM DB2 questions. We recommend setting up mock interviews with friends or using online platforms to get comfortable with your responses.
✨Tip Number 3
Showcase your skills! Create a portfolio of your past projects, especially those involving data migration and ETL processes. This will give potential employers a clear view of what you can bring to the table.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace ETL Developer (IBM DB2) in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the ETL Developer role. Highlight your hands-on experience with IBM DB2 and any relevant banking environments. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for this role. Mention your experience with data migration and how you can help us exit the existing third-party dependency smoothly.
Showcase Your Problem-Solving Skills: In your application, don’t forget to mention specific examples where you've proactively identified issues and escalated risks. We love candidates who can think on their feet and tackle challenges head-on!
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you don’t miss out on any important updates from us!
How to prepare for a job interview at TekWissen UK
✨Know Your ETL Inside Out
Make sure you brush up on your ETL processes, especially in relation to IBM DB2. Be ready to discuss your hands-on experience with data migration in banking environments and how you've tackled challenges like data defects and reconciliation.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've proactively identified issues in past projects. Think about times when you had to troubleshoot data extraction without disrupting live processing, and be ready to share those stories.
✨Understand the Business Context
Familiarise yourself with the payments processing landscape and the importance of minimal disruption during migrations. This will help you articulate how your skills align with the company's objectives and the specific role.
✨Ask Insightful Questions
Prepare thoughtful questions about the project and the team dynamics. Inquire about their approach to risk management during migrations and how they handle production environments. This shows your genuine interest and helps you assess if it's the right fit for you.