Lead Data Engineer – SQL, Oracle

Lead Data Engineer – SQL, Oracle — Lead Data Engineer – Hyderabad | Full‑time You’ll shape the data backbone of a global manufacturing leader that’s building a high‑impact technology hub in Hyderabad. The role offers the chance to own end‑to‑end data pipelines, mentor a growing engineering team and drive AI‑ready analytics across sales, finance and operations. What You’ll Do Architect and optimise scalable pipelines on Databricks and Azure Data Services. Build high‑performance ETL/ELT jobs using Python, PySpark and distributed frameworks. Design enterprise data models (star & snowflake) and enforce strict data‑quality standards. Write and review complex SQL (CTEs, aggregations, multi‑table joins). Integrate data from Oracle, SQL Server, Postgres and MongoDB sources. Implement real‑time ingestion with Kafka, AWS SNS/SQS and event‑driven patterns. Lead documentation, metadata management and mentor junior engineers. What You Need 5+ years hands‑on data engineering experience, including 5 years with Databricks. Expert‑level Python and PySpark proficiency. Advanced SQL skills (CTEs, window functions, joins). Strong background in data modelling, warehousing and ELT best practices. Experience with Azure Data Services, Power BI/Sigma, and GitHub CI/CD workflows. Hands‑on work with Informatica Cloud (Customer 360, MDM) and real‑time streaming tools. Good to Have Databricks Certified Data Engineer Professional. Informatica Cloud Data Integration Specialist certification. Proven leadership and mentorship abilities in agile, fast‑changing environments. The Opportunity Pella India operates as a direct extension of its U.S. IT team, offering a strategic platform to drive innovation across ERP, AI and more. The role sits at the centre of