Responsibilities
- Collaborates with business stakeholders and IT application owners to understand, document, and design data warehouse processes.
- Contributes to the definition, development, and implementation of data warehouse solutions.
- Creates and maintains data mapping logic to transfer content from various source systems into the data warehouse.
- Designs, develops, tests, optimizes, and deploys ODI packages, Oracle stored procedures/packages, Databricks jobs to perform ETL functions.
- Plans and coordinates ETL and database rollouts alongside project teams, developers, and database engineers.
- Provides support, maintenance, troubleshooting, and resolution for ETL processes.
- Designs and establishes technical frameworks for the data warehouse.
Requirements
- Experience in Data Modelling and Source System Analysis.
- Expert in SQL and PL/SQL.
- Experienced with ETL processes and tools such as ODI or other ETL technologies, as well as working with large-scale databases.
- Skilled in Python for data engineering purposes.
- Familiar with PySpark.
- Capable of performing data profiling, cataloging, and mapping for the design and construction of data flows.
- Experience with data visualization and exploration tools.
- Solid understanding of data warehouse concepts.
- Skilled in database design, modelling, and analyzing large datasets.
- Proficient in advanced performance tuning techniques for complex data transformations.
- Proficient in English.
Nice to Have
- Experience within the banking sector is advantageous.
- Familiarity with Agile–Scrum methodology is a plus.
