AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
All Filters
986 KPMG India Jobs
Assistant Manager- Data Engineer
7-10 years
₹ 7.5 - 38.88L/yr (AmbitionBox estimate)
This is an estimate of the average salary range for this
position. It has not been reviewed by the company, and
the actual salary may differ.
Bangalore / Bengaluru
Assistant Manager- Data Engineer
KPMG India
posted 16d ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
- Responsibilities
- An experienced Microsoft Fabric ETL professional capable of integrating into KPMG’s existing processes and workflows.
- Collaborating with a global ETL and application development team to share knowledge, best practices, and ensure consistent development standards and to continually enhance development processes based on feedback and emerging industry trends.
- Utilizing modern development tools and frameworks currently in use by the KPMG development team (e.g., Azure Dev Ops).
- Ensuring timely reporting and proactive communication with the global development team leadership.
- Collaborate with business analysts and business stakeholders to understand data requirements, transformation rules, and relevant accounting business logic.
- Design, implement, and optimize ETL processes using Microsoft Fabric, working closely with an established, globally distributed development team.
- Understand the application architecture, tools, and the processes, established and make recommendations to meet needs by application.
- Ensure that data is efficiently and accurately processed from source systems into the Microsoft Fabric data layer and transformed across the various levels of transformation inside Fabric.
- Develop transformation logic to clean, enrich, aggregate, and otherwise modify data to meet business needs. Implement data validation and error handling procedures to ensure data integrity.
- Implement processes to load processed data into Microsoft Fabric data storage or previously worked in technologies like Azure Synapse, Azure Data Lake, etc. Optimize data loading processes to ensure performance and scalability.
- Design and deploy ETL pipelines and notebooks using Python and Pyspark within Microsoft Fabric.
- Collaborate with data architects to design the data architecture and models that align with the application’s requirements. Implement data schemas, star/snowflake schema designs for data warehouses, and OLAP cubes, as necessary.
- Optimize ETL processes for performance and resource utilization. Implement indexing, partitioning, and other performance enhancements to handle large volumes of data efficiently within Fabric.
- Develop and execute unit tests, integration tests, and end-to-end tests for ETL processes in Fabric. Troubleshoot and resolve issues, making improvements and adjustments as needed.
- Validate data accuracy and consistency throughout the ETL lifecycle.
- Create and maintain comprehensive documentation for ETL processes, data sources, data flow diagrams, and data models.
- Ensure documentation is up-to-date and accessible to relevant stakeholders.
- Ensure all data processing complies with relevant policies and standards.
- Required Experience
- High proficiency in Microsoft Fabric and related ETL tools (e.g., Azure Data Factory)
- Knowledge of database systems (e.g., SQL Server, Azure SQL Database, Synapse Analytics) and understanding of data warehousing concepts and architecture.
- Experience with data modeling and schema design.
- Familiarity with programming languages used in ETL processes (e.g., Python, Pyspark).
- Strong understanding of data engineering principles, including data modeling, data transformation, and data optimization.
- Strong SQL skills for data extraction, transformation, and querying.
- Knowledge of accounting principles and logic is highly beneficial.
- Working knowledge of US accounting principles and accounting logic would be highly beneficial and desired.
- Desired Certifications
- Microsoft Certified: Fabric Analytics Engineer Associate (strongly preferred)
- Microsoft Certified: Azure Data Engineer Associate
- Microsoft Certified: Azure Developer Associate
- Microsoft Certified: Azure Solutions Architect Expert
Employment Type: Full Time, Permanent
Read full job descriptionKPMG India Interview Questions & Tips
Prepare for KPMG India Assistant Manager roles with real interview advice
Top KPMG India Assistant Manager Interview Questions
Q1. What do you know about regression, classification. Explain deep learning
asked in
Assistant Manager interview
Q2. How did you do implementation in real time
asked in
Assistant Manager interview
What people at KPMG India are saying
Rating based on 474 Assistant Manager
reviews
Anonymous · Risk Management & Compliance
in Gurgaon / Gurugram
Likes
Timely promotions, lot of exposure and learning opportunities. Secondment opportunities allow to travel abroad.
- Skill development - Excellent
+1 more
Dislikes
Poor work life balance. Exhausting work hours. Limited manager support.
- Salary - Poor
+2 more
Assistant Manager salary at KPMG India
reported by
6.9k
employees
with 1-14
years exp.
₹10.8
L/yr - ₹32
L/yr
149%
more
than the average Assistant Manager Salary in India
View more details
What KPMG India employees are saying about work life
based on 5.3k employees
Flexible timing
Monday to Friday
No travel
Day Shift
KPMG India Benefits
View more benefits
Compare KPMG India with
Cognizant
Compare
PwC
Compare
Capgemini
Compare
Compare
TCS
Compare
HCLTech
Compare
Deloitte
Compare
Ernst & Young
Compare
Accenture
Compare
Bain & Company
Compare
McKinsey & Company
Compare
BCG
Compare
IBM
Compare
KPMG Global Services
Compare
ZS
Compare
Mercer
Compare
Willis Towers Watson
Compare
Guidehouse
Compare
WSP
Compare
Mott MacDonald
Compare
Similar Jobs for you
Oracle Fusion Finance Functional
3-8 Yrs
Gurgaon / Gurugram, Bangalore / Bengaluru, Mumbai
Share an Interview