ETL Developer

AMS is a global workforce solutions partner committed to creating inclusive, dynamic, and future-ready workplaces. We help organisations adapt, grow, and thrive in an ever-evolving world by building, shaping, and optimising diverse talent strategies.

Our Contingent Workforce Solutions (CWS) is one of our service offerings. Acting as an extension of their recruitment teams, we connect them with skilled interim and temporary professionals, fostering workplaces where everyone can contribute and succeed.

Our Client is a big four consultancy firm with a global presence, operating in over 150 countries. This organisation works with many public and private companies spanning multiple industries. The advisory work that they cover spans across audit, Accountancy, tax, corporate finance and consulting.

On behalf of this organisation, AMS are looking for a ETL Developer for a 6 Month contract based in London with hybrid (3days/week) model.

Purpose of the role:

We are looking for an experienced ETL Developer to lead the data migration strategy, moving books, records and positions out of FIS GMI onto strategic target platforms. Your work will support the seamless transition of Exchange Traded Derivatives (ETD) including futures and options and Cleared OTC products (interest rate swaps, credit default swaps, repos). You will design and build high-performance data pipelines that ensure complete accuracy, regulatory compliance and minimal disruption to daily clearing operations.

What you'll do:

• Legacy System Decoding: Analyze and reverse-engineer legacy FIS GMI data structures (typically hosted on AS400/DB2/Mainframe environments), including transaction registers, position files, and margin master files
• Data Pipeline Engineering: Architect, develop, and tune enterprise-grade ETL pipelines (using tools like Informatica, Talend, or modern cloud data engines) to extract, cleanse, and transform derivative lifecycle data
• Product Processing Mapping: Map complex clearing workflows, including trade capture, position allocations, give-up/give-in workflows, exchange fee schedules, and margins across 40+ global exchanges and CCPs
• Cross-functional Collaboration : Work closely with Business Analysts, Risk, Product Control, and Operations teams to translate functional specifications into clean, production-grade ETL code
• Performance Tuning : Optimize massive batch and real-time streaming data loads (using Autosys, Control-M, or Kafka) to comfortably fit within tight overnight batch processing windows

The skills you'll need:

• Strong proficiency in Oracle databases , including advanced Oracle development experiences in package, procedure, materialized view
• Strong experience in performance optimization and troubleshooting
• Strong experience in building a large data warehouse, dimensional data models and ETL/ELT
• Advanced knowledge in Oracle system administration
• Excellent data analysis, communication skills and stakeholder management
• Collaborate with business analysts, data architects, and other stakeholders to translate business requirements into technical solutions.
• Technical Skillset : ETL Tools: Informatica PowerCenter, Talend, SSIS, or cloud-native ETL/ELT equivalents
• Database & SQL: Expert-level SQL/T-SQL/PL-SQL, strong experience with Sybase, DB2, Oracle, or modern cloud warehouses (Snowflake, BigQuery)
• Scripting & OS: Unix/Linux Shell scripting, Python
• Scheduling & Messaging: Autosys, BMC Control-M, and experience with real-time event-streaming platforms like Apache Kafka
• Data Modeling: Solid understanding of dimensional modeling, star/snowflake schemas, and data lineage mapping
• Desirable: Relevant experience in Financial Services and knowledge of the cleared derivatives lifecycle.

Next steps

Next steps

This client will only accept workers operating via an Umbrella or PAYE engagement model.

If you are interested in applying for this position and meet the criteria outlined above, please click the link to apply and we will contact you with an update in due course.

AMS, a Recruitment Process Outsourcing Company, may in the delivery of some of its services be deemed to operate as an Employment Agency or an Employment Business

JBRP1_UKTJ