Data Engineer II

Overview

Data Engineer II role within the Insights & Enablement Data Engineering team in Services, based in Pune, India, building, enhancing and operating scalable, reliable and governed data solutions that support analytics and data-driven decision making.

What you'll do

• Develop, test, enhance and maintain data pipelines and data solutions that ingest, transform and deliver enterprise data for analytics and downstream consumption using Alteryx and Fabric pipelines.
• Work independently on defined elements of Data Engineering projects, applying established engineering standards and patterns while collaborating with experienced engineers on more complex designs.
• Develop and support solutions across the data ecosystem, including Microsoft SQL Server, Alteryx and the growing Microsoft Fabric platform, while contributing to the team's transition toward scalable cloud-native data engineering patterns.
• Monitor and troubleshoot identifiable data pipeline and processing issues by analyzing logs, identifying root causes and applying appropriate solutions to maintain data availability and reliability.
• Apply Data Engineering practices for data quality, security, validation, documentation and operational resiliency, helping ensure solutions are trustworthy and supportable in production.
• Collaborate with Data Engineering colleagues, business stakeholders and partner teams to understand requirements, review deliverables, assess technical feasibility and translate data needs into maintainable technical solutions.
• Document technical designs, data processes, reusable patterns and operational procedures while contributing to continuous improvement and knowledge sharing across the team.

What you'll need

• Intermediate/practical Data Engineering expertise, with the ability to independently develop, test, troubleshoot and maintain data pipelines and related components using established engineering practices.
• Proficiency with SQL and relational data concepts, including data transformation, data modeling, database design and building reliable solutions for analytical use cases.
• Practical experience with modern data integration and workflow orchestration concepts, including moving and transforming data across multiple enterprise data sources and platforms.
• Understanding of core practices related to data quality, data security, testing, monitoring, troubleshooting and operational reliability, applied throughout the Data Engineering lifecycle.
• Comfort working with technologies such as Microsoft SQL Server, Python and cloud-based data platforms.
• Effective collaboration and communication skills, including documenting technical solutions clearly, contributing to solution reviews and planning discussions, learning new technologies, and working with both technical and business stakeholders.

Nice to have

• Experience with Microsoft Fabric, Lakehouse architectures, Data Factory/Data Pipelines, OneLake or Alteryx.

Details

• Location: Pune, India.
• Information security responsibilities: abide by Mastercard's security policies and practices, ensure confidentiality and integrity of information accessed, report any suspected information security violation or breach, and complete all periodic mandatory security trainings.