- 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.
- 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.
Skills Required
- 6-8 years of experience in data engineering and data warehousing
- Strong hands-on experience with Oracle databases, including Oracle ADW
- Expertise in SQL and PL/SQL, including complex queries, stored procedures, functions, views, transformations, 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 analyzing database schemas, dependencies, and transformation logic
- Ability to migrate or restructure Oracle SQL/PLSQL business logic into Databricks
- Understanding of data governance and data access management using Unity Catalog
- Experience with data validation, reconciliation, and performance optimization
- Experience with Oracle Autonomous Data Warehouse
- 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, actuals, financial transactions, budgets, forecasts, cost centers, account structures, and financial reporting datasets
- Experience optimizing large-scale Finance data pipelines and reporting datasets
- Understanding of enterprise data governance, lineage, and data quality practices
What We Do
@TechBlocks we power the software defined industries (SDI) of today and tomorrow. We are a software engineering and consulting firm. We build modern digital value chains and businesses reimagined to create frictionless experiences for innovative monetization methods and drive unforeseen efficiencies. We are known to build world class custom platforms and products that are cloud native for some of the worlds largest brands. We are the go to technology partners for born in digital businesses that grew with us from "Concept to Commercialization" and have revenues between $100M - $10B. We help modern businesses transition just from a technology outsourcing mentality to help create globally distributed digital COEs and mature them. Our converged COEs that we create in partnership with our clients help power software factories that are extremely dynamic. We have created modern digital COEs and factories that are created with a single minded goal to future proof our clients businesses. Everything we do is centred around two philosophies and practices - Design Thinking and Lean Engineering. Whether it is building digital commerce platforms, marketplace for worlds largest retailers or smart utilities applications and products or digital health products/platforms that power wearables, patches or devices across healthcare landscape; we do it all with speed and sophistication that is unmatched in the industry






