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 filesData 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 dataProduct 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 CCPsCross-functional Collaboration : Work closely with Business Analysts, Risk, Product Control, and Operations teams to translate functional specifications into clean, production-grade ETL codePerformance Tuning : Optimize massive batch and real-time streaming data loads (using Autosys, Control-M, or Kafka) to comfortably fit within tight overnight batch processing windowsThe skills you’ll need:Strong proficiency in
Oracle databases , including advanced Oracle development experiences in package, procedure, materialized viewStrong experience in performance optimization and troubleshootingStrong experience in building a large data warehouse, dimensional data models and
ETL/ELTAdvanced knowledge in
Oracle system administrationExcellent data analysis, communication skills and stakeholder managementCollaborate 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 equivalentsDatabase & 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, PythonScheduling & Messaging:
Autosys, BMC Control-M, and experience with real-time event-streaming platforms like Apache KafkaData Modeling:
Solid understanding of dimensional modeling, star/snowflake schemas, and data lineage mappingDesirable:
Relevant experience in Financial Services and knowledge of the cleared derivatives lifecycle.Next stepsNext stepsThis 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
TPBN1_UKTJ…