Data Hub Developer

Recruiter
Fujitsu.
Location
India, Chennai, Chennai (CHET)
Salary
Competitive
Posted
25 Jul 2019
Closes
15 Sep 2019
Ref
IN79019
Sector
Consultancy
Job Role
Intelligence
Job Type
Permanent
Data Hub AMS Support (SAP HANA and Teradata) Job Description (Summary) The position will develop in and support the ongoing maintenance and performance optimization for Bridgestone�s two main data hubs (SAP HANA �Sidecar� and Retail�s Teradata) at both the data and the access layers. HANA Sidecar: Applications are developed in HANA JavaScript language (xsjs) and publish data via API request / response sequence in JSON format. The work includes building and maintaining centralized enterprise APIs to publish, to internal and external subscribers with data acquired from heterogeneous multi-source ERP systems into central Hana Side Car platform. The xsjs development will include direct calls to the HANA database layer using xsds calls and stored proc calls. The development may also include formatting requests and responses to/from other APIs published on internal and external systems. Retail Teradata: This data hub on Teradata provides the central repository for retail systems (2200+ stores) transactional and master data, including the cleansed and de-duped central repository for consumer master data. Teradata provides data to multiple internal and external applications and ADW (data warehouse on HANA). Web Services calls are made (RTQ) to this datahub from store�s POS, as well as mobile applications, and an invoice search function using Apache Solr. Responsibilities General � Monitors system wide performance and uptime; diagnoses issues and proposes remediation. � Optimizes performance of databases, queries, views, services, API�s, RTQ�s and other data access services. � Monitors success/failures of data imports and extracts to/from data hubs, trouble-shoots, and escalates problems to appropriate teams. � Provides backup and disaster recovery support as requested � Participates in new release, patch and upgrade planning, testing, and execution. � Responsible for opening, responding to, and resolving/closing all assigned incidents/tickets within required SLA�s. � Follows Bridgestone change management, security, documentation policies, and best practices (per technology). � Maintains and documents support and run books for sustained operations � Performs unit testing and documents results, as well as supports UAT and Integration testing � Takes direction from the Data Hub Lead as well as the Sr Data Hub Developer HANA Sidecar: � Contributes to the design of and completes development of xsjs API applications, whether new development or maintenance of existing API applications, to meet stated technical and business requirements in the HANA Solution/Tech Specification. � Maintains existing web service application solutions on native SAP HANA to be consumed by public and private API subscribers � Contributes to the design of and completed development of HANA table design and models (views). � Performs validations against HANA and source system data tables to ensure quality results � Performance tunes code to provide results to meet under 1 second SLA response times Retail Teradata: � Sets-up and monitors users, profile, roles and workload management � Assist users with report and spool problems � Performs root clause analysis on reported data problems � Automates administration and housekeeping tasks with co-ordination between application and support users � Monitors production workloads, provides and communicates with tier level support to resolve machine critical failures. � Completes database refresh/cloning and recovery procedures � Develops and unit tests new views or view changes as per furnished technical specifications � Creates and executes recurring and ad hoc user data requests. Basic Qualifications � Bachelors Degree in Computer Science, Engineering or Business Administration or related field of study; or any equivalent combination of experience and training. � A minimum of 5 years experience supporting large-scale database and data warehouse environments, including columnar and in-memory databases. � Experience writing complex SQL and stored procedures is strongly preferred � Experience developing SAP HANA Data Models (Views) using HANA Studio and Web IDE. � A minimum of 6 years experience with JavaScript development, with 3 of those years in HANA xsjs application development. Must have knowledge of SAP SQL and familiarity with HANA Data Model integration and stored procedures in a HANA environment as well as knowledge of xml and JSON development techniques. � Experience with Teradata: o Optimizer o Tools and Utilities (Fastload, MultiLoad, FastExport , TPT, BTEQ) o TASM Workload Management or TWIM o Viewpoint o PDCR and DBQL � Demonstrated ability to work well in a team environment � Excellent English communication skills (written and verbal). Desired Qualifications � Familiar with SAP BODS Data Quality transforms � Understands data modeling concepts � Experience with data acquisition, integration, loading and ETL processes and systems (batch, streaming, real-time) � Experience wit N/A

Similar jobs

Similar jobs