BENGALURU · FULLTIME
Data Analyst L5
Diageo
Bengaluru · onsite · Posted 30d ago
Sourced from
Not disclosedFresherfulltimeBengaluru
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.5s
- Found the form on Foundit · 15 questions to answer1.4s
- Decided the answers for all of them2.6s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
- Data Discovery: Identify the SAP tables and fields used for existing Data Quality(DQ) rules & reports and locate the corresponding data in Databricks
- Data Validation: Validate data across all the layers(bronze, silver,etc) in Databricks for completeness, structure and availability of required fields
- DQ Rule Migration & BUILD: Select and build a set of existing DQ rules in Databricks as part of the PoC
- PoC Testing & Reconciliation: Execute the rules in Databricks and compare results with the existing DQ results, investigating and resolving differences
- End-to-End Rule Migration: Following the PoC, migrate / BUILD the agreed As-Is DQ rules to data bricks, including SQL logic, data mappings, rule outputs and required transformations
- Data & Rule Validation: Perform end-to-end validation of source data, DQ rules, results and defects in Databricks to ensure the migrated process produces expected outcomes
- DQ Reporting: Support the development of DQ outputs, KPIs and dashboard reporting from Databricks, including validation of report results
- Documentation & BAU Handover: Document data mappings, DQ rules, validation results and migration processes
- SQL & Pyspark/Python knowledge
- Experience in Data Quality / Data Validation.
- Experience working with SAP data, preferably master data
- Good understanding of SAP tables
- Experience with Databricks platform
- Experience in data reconciliation and comparison between different data sources.
- Ability to translate DQ requirements/rules into technical SQL or Python logic
- Experience in DQ rule testing, defect analysis and troubleshooting
Sourced from foundit
Section · 02
Skills
data qualitySAPdata reconciliationDatabricksPysparkPythonSQLData Validation
Section · Company
About Diageo
Diageo
Beverage
3k+
employees
1997
29 years old
London
United Kingdom (UK)
About
Global spirits leader with over $20 billion revenue, home to iconic brands across 180+ markets.
Industries
Manufacturing
Employee ratings
1,211 reviews
3.8/ 5
Culture
3.8
Career growth
3.1
Work-life
3.8
Employees rate it well for
Work Culture154Work Life Balance133Senior Management91Salary91Career Growth78
Find them on