ETL / Oracle Migration Engineer (Contract)
hedgehog lab
Edinburgh, United Kingdom
yesterday
Role details
Contract type
Temporary to permanent Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
EnglishJob location
Edinburgh, United Kingdom
Tech stack
ETL
Oracle Data Service Integrator
Oracle Applications
Oracle Warehouse Builder
Standard Sql
PL-SQL
GitHub Copilot
Snowflake
Database Migration
Job description
- Build and run ETL processes using Oracle Data Integrator (ODI).
- Set up and manage change data capture with Oracle GoldenGate.
- Feed Oracle data reliably into Snowflake during migration.
- Keep legacy and target in sync while the wider migration runs.
Requirements
- Deep, hands-on experience with Oracle ODI.
- Real GoldenGate CDC experience, not just awareness of it.
- Strong SQL and PL/SQL.
- Experience migrating Oracle data into a cloud warehouse, Snowflake ideally.
- Comfortable using AI-assisted development tools like GitHub Copilot as part of your everyday workflow.
About the company
We're hedgehog lab, a digital product and engineering consultancy. For nearly 20 years we've embedded engineers inside the teams of well-known organisations in regulated, high-trust sectors, from financial services to the public sector.
We're a certified B Corp.
We're also serious about AI-assisted engineering. We've built our own agentic tooling and cut time-to-merge by around 60% on recent work, and our people get to use that on real projects.