# BODS Data Engineer

> Weekday AI · Pune, India · Full-time · Posted 2026-06-17

**Workplace:** on_site

**Department:** Weekday's Client via platform

## Description

**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**

**1\. 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.

**2\. 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.

**3\. 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.

**4\. 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.

**5\. 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

### Good-to-have skills

redwood, Python, Banking Domain

## Apply

[Apply at Weekday AI](https://apply.workable.com/weekday-1/j/4F264E9C3B/apply)

---
Powered by [Workable](https://www.workable.com)