SAP HANA

Tata Consultancy Services provided pay range This range is provided by Tata Consultancy Services. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range $64,000.00/yr - $150,000.00/yr 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. 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. 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. 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 Seniority Level Mid‑Senior level Employment Type Full‑time Job Function Information Technology Industries: Information Services Referrals increase your chances of interviewing at Tata Consultancy Services by 2x. Benefits Medical insurance Vision insurance 401(k) Get notified about new SAP Specialist jobs in SanJose,CA . #J-18808-Ljbffr Tata Consultancy Services