Adecco Pontoon is an employment consultancy. We put expertise, energy, and enthusiasm into improving everyone's chance of being part of the workplace. We respect and appreciate people of all ethnicities, generations, religious beliefs, sexual orientations, gender identities, and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive.
Job title: Senior Azure Data Engineer - ETL Developer
Location: London (3 days per week onsite)
Contract: 12 months initially with possible extension.
Rate: £600 - £650 inside IR35
Role Summary
We are seeking a Middleware / ETL Developer with strong experience in IBM DataStage and Azure Data Factory (ADF) to design, build, and support end-to-end ETL integrations from source systems into Oracle ERP, primarily Oracle General Ledger (GL).
Job Responsibilities
- Lead overall technical architecture for our Azure platform and be at the forefront for our on-prem to cloud migration initiative and cloud consolidation strategy.
- Build large-scale batch and real-time data pipelines with data processing frameworks in Azure cloud platform.
- Designing and implementing highly performant data ingestion pipelines from multiple sources using Azure Databricks.
- Direct experience of building data pipelines using DataStage, Azure Data Factory and Databricks.
- Developing scalable and re-usable frameworks for ingesting of datasets
- Lead design of ETL, data integration and data migration.
- Partner with architects, engineers, information analysts, business, and technology stakeholders for developing and deploying enterprise grade platforms that enable data-driven solutions.
- Integrating the end-to-end data pipeline - to take data from source systems to target data repositories ensuring the quality and consistency of data is maintained at all times
- Working with event based / streaming technologies to ingest and process data.
- Working with other members of the project team to support delivery of additional project components (API interfaces, Search)
- Evaluating the performance and applicability of multiple tools against customer requirements
Technical Skills and expertise required
- Experience on ADLS, Azure SQL DB and Datawarehouse
- Strong working experience in Implementation of Azure cloud components using Azure
- Data Factory , Azure Data Analytics, Azure Data Lake, Azure Data Catalogue, LogicApps.
- Have knowledge in Azure Storage services (ADLS, Storage Accounts)
- Expertise in designing and deploying data applications on cloud solutions on Azure.
- Hands on experience in performance tuning and optimizing code running in Databricks environment.
- Good understanding of SQL, T-SQL and/or PL/SQL
- Should have experience working in Agile projects with knowledge in Jira.
- Good to have handled Data Ingestion projects in Azure environment.
- Demonstrated analytical and problem-solving skills particularly those that apply to a big data environment.
- Experience on Python scripting, Spark SQL PySpark is a plus.
We use generative AI tools to support our candidate screening process. This helps us ensure a fair, consistent, and efficient experience for all applicants. Rest assured, all final decisions are made by our hiring team, and your application will be reviewed with care and attention.