This role is for one of the Weekday's clients Min Experience: 5+ years

Location: Pune, Bengaluru

JobType: full-time

We are seeking an experienced Lead Data Engineer to take end-to-end ownership of Enterprise Data Warehouse (EDW) solutions. This role will be responsible for designing, architecting, and optimizing scalable, secure, and high-performance data pipelines using SAP BODS, IBM DataStage, Redwood, SQL, Oracle, and modern data platforms.

The ideal candidate will combine strong hands-on technical expertise with leadership capabilities to drive data engineering best practices and deliver enterprise-grade data solutions aligned with business objectives.

Requirements Key Responsibilities

- EDW Architecture & Data Engineering
- Design and implement scalable data integration and transformation frameworks for the Enterprise Data Warehouse
- Architect and optimize ETL/ELT pipelines using SAP BODS and IBM DataStage
- Develop and maintain robust data models (Star/Snowflake schemas, SCD implementation)
- Ensure high availability, reliability, and performance of data pipelines
- Implement data governance, security, and compliance standards
- ETL Development & Optimization
- Develop complex data workflows and transformations
- Perform performance tuning of ETL jobs and SQL queries
- Optimize batch processing and scheduling using Redwood
- Implement error handling, logging, and monitoring mechanisms
- Manage incremental loads and data reconciliation processes
- Database & SQL Development
- Write and optimize complex SQL queries, stored procedures, and functions
- Work extensively with Oracle databases and related technologies
- Design and manage indexing strategies and query optimization
- Support database performance analysis and tuning
- Leadership & Team Management
- Lead and mentor a team of data engineers
- Conduct code reviews and enforce development standards




- Drive technical best practices and architecture governance
- Collaborate with cross-functional teams including BI, Analytics, and Application teams
- Participate in sprint planning, estimation, and technical roadmap discussions
- Stakeholder Collaboration
- Work closely with business stakeholders to gather and translate requirements into technical solutions
- Provide technical guidance and solution recommendations
- Ensure alignment between enterprise data strategy and business goals
- Support production issue resolution and root cause analysis

Required Skills Technical Expertise

- Strong experience with SAP BODS
- Hands-on experience with IBM DataStage
- Experience with Redwood scheduling
- Advanced SQL development
- Strong expertise in Oracle database
- Deep understanding of Enterprise Data Warehouse architecture

Data Engineering Concepts

- Data modeling (Star/Snowflake schema, SCD Types)
- ETL/ELT best practices
- Data quality frameworks
- Performance tuning and optimization
- Data security and governance standards

Preferred / Good To Have

- Experience with modern cloud data platforms (Azure, AWS, GCP)
- Knowledge of Snowflake, Databricks, or Synapse
- CI/CD implementation for data pipelines
- Exposure to data cataloging and metadata management tools
- Experience in Agile/Scrum methodologies

Qualifications

- Bachelor's or Master's degree in Computer Science, Information Systems, or related field
- 8+ years of experience in Data Engineering
- 2+ years of experience in leading technical teams

Key Competencies

- Strong architectural and analytical skills
- Leadership and mentoring capability
- Excellent communication and stakeholder management
- Problem-solving mindset
- Ability to drive enterprise-scale data initiatives
- Flexibility for Shift working is mandatory

Must-have Skills SAP BODS, SQL, IICS Positive-to-have Skills redwood, Python, Banking Domain

📌 BODS Data Engineer (Bengaluru)
🏢 Weekday AI (YC W21)
📍 Bengaluru