Technology Consulting-DP Azure Analytics Manager

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, Jaipur, 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.

Data Engineer  Azure Synapse and Data Modeling

 

Experience 8+ years

 

Job Description: We are looking for a Data Engineer with a strong foundation in SQL and data modelling to join our team. The ideal candidate will be responsible for creating Feature Engineering Tables (FETs) from Erwin, utilizing Azure Synapse, and working with Spark notebooks to support our data warehouse project.

 

Key Responsibilities:

·       Develop and maintain Feature Engineering Tables (FETs) using Erwin data modelling tools, ensuring adherence to the 3rd Normal Form (3NF) for optimal database design.

·       Design, build, and optimize data pipelines using Azure Synapse Analytics, ensuring efficient data flow and storage.

·       Utilize Spark notebooks within Azure Synapse for complex data processing and analytics tasks.

·       Collaborate with stakeholders to understand data requirements and translate them into technical specifications.

·       Implement and maintain data security and compliance protocols within the data warehouse environment.

·       Conduct data quality assurance and implement measures to ensure data accuracy and integrity.

·       Stay upto date with the latest trends and best practices in data engineering and Azure Synapse.

Qualifications:

·       Strong knowledge of SQL and data modeling, particularly in 3NF, to ensure efficient and scalable database structures.

·       Proficiency in Azure Synapse Analytics, with experience in data migration and querying large datasets.

·       Experience with Azure technologies, including Azure Data Factory, Azure Databricks, and Azure Data Lake Storage.

·       Familiarity with big data technologies (Hadoop, Hive, HBase, Spark, etc.).

·       Proficiency in Python, SQL, and advanced SQL techniques.

·       Understanding of both batch and streaming data architectures.

·       Deep knowledge of data warehousing, ETL development, and data modeling.

·       Experience with software engineering best practices, including agile methodologies and coding standards.

·       Knowledge of data management fundamentals and data storage principles.

·       Advanced statistics and machine learning model implementation is a plus.

This role requires a candidate who is not only technically proficient but also has a keen understanding of how to model data effectively for a data warehouse environment using Azure Synapse and Spark notebooks. If you have a passion for data engineering and are looking for a challenging role in a dynamic team, we would like to hear from you.

Equal employment opportunity information 

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.
B.E./B.Tech/Post Graduate