Design and optimize enterprise data models and pipelines integrating SAP Core, PostgreSQL, MySQL and legacy systems. Implement data cataloging, lineage and metadata management. Tune SQL and database performance, build ETL/ELT pipelines, and collaborate with architects and global teams to deliver scalable data architecture for a new strategic initiative.
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
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 new 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.
- 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-source relationship mapping.
- Heterogeneous Databases: Solid expertise in working with SAP Core, PostgreSQL, and MySQL.
- Governance & Lineage: Experience with modern data cataloging and lineage tools (e.g., OpenMetadata, Apache Atlas, Microsoft Purview, Collibra, or dbt docs).
- Performance Tuning: Expert knowledge in SQL optimization, indexing strategies, memory tuning, and query troubleshooting.
- Cloud & Modern Data Stack: Hands-on experience with cloud ecosystems (Azure/AWS) and pipeline orchestration tools (Spark, Databricks, dbt, Airflow, etc.).
- Strong verbal and professional communication skills to deal with architects & data engineers across globe.
- Proven ability to extract, index, and manage metadata for large enterprise document repositories (In-house DMS, Azure Blob Storage, S3).
- Exposure to OCR/document metadata workflows and semi-structured cataloging.
- Prior experience delivering high-impact solutions for global clients and internal products.
Similar Jobs
Blockchain • Hardware • Software • Energy • Cryptocurrency • Big Data Analytics
The Data Engineer will build and manage scalable data pipelines and databases, collaborate on architecture, and drive data systems towards real-time capabilities in a fast-paced, innovative environment.
Top Skills:
AirflowClickhouseDockerKafkaKubernetesPl/PgsqlPostgresPythonRedpandaTrino
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
As an ML Engineer, you will design, experiment, and deploy AI/ML models, evaluate their performance, and leverage Python and SQL.
Top Skills:
PythonPyTorchScikit-LearnSQL
Financial Services
Review, verify, and report client data to ensure accuracy and AML/regulatory compliance. Prepare Currency Transaction Reports and compliance documentation, respond to operational requests, escalate issues, and support process improvements. Use digital tools to manage data, resolve service issues, and contribute to operational excellence.
Top Skills:
MainframeMS OfficePc-Based Systems
What you need to know about the Kolkata Tech Scene
When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.
