Overview Role is to support the development of Data QualityReports / Rules for PGT - Projects and Sustain (Done inGDQ). Key Objectives for the role is to implement new andmaintain Data Quality reports and rules for core ,supplemental and transactional data from PGTperspective. Adherence to Pepsico Agile project methodology forPGT projects / Sustain. Detailed list of technical deliverables are as follows: 1. Build new Data quality reports / rules as per thebusiness data requirements from Global Data stewards /DMOs 2. Delivering new Data Quality reports / rules usingEHANA SQL queries, views , stored procedures 3. Maintaining the SQL server meta data for the DQreports / rules 4. Maintain and support existing DQ reports / rules(inventory of 2000+ DQ objects) and carry out necessary enhancements as requested 5. Modify Sustain Power BI Dashboards / other D&Arequirements Responsibilities 1. Requirements understanding for Data quality againstdifferent dimensions - Completeness / Validation /Consistency / Uniqueness etc 2. Deliver the Data Quality requirements through eitherreports / rules by designing and creating data models(EHANA views) to effi ciently handle large volumes of data. Developing efficient(time and memory) SQLScriptprocedures, functions, and views for data processingand analysis 3. Sustain reports / rules meta data management in SQL/ EHANA 4. Documentation Management for GDQ reports / rulesdeveloped / enhanced 5. Power BI Dashboards management created for dataquality metrics 6. Migrating the Data Quality reports / rules metadataand run engine from MS SQL server to CDQ (CloudInformatica Data Quality solution) - Pepsico's DQ enterprise solution Qualifications Years of Experience 1-2 years - SAP Technical 3-5 years - SQL experience 1-2 years - Enterprise HANA SQL Development 1+ year - MS Power BI Tech Skills SAP Technical (S4HANA) - Tables , views MS SQL SQLScript procedures, functions, and views, Jobs EHANA SQL SQLScript procedures, functions, and views, Power BI – Optional Data Modeling Non Tech Skills Good Communication Skills Requirements understanding Documentation Management Design and code review Differentiating Competencies Strong performer and team player Self motivated , takes responsibility in timely delivery of DQ requirements Ability to work in fast paced and agile environment