Lighthouse Azure Data Platform Assistant Manager
KPMG
Bengaluru, Karnataka, India
JOB DESCRIPTION About KPMG in India KPMG entities in India are professional services firm(s). These Indian member firms are affiliated with KPMG International Limited. KPMG was established in India in August 1993. Our professionals leverage the global network of firms, and are conversant with local laws, regulations, markets and competition. KPMG has offices across India in Ahmedabad, Bengaluru, Chandigarh, Chennai, Gurugram, Hyderabad, Jaipur, Kochi, Kolkata, Mumbai, Noida, Pune, Vadodara and Vijayawada. KPMG entities in India offer services to national and international clients in India across sectors. We strive to provide rapid, performance-based, industry-focused and technology-enabled services, which reflect a shared knowledge of global and local industries and our experience of the Indian business environment. EOE KI : KPMG India has a policy of providing equal opportunity for all applicants and employees regardless of their color, caste, religion, age, sex/gender, national origin, citizenship, sexual orientation, gender identity or expression, disability, or other legally protected status. KPMG India values diversity and we request you to submit the details below to support us in our endeavor for diversity. Providing the below information is voluntary and refusal to submit such information will not be prejudicial to you. RESPONSIBILITIES Role & Responsibility Evaluating, developing, maintaining and testing data engineering solutions for advanced analytics projects. Implement processes and logic to extract, transform, and distribute data across one or more data stores from a wide variety of sources Distill business requirements and translate into technical solutions for data systems including data warehouses, cubes, marts, lakes, ETL integrations, BI tools or other components. Strong knowledge of replication processes, change data capture processes, T-SQL, and Dynamic SQL skills Participate in deep architectural discussions to build confidence and ensure customer success when building new solutions and migrating existing data applications on the Azure platform. Optimize data integration platform to provide optimal performance under increasing data volumes Support the data architecture and data governance function to continually expand their capabilities Support the automation of requirements of database deployments using Azure DevOps Experience in development of Solution Architecture for Enterprise Data Lakes (applicable for AM/Manager level candidates) Should have exposure to client facing roles Strong communication, inter-personal and team management skills THE INDIVIDUAL data brick data warehouse Proficient in any object-oriented/ functional scripting languages: Java, Python, C# etc. Design and develop new solutions on the Azure Cloud Platform specifically for Azure SQL Data Warehouse/DB, Azure Data Factory, Analysis Services, Azure Data Lake Store / Blob Hands-on experience working in complex data warehouse implementations using Azure SQL Data warehouse, Azure Data Factory and Azure SQL Database. Strong t-SQL skills with experience in Azure SQL DW Experience in creating data pipelines using Azure Data Factory, Polybase and U-SQL. Experience in developing data pipelines to transform, aggregate and or process data using Azure Databricks platform Hands-on experience in implementing Azure Cloud data warehouses, Azure and No-SQL databases and hybrid data ingestion scenarios Experience in creating tabular models (DAX) in Visual Studio. QUALIFICATIONS BE/BTech/MCA. 4.5+ to 9 years of strong experience. 2+ years experience in ADF, ADLS & Databricks with pyspark. Education 60% above throughout academics One 3 years (at least) regular course is must either Diploma or Graduation. Azure DP-203 Certification is preferred.