Senior Lead Data Engineer (BODS) - R01568221

India·BangaloreEmployeesenior

Data EngineerData

0 views0 saves0 applied

Apply Now

Quick Summary

Overview

Senior Data Engineer CI/CD Pipeline, CSS/SCSS/LESS, PyTest, PostgreSQL / MongoDB / Redis,

Technical Tools

Data EngineerData

Senior Data Engineer

CI/CD Pipeline, CSS/SCSS/LESS, PyTest, PostgreSQL / MongoDB / Redis, REST API / GraphQL

Python Fullstack with Microservices: Software Development Lead

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.

Responsibilities

~1 min read

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.

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 cross-functional teams including BI, Analytics, and Application teams.
Participate in sprint planning, estimation, and technical roadmap discussions.

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.

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 modeling (Star/Snowflake schema, SCD Types)
ETL/ELT best practices
Data quality frameworks
Performance tuning and optimization
Data security and governance standards

Nice to Have

~1 min read

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

Requirements

~1 min read

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