Required Skills & Experience
    • 6-8 years of experience in Data Engineering, Data Warehousing.
    • Strong hands-on experience with Oracle databases, including Oracle ADW.
    • Strong expertise in SQL and PL/SQL, including:
    • Complex SQL queries.
    • Stored procedures and functions.
    • Views and database transformations.
    • Query optimization and performance tuning.
    • Hands-on experience with Azure Databricks.
    • Strong programming experience in Python and PySpark.
    • Experience building ETL/ELT pipelines and implementing complex data transformations.
    • Strong understanding of Delta Lake and Lakehouse architecture.
    • Experience designing and implementing Silver and Gold data layers.
    • Experience analysing existing database schemas, dependencies and transformation logic.
    • Ability to migrate or restructure Oracle SQL/PL/SQL business logic into Databricks.
    • Understanding of data governance and data access management using Unity Catalog.
    • Experience with data validation, reconciliation and performance optimization.
Preferred Skills
    • Experience with Oracle Autonomous Data Warehouse (ADW).
    • Hands-on experience with Databricks Lakehouse Federation.
    • Understanding of zero-copy or federated data access patterns.
    • Experience migrating enterprise data warehouse workloads from Oracle to Databricks.
    • Experience working with Finance datasets, including:
    • General Ledger (GL).
    • Actuals and financial transactions.
    • Budget and forecast data.
    • Cost centres and account structures.
    • Financial reporting datasets.
    • Experience optimizing large-scale Finance data pipelines and reporting datasets.
    • Understanding of enterprise data governance, lineage and data quality practices.