Oracle Developer

Adroit People Limited (UK); Madrid; Híbrido; EUR 40.000 - 65.000; Jornada completa

Descripción de la vacante

A leading company is seeking an Oracle Developer based in Madrid, Spain, to drive the development and maintenance of their Data Warehouse solutions. The role requires expertise in SQL and PL / SQL, with responsibilities ranging from designing data transformations to ensuring data integrity and performance. The position is hybrid, allowing for flexibility in work arrangements and involves collaboration with cross-functional teams.

Formación

• Strong proficiency in SQL and PL / SQL programming.
• Experience with large-scale datasets and complex transformations.
• Solid understanding of ETL processes and data warehouses.

Responsabilidades

• Develop and maintain Oracle-based Data Warehouse solutions.
• Design complex SQL and PL / SQL code for ETL processes.
• Collaborate with cross-functional teams to analyze requirements.

Conocimientos

SQL

PL / SQL

Data Warehousing Concepts

Performance Tuning

Data Transformation

Herramientas

JIRA

Descripción del empleo

ORACLE DEVELOPER Position in MADRID, SPAIN

Permanent Employment

Madrid Spain Location

Hybrid Position

SCOPE OF THE ROLE

Oracle Developer with strong experience in Data Warehouse development to support our end-to-end data pipeline—from staging through to the reporting layer. The ideal candidate will have a deep understanding of SQL, PL / SQL, and Oracle database architecture, and will work closely with stakeholders to implement client-specific data transformation and reporting solutions. The role includes identifying and resolving data issues and ensuring the integrity and performance of the data warehouse environment

ROLE & RESPONSIBILITIES

1. Develop and maintain Oracle-based Data Warehouse solutions, including staging, transformation, and reporting layers. 2. Work closely with business analysts and clients to analyze requirements and translate them into technical solutions. 3. Design and implement complex SQL and PL / SQL code for data extraction, transformation, and loading (ETL) processes. 4. Optimize queries and improve performance of stored procedures and database jobs. Perform bug fixing and issue resolution within the Oracle Data Warehouse environment. 5. Ensure data quality, consistency, and accuracy throughout the data pipeline. 6. Develop technical documentation and provide support during system testing and deployment. 7. Collaborate with cross-functional teams including BI developers, QA testers, and project managers.

KNOWLEDGE & SKILLS REQUIRED

1. Thorough knowledge of JIRA, bug tracking and monitoring is MUST 2. Strong proficiency in SQL and PL / SQL programming. 3. Experience in working with large-scale datasets and complex data transformations. 4. Solid understanding of data warehousing concepts (e.g., ETL, star / snowflake schema, data marts). 5. Experience with performance tuning and query optimization in Oracle. 6. Proven ability to analyze and debug data-related issues in production and non-production environments.