Xtiva Looking For Lead Data Engineer_Remote
Posted Updated
Summary
Remote Lead Data Engineer (based in Bengaluru) for a 10+ year experienced professional who also acts as an agile delivery lead. Day-to-day work centers on Teradata and expert-level SQL, mainframe/JCL batch feed integration, dimensional/Data Vault warehousing modeling, and Git-based CI/CD in Jira/Azure DevOps.
Required Experience: 10+ years of dedicated data engineering or enterprise data warehousing experience.
Required Technical Skills
- Agile Leadership: 2+ years of hands-on experience acting as a Scrum Master or Agile Delivery Lead; practical knowledge of Scrum/Kanban frameworks, capacity planning, and backlog management in Jira/Azure DevOps.
- Advanced SQL: Expert-level SQL (complex analytical/window functions, performance tuning, query execution plan analysis, CTEs, indexing strategies).
- Teradata Expertise: Deep hands-on experience with Teradata architecture, workload management, physical database design, and enterprise utilities (BTEQ, TPT, FastLoad, MultiLoad).
- Mainframe & JCL: Proficient in reading, writing, and debugging JCL scripts, managing batch processing, and integrating mainframe feeds with downstream databases.
- Data Warehousing Fundamentals: Strong understanding of dimensional modeling, Data Vault, star/snowflake schemas, and data lifecycle management (SCD Types 1/2/4).
- CI/CD & Version Control: Experience using Git, automated CI/CD pipelines (Azure DevOps, GitHub Actions, or GitLab.