Senior Data Engineer - Data Modeler
- Relanto
- 5 - 7 years
- Bengaluru
- 5 months ago
- Email to a friend
- Report this job
Job Description
Job Summary:We are seeking a highly skilled and experienced Data Modeler to join our data engineering team. The ideal candidate will bring deep expertise in designing scalable and efficient data models for cloud platforms, particularly with a strong background in Oracle Data Warehousing and Databricks Lakehouse architecture. You will play a critical role in our strategic migration from an on-prem Oracle data warehouse to a modern cloud-based Databricks platform.
Key Responsibilities:- Design and implement conceptual, logical, and physical data models that support business requirements and analytics needs.
- Lead the migration of data models from an on-prem Oracle Data Warehouse to Databricks on AWS or Azure cloud.
- Reverse-engineer and analyze complex Oracle schemas, PL/SQL code, and existing structures to build equivalent or improved models on the cloud.
- Collaborate with data architects and engineers to define optimal data structures in Databricks, leveraging Delta Lake and Spark.
- Optimize data models for performance, scalability, and cost-efficiency in a cloud-native environment.
- Develop and maintain dimensional models using star and snowflake schemas to support BI and reporting tools.
- Ensure data governance standards are met by incorporating metadata management, data lineage, and documentation practices.
- Participate in data architecture reviews and provide input on best practices in modeling and data pipeline integration.
- Work closely with cross-functional teams to understand business needs and translate them into effective data solutions.
- 5+ years of hands-on experience in data modeling, including conceptual, logical, and physical design.
- Proven experience migrating large-scale Oracle DWH environments to Databricks Lakehouse or similar platforms.
- Strong expertise in Oracle database schemas, PL/SQL, and performance tuning.
- Proficiency in Databricks, Delta Lake, Spark SQL, and DataFrame APIs.
- Experience designing models optimized for cloud platforms (preferably AWS or Azure).
- Deep knowledge of dimensional modeling techniques (Star/Snowflake).
- Familiarity with tools and practices for metadata management, data lineage, and governance.
- Strong analytical and communication skills with the ability to work collaboratively in Agile teams.
- Ability to document and communicate data model designs to both technical and non-technical stakeholders.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse Architect / ConsultantEmployement Type: Full timeContact Details:
Company: Relanto GlobalLocation(s): Bengaluru
Keyskills: schema oracle performance tuning data bricks oracle database snowflake metadata management microsoft azure cloud platforms data architecture data engineering spark data governance aws
Similar positions
Relanto
Relanto is an international consulting and technology firm specialized in real-time planning and decision-making solutions using Advanced Analytics and AI. Our proven expertise in Integrated Planning Solutions enable business leaders to make fast and accurate decisions using connected platforms. We ...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in