We are seeking an experienced SAP Native HANA Consultant to join our team. The successful candidate will be responsible for designing, developing, and implementing SAP HANA solutions. This role requires deep expertise in SAP HANA modeling, SQL scripting, and performance optimization, as well as experience in integrating HANA with various SAP and non-SAP systems. Key Responsibilities: Design and Development: Design and develop complex data models in SAP HANA using Attribute Views, Analytic Views, Calculation Views, and CDS views. Create and optimize SQL scripts, stored procedures, and functions in HANA to meet complex business requirements. Develop HANA XS Classic and XS Advanced applications, including creating OData services and web-based user interfaces. Data Integration: Integrate SAP HANA with SAP BW, SAP ECC, SAP S/4HANA, and other external systems using SLT, SDI, and SDA. Design and implement ETL processes to extract, transform, and load data into SAP HANA from various source systems. Utilize SAP Data Services, SAP Data Intelligence, and other tools for data integration and migration. Performance Optimization: Perform performance tuning of SAP HANA models and SQL queries to ensure optimal performance. Monitor and analyze system performance, identifying and resolving bottlenecks. Implement best practices for memory management, indexing, and partitioning within SAP HANA. System Administration and Security: Manage SAP HANA environments, including installation, configuration, and upgrades. Implement security best practices, including user roles, privileges, and encryption. Conduct regular system monitoring, backup, and disaster recovery planning. Project Management and Collaboration: Lead or participate in SAP HANA projects, from requirement gathering to implementation and post-go-live support. Collaborate with business stakeholders to understand their requirements and translate them into technical solutions. Work closely with SAP Basis, SAP BW, and other technical teams to ensure seamless integration and deployment of HANA solutions. Documentation and Training: Prepare detailed technical documentation, including data models, process flows, and system configurations. Provide training and support to business users and other team members on SAP HANA best practices and usage. Conduct knowledge transfer sessions and workshops to enhance the teams SAP HANA capabilities. Required Qualifications: Education: Bachelors degree in Computer Science, Information Technology, or a related field. Experience: Minimum of 10 years of experience in SAP HANA, with a focus on Native HANA development. In-depth experience with HANA data modeling, SQL scripting, and HANA XS (Extended Services Strong experience in integrating SAP HANA with SAP and non-SAP systems. Proven track record of performance tuning and optimizing SAP HANA models and queries. Technical Skills: Expertise in SAP HANA Studio, SAP HANA Web IDE, and SAP HANA Cockpit. Proficiency in SQL, SQLScript, and advanced HANA modeling techniques. Familiarity with SAP SLT, SDI, SDA, and other data provisioning tools. Experience with SAP S/4HANA, SAP BW/4HANA, and SAP ECC is a plus. Knowledge of cloud platforms like SAP HANA Cloud, AWS, or Azure is an advantage. Soft Skills: Strong problem-solving and analytical skills. Excellent communication and interpersonal skills. Ability to work independently and collaboratively in a team environment. Strong organizational skills with the ability to manage multiple projects and priorities. Preferred Qualifications: SAP HANA certification. Experience with Agile/Scrum methodologies. Knowledge of machine learning and predictive analytics within SAP HANA. Technical Expertise 1. HANA Data Modeling: Can you describe your experience with SAP HANA data modeling, including the use of Attribute Views, Analytic Views, Calculation Views, and CDS views? Please provide specific examples. How do you approach designing complex data models in SAP HANA to meet specific business requirements? 2. SQL Scripting: What experience do you have with SQL scripting in SAP HANA? Can you share an example where you developed or optimized SQL scripts to address a challenging business scenario? 3. HANA XS Development: Can you explain your experience with SAP HANA XS Classic and XS Advanced? How have you used these technologies to create OData services or web-based interfaces? 4. Data Integration: Describe your experience with integrating SAP HANA with SAP BW, SAP ECC, SAP S/4HANA, and external systems. Which tools and techniques have you used, such as SLT, SDI, or SDA? How have you handled ETL processes in SAP HANA? Can you provide an example of a complex data integration project youve managed? 5. Performance Optimization: How do you approach performance tuning for SAP HANA models and SQL queries? Can you share a specific example where your optimization efforts significantly improved system performance? What best practices do you follow for memory management, indexing, and partitioning within SAP HANA? 6. System Administration and Security: Can you discuss your experience managing SAP HANA environments, including installation, configuration, and upgrades? How do you ensure the security of SAP HANA systems? What measures have you implemented regarding user roles, privileges, and encryption? Project Management and Collaboration 7. Project Leadership: Can you share an example of a SAP HANA project you led, from requirements gathering through to post-go-live support? What were the key challenges, and how did you overcome them? 8. Collaboration with Stakeholders: How do you collaborate with business stakeholders to understand their requirements and translate them into technical solutions? Can you provide an example of a successful collaboration? 9. Integration with Technical Teams: Describe your experience working closely with SAP Basis, SAP BW, or other technical teams. How do you ensure seamless integration and deployment of HANA solutions? Documentation and Training 10. Technical Documentation: How do you approach creating technical documentation for SAP HANA solutions? Can you provide an example of how your documentation has been used effectively by other team members? 11. Training and Knowledge Transfer: Have you conducted training sessions or workshops on SAP HANA best practices? How do you ensure the knowledge transfer is effective and lasting? Soft Skills 12. Problem-Solving and Analytical Skills: Can you describe a situation where you had to solve a particularly challenging problem in an SAP HANA project? What steps did you take, and what was the outcome? 13. Communication and Team Collaboration: How do you ensure effective communication and collaboration within a team? Can you give an example of how you have facilitated successful teamwork in a complex project? 14. Organizational Skills: How do you manage multiple projects and priorities? Can you provide an example of a time when you had to balance conflicting demands successfully? Preferred Qualifications 15. SAP HANA Certification: Are you SAP HANA certified? If so, how has this certification influenced your approach to your work? 16. Agile/Scrum Methodologies: What is your experience with Agile or Scrum methodologies? How have these approaches impacted the way you deliver SAP HANA projects? 17. Machine Learning and Predictive Analytics: Have you worked with machine learning or predictive analytics within SAP HANA? Can you provide an example of how you have applied these technologies in a project?