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 up-to-date data platforms.
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 discussion
📌 Bods Data Engineer Pune
🏢 Weekday`
📍 Pune
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.