Prophecy Technologies
SAP HANA Native Developer
• 5 years of hands-on experience in SAP HANA Native Development.
We are seeking a skilled SAP HANA Developer to join our team. The ideal candidate will focus on designing, developing, and optimizing high-performance data models and database logic. You will translate complex business requirements into technical solutions using SAP HANA native modeling (Calculation Views) and SQLScript, ensuring efficient data processing and reporting capabilities.
Key Responsibilities
1. Data Modeling & Development
HANA Native Modeling: Design and develop complex Calculation Views (Graphical and Script-based) to support analytical reporting and business logic.
Database Logic: Create and maintain optimized Stored Procedures, Table Functions, Scalar Functions, and complex SQL scripts within SAP HANA Studio and Web IDE.
Data Structures: Design and define table structures, sequences, and triggers suited for column-store processing.
Modern Development: Utilize HDI (HANA Deployment Infrastructure) containers and Web IDE/Business Application
Studio for XSA (XS Advanced) development where applicable.
2. Performance Tuning & Optimization
Query Optimization: Analyze and tune complex SQL queries and Calculation Views for optimal performance.
Analysis Tools: Utilize HANA PlanViz, SQL Trace, and Expensive Statements analysis to identify bottlenecks and reduce memory footprint/execution time.
Data Partitioning: Implement partitioning strategies for large tables to improve data access and management.
3. Data Integration & Provisioning
Virtualization: Implement data virtualization using Smart Data Access (SDA) or Smart Data Integration (SDI) to connect to remote data sources.
Data Flow: Collaborate with ETL teams (SAP Data Services/SLT) to design efficient data flow logic and transformation rules for loading data into HANA.
4. Security & Governance
Access Control: Implement robust data security models, including Analytic Privileges (Classical and SQL-based) and Role design to ensure row-level security.
Standards: Adhere to best practices for naming conventions, transport management (HALM/CTS+/CHARM), and version control.
5. Collaboration & Documentation
Requirement Analysis: Work closely with Functional Consultants and Business Analysts to understand functional specs.
Documentation: Prepare detailed Technical Specification Documents (TSD), data flow diagrams, and unit test scripts.
Required Skills and Qualifications
Education: Bachelor’s degree in Computer Science, Information Systems, or a related field.
Experience: 5 years of hands-on experience in SAP HANA Native Development.
Technical Competencies:
Core HANA: Expert proficiency in creating Calculation Views (Dimension, Cube, Star Join) and implementing input parameters/variables.
SQLScript: Strong command of SQLScript, including imperative logic, temporary tables, and dynamic SQL.
Tools: Proficient in SAP HANA Studio (Modeler & Development perspectives) and SAP Web IDE for HANA.
Security: Solid understanding of HANA User Management, Roles, and Analytic Privileges.
Performance: Proven ability to troubleshoot performance issues using PlanViz.
Soft Skills:
Strong analytical and problem-solving skills
Ability to work independently and manager multiple tasks
Excellent verbal and written communication skills
Preferred Quallifications
Certification: SAP Certified Developement Associate- SAP HANA
To apply for this job email your details to anand@prophecytechs.com