Weekday AI

Proactive software engineer recruitment via referrals

Data Engineer

Data EngineeringConfirmed live in the last 24 hours

Full-timeNo salary listedIn-person

About the Job

Requirements

At least 5 years of experience; the qualifications section specifies 8+ years of experience in Data Engineering.
At least 2 years of experience leading technical teams.
Strong experience with SAP BODS.
Hands-on experience with IBM DataStage.
Experience with Redwood scheduling.
Advanced SQL development.
Strong expertise in Oracle databases.
Deep understanding of Enterprise Data Warehouse architecture.
Experience with data modeling, including Star and Snowflake schemas and SCD types.
Knowledge of ETL/ELT best practices.
Knowledge of data quality frameworks.
Knowledge of performance tuning and optimization.
Knowledge of data security and governance standards.
Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
Flexibility for shift work is mandatory.

Responsibilities

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, including Star and Snowflake schemas and SCD implementation.
Ensure high availability, reliability, and performance of data pipelines.
Implement data governance, security, and compliance standards.
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.
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.
Lead and mentor a team of data engineers.
Conduct code reviews and enforce development standards.
Drive technical best practices and architecture governance.
Collaborate with BI, Analytics, and Application teams.
Participate in sprint planning, estimation, and technical roadmap discussions.
Work 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.

Desired Qualifications

Experience with modern cloud data platforms such as Azure, AWS, or GCP.
Knowledge of Snowflake, Databricks, or Synapse.
Experience implementing CI/CD for data pipelines.
Exposure to data cataloging and metadata management tools.
Experience with Agile/Scrum methodologies.
Experience with IICS.
Experience with Python.
Experience in the banking domain.

Data Engineer - BODS

Weekday AI · Pune, India · Full-time · Posted 2026-09-19

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

About the Company

Weekday AI

Proactive software engineer recruitment via referrals

Weekday.works helps companies hire software engineers through proactive outreach and peer-recommended candidates. Its platform automates tracking, pipeline management, and provides weekly updates, while it actively identifies engineers via peer networks, reaches out, shortlists, checks references, and schedules interviews. Differentiators include peer-backed vetting instead of traditional job boards, proactive outreach, and a passive-income reference feature that monetizes referrals. The goal is to reduce the time and effort of hiring by connecting companies with pre-vetted engineers who are open to new opportunities through a network-driven approach.

Company size: 201-500
Company stage: Seed
Total funding: $2.3M
Headquarters: Bengaluru, India
Founded: 2021

Recently Posted Jobs

Explore more opportunities at Weekday AI

See more jobs