Login to Apply

Data/ETL Engineer

3 months

London / hybrid remote working

£660 per day inside IR35

Key skills required: Ab Initio / SQL / Python / Bash / PLSQL / Oracle

Leading consultancy embarking on a digital transformation for financial services end client are seeing a highly skilled Data/ETL Engineer with extensive experience in Ab Initio, Bash, Python, PSQL, and Oracle.

The successful candidate will have a strong background in data integration, transformation, and loading processes, along with excellent problem-solving skills. This role involves designing, developing, and maintaining ETL processes to support data infrastructure and analytics needs.

Key Responsibilities for the position of Data/ETL Engineer

* Design, develop, and maintain ETL processes using Ab Initio.

* Write and maintain scripts in Bash and Python for data manipulation and automation.

* Develop and optimise SQL queries for data extraction, transformation, and loading in PSQL and Oracle databases.

* Collaborate with data analysts, data scientists, and other stakeholders to understand data requirements and deliver solutions.

* Monitor and troubleshoot ETL processes to ensure data accuracy and integrity.

* Perform data profiling, cleansing, and validation to ensure high-quality data.

* Document ETL processes, data flows, and technical specifications.

* Stay updated with the latest industry trends and best practices in data engineering and ETL.

Required Skills and Experience for the position of Data/ETL Engineer

* Ab Initio: Extensive experience in designing and developing ETL processes using Ab Initio.

* Bash: Proficiency in writing and debugging Bash scripts for automation and data manipulation.

* Python: Strong programming skills in Python for data processing and automation tasks.

* PSQL: Experience with PostgreSQL, including writing complex SQL queries and performance tuning.

* Oracle: Proficiency in Oracle databases, including PL/SQL and database management.

* Problem-Solving: Excellent analytical and problem-solving skills with a keen attention to detail.

* Data Integration: Experience in data integration, data warehousing, and data migration projects.

* Version Control: Familiarity with version control systems like Git.

* Communication: Strong verbal and written communication skills to effectively collaborate with team members and stakeholders.

Ab Initio / SQL / Python / Bash / PLSQL / Oracle