Senior Data Engineer
Techblocks
·Today
- Salary
- ₹3000k – ₹3400k
- Location
- Ahmedabad, India · Hyderabad, India
- Department
- Engineering
- Seniority
- Senior
- Experience
- 6+ years
- Source
- Keka
Description
- 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.