An enterprise Data-warehouse solution implemented in Big Data for a banking client. Solution aimed at replacing existing legacy system with new age data analytics technologies to make the system more versatile. Developed and designed by Accenture UK and Accenture India. 1. Requirement gathering, designing, documentation & analysis of the key deliverables for the system migration. 2. Proficient in writing complex hive queries while implementing concepts such as bucketing, partitioning with Array, Maps & Structs in Hive. 3. Designed and developed Scala APIs using Apache Spark to load data with data validation and data quality rules. 4. Designed and developed Scala codes to perform ETL on data and load data in slowly changing dimension formats in Hive Tables. 5. Designed and developed the workflow to automate the service-now defect registering portal for assignment of incidents and thus removing the manual efforts as a part of 24*7 monitoring in order to avoid missing the SLA.