Key Responsibilities :
SAP BODS Development :
- Design, develop, and maintain robust ETL jobs using SAP BODS.
- Implement various Slowly Changing Dimension (SCD) types within BODS workflows.
- Build and implement Change Data Capture (CDC) logic, including using the Hash MD5 Algorithm, to compute deltas efficiently.
- Work on enabling CDC at the source level to optimize data extraction.
Data Modeling & SQL :
Apply a strong understanding of Dimensional Modeling, including Star and Snowflake schemas.Use your proficiency in SQL and PL / SQL for data manipulation and analysis.Project & Process Management :
Lead and participate in SAP BODS Integration and Migration projects.Contribute to the unification of our data warehouse by consolidating and optimizing existing data warehouses.Adhere to project timelines and deliver high-quality, documented solutions.Required Skills & Qualifications :
Experience : Minimum of 4+ years of hands-on experience in SAP BODS development.Data Warehousing : Strong understanding of dimensional modeling, Star, and Snowflake schemas.ETL Techniques : Experience with various SCD types and CDC, including using the Hash MD5 Algorithm.Technical Skills :
Strong proficiency in SQL and PL / SQL programming.Proven experience with SAP BODS Integration and Migration projects.Soft Skills : Ability to work collaboratively and effectively to meet project goals.
(ref : hirist.tech)