Data Engineer (BODS)

Weekday (YC W21); Maharashtra; On-site; INR 250,000 - 500,000; Full time

Job summary

Weekday (YC W21) is seeking a Lead Data Engineer in Pune/Bengaluru to own the Enterprise Data Warehouse end-to-end. You will architect and optimize data pipelines, lead a team of engineers, and collaborate with BI, analytics, and application teams. Strong SQL, Oracle, and ETL/ELT expertise are required.

The role demands 8+ years in data engineering, 2+ years in leadership, and willingness to work in shifts. Location is Pune or Bengaluru with full-time employment.

Qualifications

• 8+ years of experience in Data Engineering and related fields.
• Proven ability to lead technical teams and drive EDW initiatives.
• Experience designing scalable data pipelines and ETL/ELT frameworks.

Responsibilities

• EDW Architecture & Data Engineering: lead design and implementation.
• Architect and optimize ETL/ELT pipelines using SAP BODS and IBM DataStage.
• Develop and maintain data models (Star/Snowflake; SCD).
• Ensure availability, reliability, and performance of data pipelines.
• Lead governance, security, and compliance for data assets.

Skills

SAP BODS

IBM DataStage

Redwood

Advanced SQL

Oracle database

EDW architecture

Education

Bachelor’s or Master’s degree in Computer Science/IS

8+ years of Data Engineering

2+ years leading technical teams

Tools

Redwood scheduling

Snowflake

Databricks

Synapse

Oracle

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

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.

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

Good-to-have skills

redwood, Python, Banking Domain