Data Engineer - BODS

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
Good-to-have Skills
redwood, Python, Banking Domain

Work arrangement
No