BODS Data Engineer

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

\n
• Design and implement scalable data integration and transformation frameworks for the Enterprise Data Warehouse.
\n
• Architect and optimize ETL/ELT pipelines using SAP BODS and IBM DataStage.
\n
• Develop and maintain robust data models (Star/Snowflake schemas, SCD implementation).
\n
• Ensure high availability, reliability, and performance of data pipelines.
\n
• Implement data governance, security, and compliance standards.
\n

2. ETL Development & Optimization

\n
• Develop complex data workflows and transformations.
\n
• Perform performance tuning of ETL jobs and SQL queries.
\n
• Optimize batch processing and scheduling using Redwood.
\n
• Implement error handling, logging, and monitoring mechanisms.
\n
• Manage incremental loads and data reconciliation processes.
\n

3. Database & SQL Development

\n
• Write and optimize complex SQL queries, stored procedures, and functions.
\n
• Work extensively with Oracle databases and related technologies.
\n
• Design and manage indexing strategies and query optimization.
\n
• Support database performance analysis and tuning.
\n

4. Leadership & Team Management

\n
• Lead and mentor a team of data engineers.
\n
• Conduct code reviews and enforce development standards.
\n
• Drive technical best practices and architecture governance.
\n
• Collaborate with cross-functional teams including BI, Analytics, and Application teams.
\n
• Participate in sprint planning, estimation, and technical roadmap discussions.
\n

5. Stakeholder Collaboration

\n
• Work closely with business stakeholders to gather and translate requirements into technical solutions.
\n
• Provide technical guidance and solution recommendations.
\n
• Ensure alignment between enterprise data strategy and business goals.
\n
• Support production issue resolution and root cause analysis.
\n

Required Skills

Technical Expertise

\n
• Strong experience with SAP BODS
\n
• Hands-on experience with IBM DataStage
\n
• Experience with Redwood scheduling
\n
• Advanced SQL development
\n
• Strong expertise in Oracle database
\n
• Deep understanding of Enterprise Data Warehouse architecture
\n

Data Engineering Concepts

\n
• Data modeling (Star/Snowflake schema, SCD Types)
\n
• ETL/ELT best practices
\n
• Data quality frameworks
\n
• Performance tuning and optimization
\n
• Data security and governance standards
\n

Preferred / Good to Have

\n
• Experience with modern cloud data platforms (Azure, AWS, GCP)
\n
• Knowledge of Snowflake, Databricks, or Synapse
\n
• CI/CD implementation for data pipelines
\n
• Exposure to data cataloging and metadata management tools
\n
• Experience in Agile/Scrum methodologies
\n

Qualifications

\n
• Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field.
\n
• 8+ years of experience in Data Engineering.
\n
• 2+ years of experience in leading technical teams.
\n

Key Competencies

\n
• Strong architectural and analytical skills
\n
• Leadership and mentoring capability
\n
• Excellent communication and stakeholder management
\n
• Problem-solving mindset
\n
• Ability to drive enterprise-scale data initiatives
\n
• Flexibility for Shift working is mandatory.
\n

SAP BODS, SQL, IICS

redwood, Python, Banking Domain