Data Engineer (BODS)

Weekday; Pune District; On-site; INR 900,000 - 1,800,000; Full time

Job summary

Weekday in Pune/Bengaluru is seeking a Lead Data Engineer to own Enterprise Data Warehouse implementations and end-to-end data pipelines. You will design scalable ETL/ELT architectures, enforce governance, and mentor a team of engineers to deliver enterprise-grade data solutions aligned with business goals.

Ideal candidates have 8+ years in data engineering, strong SQL, Oracle expertise, and experience leading technical teams.

Qualifications

• Bachelor’s or Master’s degree in CS/IS or related field.
• 8+ years of experience in Data Engineering.
• 2+ years of leading technical teams.

Responsibilities

• Lead and own EDW architecture and data engineering initiatives.
• Architect and optimize ETL/ELT pipelines using SAP BODS and IBM DataStage.
• Develop robust data models (Star/Snowflake, SCD) and ensure performance.
• Collaborate with BI, Analytics, and Application teams.
• Mentor data engineers and enforce coding standards.

Skills

SAP BODS

IBM DataStage

Redwood scheduling

SQL development

Oracle database

Enterprise Data Warehouse architecture

Data modeling

ETL/ELT best practices

Data security and governance

Data quality frameworks

Cloud data platforms

Snowflake

Databricks

Synapse

CI/CD for data pipelines

Agile/Scrum

Education

Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field

Job description

This role is for one of our clients

Industry: IT Services and IT Consulting

Seniority level: Mid-Senior level

Min Experience: 5+ years

Location: Pune, Bengaluru

JobType: full-time

₹9,00,000 - ₹18,00,000 a year

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 withSAP BODS
• Hands-on experience withIBM DataStage
• Experience withRedwood scheduling
• AdvancedSQL development
• Strong expertise inOracle database
• Deep understanding ofEnterprise 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