> Markdown version of [/jobs/ext/2920089-etl-developer](https://www.wearedevelopers.com/jobs/ext/2920089-etl-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# ETL Developer

- **Company:** Deloitte
- **Location:** London, UK
- **Contract:** Temporary to permanent
- **Skills:** Data Analysis, CA Workload Automation Ae, Batch Processing, Big Data, BigQuery, Cloud Engineering, Databases, Extract Transform Load (ETL), Data Structures, Data Warehousing, IBM DB2, Dimensional Modeling, Python (Programming Language), Oracle (Applications), Performance Tuning, Reverse Engineering, Shell Script, SQL Stored Procedures, PL-SQL, SQL Databases, SQL Server Integration Services, Talend, Transact-SQL, Scripting, Informatica Powercenter, Snowflake, Sybase, Database Performance, Data Lineage, Star Schema, Apache Kafka, Decoding, Data Pipelines, Control M
- **Published:** September 15, 2026
- **Apply:** https://apply.deloitte.co.uk/UKCareers/Login?jobId=25118

## About the Role

* 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
 * Desireable: Relevant experience in Financial Services and knowledge of the cleared derivatives lifecycle

## Description

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., * 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, 1. Build robust PL/SQL packages, stored procedures, and fast-refresh materialized views to execute complex transactional calculations and report aggregations
 2. Analyze database performance bottlenecks and execution plans to tune slow queries and maintain high-performance SLAs
 3. Architect scalable, production-ready Star/Snowflake schemas alongside comprehensive source-to-target mapping sheets tailored for financial data
 4. Design and deploy automated data pipelines to extract, transform, load, and validate large financial datasets from upstream transactional sources
 5. Author system administration guides (covering backups and security) and technical design documents that translate complex financial business requirements into database schemas


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)