Job Description
Job Description
Must Have Technical/Functional Skills :
- 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 SQL Script, 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 manage multiple tasks.
- Excellent verbal and written communication skills.
- Preferred Qualifications
- Certification: SAP Certified Development Associate - SAP HANA.
Salary Range: $64,000-$150,000 a year
#LI-CM2
Job Tags
Temporary work, Remote work,