SAP Datasphere+SAC

Orcapod Consulting Services; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Orcapod Consulting Services in Bengaluru seeks a data engineer specializing in SAP Datasphere to design, build, and manage data models and semantic layers for analytics. You will implement transformations, write SQL, and optimize ETL/ELT processes to deliver accurate reporting.

Collaborating with data architects and analysts, you will translate business requirements into DSP models, working across integration monitors, replication flows, and SAP connections. Immediate joiners preferred.

Qualifications

• Experience designing data models in SAP Datasphere and semantic layers for analytics.
• Strong SQL skills for ETL/ELT data extraction, transformation, and loading.
• Familiarity with SAP ecosystem including ABAP, BWonHANA, BW/4HANA and SAP Analytics Cloud.
• Ability to collaborate with data architects, analysts and engineering teams to translate requirements into DSP models.

Responsibilities

• Design, build, and manage data models (graphical, SQL, ER models) in SAP Datasphere.
• Develop local tables, views, analytical datasets, and semantic models to support reporting and analytics.
• Implement data transformations, calculation logic, and business rules using DSP capabilities.
• Write high-quality SQL scripts for ETL/ELT and optimize queries for performance and accuracy.
• Troubleshoot SQL and modeling issues across datasets and data flows.
• Work with Data Integration Monitor, Replication Flows and Connections within SAP Datasphere.
• Collaborate with data architects, analysts, business SMEs, and engineering teams to understand requirements and translate them into DSP models.

Job description

• Design, build, and manage data models (graphical, SQL, entity relationship models) in SAP Datasphere.
• Develop local tables, views, analytical datasets, and semantic models to support reporting and analytics use cases.
• Implement data transformations, calculation logic, and business rules using DSP capabilities.
• Write highquality, efficient SQL scripts for data extraction, transformation, and loading (ETL/ELT).
• Optimize SQL queries for performance, scalability, and data accuracy.
• Troubleshoot SQL and modelingrelated issues across datasets and data flows.
• Familiarity with SAP ecosystem (e.g., ABAP, BWonHANA, BW/4HANA, SAP Analytics Cloud)
• Work with Data Integration Monitor, Replication Flows, and Connections within SAP Datasphere.
• Collaborate with data architects, analysts, business SMEs, and engineering teams to understand requirements and translate them into DSP models.Role & responsibilities

Preferred candidate profile

only immediate joiner are preferrable