HANA Technical Specialist

Apply now »

Date: 25-Nov-2022

Location: Bangalore, KA, IN

Company: Alstom

Req ID:276986 

We create smart innovations to meet the mobility challenges of today and tomorrow. We design and manufacture a complete range of transportation systems, from high-speed trains to electric buses and driverless trains, as well as infrastructure, signalling and digital mobility solutions. Joining us means joining a truly global community of more than 75 000 people dedicated to solving real-world mobility challenges and achieving international projects with sustainable local impact.   

OVERALL PURPOSE OF THE ROLE

He/She will be responsible to demonstrate a broad understanding of HANA architecture and deliver deployment scenarios of SAP HANA. Provide business-driven end-to-end solutions to meet our customers’ needs in gaining insights from our enterprise data around the Native HANA platform.

He/She will also be responsible to monitoring, performance tuning, and troubleshooting of SAP HANA models and systems.

The HANA technical specialist reports to Datalake & datawarehouse Domian lead


STRUCTURE, REPORTING, NETWORKS & LINKS
Organization Structure

CITO
      |-- VP Business Solutions & Innovation
         |-- Digital Factory Director
            |-- Head  of Analytics Platform

               |--Datalake & datawarehouse Domain lead
                  |-- HANA technical Specialist


Organizational Reporting: Reports to Datalake & datawarehouse Domian lead


Networks & Links
Internally: Shared Services Team, Digital Platform Team. Innovation Team ,Application Platform Owners, Business process owners, Infrastructure team
Externally: Third-party technology providers, Strategic Partners

Direct reports: No

 

Location: Position will be based in Bangalore
Willing to travel occasionally for onsite meetings and team workshops as required

 


RESPONSIBILITIES :-

Solutioning & Delivery

  • Develop and Maintain Data Modeling and Data Management Architecture Strategies. Produce data Architectural design, develop functional & technical design document specifications to meet functional requirements for reporting and analytics. Provide Solutions for Complex Initiatives and perform data feasibility studies as well as support business in pre-studies.
  • Apply concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability.
  • Work closely with architects to ensure ADD (Architecture Design Document) are all up-to-date, complete the ADD for each new improvement of the Platform Maintain the CMDB and all the documents repository for all the platforms.

Run Support

  • Monitor the availability status of the SAP Native HANA database important system metrics such as the CPU usage, memory consumption and disk utilization.
  • Ensure critical services are running, Monitor transactions, cache and system alerts. Test the workload and expensive statements.

Contribution and validation of Projects scoping

  • Provide technical expertise to propose effort estimates, work breakdown structures and technical resource planning for proposed and current work, to support the Demand Management process. Review the ongoing implementation solution for improvement opportunities.
  • Manage gates validations, Collaborate with the Shared Service Center on the scoping of complex uses cases delivered in Service Mode, Collaborate with the Project Delivery team on the scoping of complex uses cases delivered in Project Mode.
  • Provide assistance, coach ,mentor, on-the-job training with issues needing technical expertise or complex systems and/or programming knowledge.
  • Ensure collaboration Functional Architects as business cases are setup for each initiative, collaborate with other analytics team to drive and operationalize analytical deployment. Maintain clear and coherent communication, both verbal and written, to understand data needs and report results.
  • Strong ability to take the lead and be autonomous Proven planning, prioritization, and organizational skills. Ability to drive change through innovation & process improvement. Be able to report to management and stakeholders in a clear and concise manner.

EDUCATION
Bachelor’s/Master’s degree in Computer Science Engineering /Technology or related field

Experience

  • 8  years of experience with SAP- Analytics and technologies like SAP HANA, SAP BW/BO,ETL,ABAP knowledge, SQL scripting, Data Analytics.
  • With minimum 3+ years' experience on Native HANA 2.0 modelling (hands on), 1 full life cycle HANA implementation is must.
  • With minimum 2+ Years of SQL / PL SQL experience, Stored Procedures, Function Calls, Designing tables, data loads. Ability to use SQL Script debugger, ability to use functions (including table and scalar functions),triggers, libraries in SQL Script

TECHNICAL COMPETENCIES

  • Must be able to provide strong recommendations on Performance Tuning, optimize the HANA environment and Best practices.
  • Strong experience to enable Data Provisioning by using standard SAP integration technologies (SDI, SLT, SDA & SDI)
  • Strong experience on Native HANA modelling via new XS Advanced (XSA) development environment using SAP Web IDE for SAP HANA, graphical calculation views, input parameters and variable of calculation views, Join types, and table functions.
  • Ability to develop test plans to complete unit testing of technical deliverables.
  • Ability to monitor the availability status of the SAP Native HANA database important system metrics such as the CPU usage, memory consumption and disk utilization.
  • Ability to ensure critical services are running, Monitor transactions, cache and system alerts. Test the workload and expensive statements
  • Hands on experience in Designing, Developing & Maintaining advanced SAP BO reports using WEBI / Rich Client Experience in creating & maintaining advanced visualizations.
  • Ability to implement SAP security to prevent unauthorized access to data models. Strong knowledge on design and configuration of SAP HANA modelling Security authorization roles, use analytic privileges.
  • Strong techno-functional knowledge in one or more functional areas (Sales, Logistics, P2P, Production planning, Procurement, Finance(AR, AP, GL), Engineering and FI areas
  • SAP Certification : Application Associate - SAP HANA 2.0 SPS04 is an added advantage.
  • Exposure to SOLMAN 7.2 charm tool is an added advantage.
  • Have fair knowledge on Administrative maintenance tasks, Application Security, Patch updates and Upgrades is an added advantage.
  • Strong exposure working on Cloud BI implementation and architecture Analytical solution on Azure cloud platform. (AWS, Microsoft Azure, or Google Cloud) is an added advantage.
     
    BEHAVIORAL COMPETENCIES
    The candidate should demonstrate:
    • Structured thought process and articulation Critical thinking and problem-solving skills
    • Analytical bent of mind and be willing to question the status quo Possess excellent soft skills.
    • Ability to create a strong network of relationships among peers, internal partners, and external constituencies
    .
    • Individual contributor and proactive and have leadership skills. Be able to guide and drive team from technical stand point.

    • Excellent written, verbal, and interpersonal skills. Self-motivated, quick learner is a must.
    • Be fluent in English
    • Be able to influence and deliver

An agile, inclusive and responsible culture is the foundation of our company where diverse people are offered excellent opportunities to grow, learn and advance in their careers.  We are committed to encouraging our employees to reach their full potential, while valuing and respecting them as individuals.   

 

 

Job Type:​Experienced​


Job Segment: Database, SQL, SAP, ERP, Computer Science, Technology