SAP HANA Job at Tata Consultancy Services, San Jose, CA

eEdjSCtlSXNxcTMxRVJUWE02TlJXdldGdkE9PQ==
  • Tata Consultancy Services
  • San Jose, CA

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,

Similar Jobs

Locanda Verde - Tribeca

Bar Manager Job at Locanda Verde - Tribeca

 ...NoHo Hospitality Group is seeking a Bar Manager to join our hospitality family under our Beverage Director Josh Nadel , a Master Sommelier. This opportunity has tremendous growth potential within our growing hospitality family. Ideal candidates possess:... 

Gulfstream

RS Structural Mechanic IV Job at Gulfstream

 ...RS Structural Mechanic IV RS Structural Mechanic IV in GAC Appleton Unique Skills: At Gulfstream, our people are at the heart of everything we do. We believe in inspiring and empowering every individual to reach their fullest potential. From workforce development... 

Broad River Rehabilitation

Physical Therapist / PT / PRN Job at Broad River Rehabilitation

SKILLED NURSING FACILITY IN TAYLORSVILLE NC / NORTH CAROLINA Physical Therapist / RPT / PT / PRN We currently have a PRN opportunity for a Physical Therapist at our skilled nursing facility in TAYLORSVILLE, NC. Broad River Rehab is a rapidly growing therapy ...

CData Software

SAP S4 HANA Admin Job at CData Software

Deep knowledge of SAP Basis tasks: technical planning, installations and configurations (SAP S/4 HANA, FIORI, SLT, SOLMAN, SAP Router...), upgrades, OS/DB migrations, Unicode conversions for SAP NetWeaver platform, SSO configuration, installation of SSL certificates.... 

Edgewell Personal Care Brands, LLC

Production Operator - Pre-Grind (Night Shift 7:30pm - 7:30am) Job at Edgewell Personal Care Brands, LLC

 ...Want to work our full-time schedule of 15 days per month? Want every other weekend off make that a three-day weekend off! Want the opportunity to work today, get paid tomorrow? Enjoy a great work culture with competitive pay, benefits, and vacation? We...