SAP ABAP/SQL/HANA SQL(CDS/AMDP/Calc Views/Table functions_D_2543

You Will => Development & Transformation Design and develop complex ABAP Object-Oriented programs for data transformations Write clean, maintainable ABAP code and conduct extensive debugging and root cause analysis for performance Develop and maintain AMDP (ABAP Managed Database Procedures) SQL Script routines for high-performance data transformations pushed down to the HANA database layer Build and optimise CDS (Core Data Services) views including associations, annotations, hierarchies, and input parameters for consumption in BW Create and maintain HANA Table Functions for reusable, parameterised SQL logic integrated with CDS and AMDP Design and develop SAP HANA Calculation Views (graphical and SQL Script) for complex analytical scenarios — including Aggregation, Join, Union, Projection, and Rank nodes with input parameters, variables, and currency/unit conversions Optimise Calculation Views for push-down performance Integrate Calculation Views with BW CompositeProviders, Open ODS Views, and CDS-based consumption layers Enhancement & Innovation Lead re-engineering initiatives to migrate legacy ABAP and BW solutions to modern HANA-native technologies (AMDP, CDS, Calculation Views, Table Functions) Evaluate and adopt future-state technologies aligned with SAP's roadmap BW on HANA (Optional Skill / Nice to have but not mandatory) Implement, configure, and manage BW on HANA systems including InfoObjects, DataStore Objects (DSO/aDSO), InfoProviders, and CompositeProviders Support day-to-day BW on HANA operations including data load monitoring, error handling, and performance tuning Monitor and maintain process chains — proactively identify failures, take corrective action, and ensure timely data availability for business reporting Participate in period-end and month-end closing activities, ensuring all BW loads and transformations complete accurately and on schedule Overall responsibility: The candidate is in charge for the technical closing of AZTECH every month on which follows based on this billing data the whole group of Allianz SE closings. (Our solution generates not only reporting but more important real billing data with all consequences not to fulfil the timelines for the closings cycles of the company.) Your skills => University Graduate degree (mandatory) ABAP Development Hands-on experience in ABAP Object-Oriented programming — classes, interfaces, inheritance, design patterns (Factory, Strategy, Observer) Ability to write and handle User Exits for Data Sources and BEx queries Strong debugging skills for root cause analysis using ABAP Debugger, SQL Trace, and Performance Analysis tools HANA Development Ability to design, develop, and optimise SAP HANA Calculation Views (graphical and SQL Script) — Aggregation, Join, Union, Projection, Rank nodes Ability to write and optimise AMDP (ABAP Managed Database Procedures) SQL Script routines for data transformations 1.Creation of complex SELECT statements with aggregations, window functions, and sub-queries 2. Creation of complex JOINs across multiple tables (inner, left outer, cross joins) 3.Creation of REGEX (Regular Expression) searches on strings for pattern matching and data cleansing Experience with CDS (Core Data Services) Views — associations, annotations, hierarchies, and input parameters Experience creating and maintaining HANA Table Functions for reusable, parameterised SQL logic Excellent in communication and collaboration Should have Data Modelling skills – Knowledge of BW modelling(ADSO/Composite provider) (Optional) Optional skills JSON, PI/PO. Our benefits=> • We offer a hybrid work model which recognizes the value of striking a balance between in-person collaboration and remote working incl. up to 25 days per year working from abroad • We believe in rewarding performance and our compensation and benefits package includes a company bonus scheme, pension, employee shares program and multiple employee discounts (details vary by location) • From career development and digital learning programs to international career mobility, we offer lifelong learning for our employees worldwide and an environment where innovation, delivery and empowerment are fostered • Flexible working, health and wellbeing offers (including healthcare and parental leave benefits) support to balance family and career and help our people return from career breaks with experience that nothing else can teach About Allianz Technology => Allianz Technology is the global IT service provider for Allianz and delivers IT solutions that drive the digitalization of the Group. With more than 13,000 employees located in 22 countries around the globe, Allianz Technology works together with other Allianz entities in pioneering the digitalization of the financial services industry. We oversee the full digitalization spectrum – from one of the industry’s largest IT infrastructure projects that includes data centers, networking and security, to application platforms that span from workplace services to digital interaction. In short, we deliver full-scale, end-to-end IT solutions for Allianz in the digital age. D&I statement => Allianz Technology is proud to be an equal opportunity employer encouraging diversity in the working environment. We are interested in your strengths and experience. We welcome all applications from all people regardless of gender identity and/or expression, sexual orientation, race or ethnicity, age, nationality, religion, disability, or philosophy of life. Allianz Group is one of the most trusted insurance and asset management companies in the world. Caring for our employees, their ambitions, dreams and challenges, is what makes us a unique employer. Together we can build an environment where everyone feels empowered and has the confidence to explore, to grow and to shape a better future for our customers and the world around us. At Allianz, we stand for unity: we believe that a united world is a more prosperous world, and we are dedicated to consistently advocating for equal opportunities for all. And the foundation for this is our inclusive workplace, where people and performance both matter, and nurtures a culture grounded in integrity, fairness, inclusion and trust. We therefore welcome applications regardless of ethnicity or cultural background, age, gender, nationality, religion, social class, disability or sexual orientation, or any other characteristics protected under applicable local laws and regulations. Great to have you on board. Let's care for tomorrow.