Lead Backend Data Modeler Hadoop Hive Ecosystem Exp - 8 - 14 Yrs Location - Pune Hybrid Model - 3 Days a week- work from office Job Title Lead Backend Data Modeler Hadoop Hive Ecosystem Job Summary We are seeking a highly experienced and hands-on Lead Backend Data Modeler with 8-10 years of dedicated experience in designing developing and optimizing robust and scalable data models specifically within Hadoop Hive ecosystems The ideal candidate will possess deep expertise in big data technologies and architecture with a proven track record of restructuring and managing complex backend databases and their underlying infrastructure This role demands a laser focus on designing effective high-performance data structures for analytics and applications working closely with data engineers architects and business stakeholders to ensure data integrity performance and accessibility Key Responsibilities Strategic Data Model Design Architecture Lead the design and development of conceptual logical and physical data models for large-scale data lakes and data warehouses built on Hadoop Hive ensuring alignment with critical business requirements and long-term architectural vision Hadoop Ecosystem Management Oversee and drive the restructuring optimization and management of backend databases and the underlying Hadoop architecture including HDFS YARN and related components Hive Schema Performance Optimization Design implement and maintain highly optimized Hive schemas including tables partitions bucketing strategies and indexing e g using LLAP Tez or other Hive accelerators Analyze and tune Hive queries for maximum performance on petabyte-scale datasets Big Data Integration ETL ELT Collaborate with data engineering teams to design efficient data ingestion and transformation pipelines using PySpark for ETL ELT processes ensuring seamless integration of diverse data sources into the Hadoop Hive environment Data Governance Standards Establish and enforce stringent data modeling standards

📌 Lead Data Modeler (Hyderabad)
🏢 Tech Mahindra
📍 Hyderabad