19 Aug
|
Zealogics.com
|
India
19 Aug
Zealogics.com
India
Job Title:Senior Data Engineer (Data Modeling & Multi-Source Integration)
Experience: 5 – 8 Years
Position Overview
Zealogics Technologies is seeking an experienced and analytical Senior Data Engineer (5–8 years) to architect, model, and optimize the foundational data infrastructure for a brand-new strategic project. This role requires deep expertise in establishing relationships across heterogeneous data sources (SAP Core, PostgreSQL, MySQL), building comprehensive data catalogs/lineage, and fine-tuning high-performance data pipelines.
Key Responsibilities
- Data Modeling & Relationship Mapping: Architect conceptual, logical, and physical data models for a recent enterprise solution. Identify, map, and resolve complex entity relationships across SAP Core, PostgreSQL, MySQL, and legacy systems.
- Data Lineage & Cataloging: Implement enterprise data cataloging, metadata tracking, and end-to-end data lineage to ensure visibility, governance, and auditability across all data layers.
- Performance Optimization & Tuning: Analyze execution plans, optimize complex SQL queries,
fine-tune database configurations, indexing, and partitioning to ensure high throughput and minimal latency.
- Document & Unstructured Metadata Management (Advantageous): Design and maintain robust metadata indexing mechanisms for large-scale document management systems (e.g., In-house DMS, Azure Blob Storage).
- Pipeline Engineering: Build reliable ETL/ELT data pipelines integrating structured, semi-structured, and enterprise data repositories into a unified system.
- Cross-Functional Collaboration: Partner with enterprise architects, product owners, and global client technical teams to translate business requirements into scalable data architectures.
Required Qualifications
- Experience: 5–8 years of dedicated hands-on experience in Data Engineering, Data Architecture, and Enterprise Data Modeling.
- Data Modeling Mastery: Proven expertise in dimensional modeling, Data Vault, ER diagrams, and multi-
📌 Senior Data Engineer (India)
🏢 Zealogics.com
📍 India