Sr. Data Engineer

Mastek Limited; India; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

Mastek Limited in India is seeking a Senior Data Engineer with 10–12 years of experience in data engineering. The role focuses on building scalable data integration and processing solutions using SnapLogic and Snowflake, with emphasis on automation and analytics.

The candidate will design and optimize ETL/ELT pipelines, collaborate with architects and analysts, and contribute to data governance and production support. Strong hands-on Snowflake and SnapLogic skills are mandatory.

Qualifications

• 10–12 years of overall Data Engineering experience.
• Hands-on with SnapLogic for enterprise data integration and pipeline development.
• Strong Snowflake experience including data warehousing, SQL, and modeling.
• Proficient in Python for data processing and automation.

Responsibilities

• Design, develop, and maintain robust data integration pipelines using SnapLogic.
• Develop data solutions using Snowflake as the cloud data warehouse.
• Build scalable ETL/ELT pipelines from multiple sources.
• Develop data processing and automation solutions using Python.
• Design data models, transformations, and workflows in Snowflake.
• Perform Snowflake performance tuning and optimization.
• Maintain SnapLogic pipelines, integrations, mappings, and error handling.
• Schedule and manage batch jobs using Control‑M.
• Troubleshoot data pipeline failures and production incidents.
• Implement data quality, logging, monitoring, and exception-handling.

Skills

Data engineering

Analytical thinking

Mentoring

Stakeholder management

Agile/Scrum

Education

Bachelor's/Master's in CS/IT/Engineering

Tools

SnapLogic

Snowflake

Python

Control‑M

SQL

CI/CD

Git

ETL/ELT

Job description

Select how often (in days) to receive an alert:

Job Title

Senior Data Engineer – SnapLogic & Snowflake (Sr. Data Engineer/Sr. BI Developer-DA&A)

Expected Work Experience

10–12 Years

Job Location

India

Job Summary

We are looking for an experienced Senior Data Engineer with 10–12 years of experience in data engineering and strong hands‑on expertise in SnapLogic and Snowflake. The ideal candidate will be responsible for designing, developing, and supporting scalable data integration and data processing solutions using modern cloud data technologies, with a focus on data automation and analytics. SnapLogic and Snowflake are key skillsets for this position and are mandatory. Candidate must have relevant experience of 8 to 12 Years.

Key Responsibilities

• Design, develop, and maintain robust data integration pipelines using SnapLogic.
• Develop and optimize data solutions using Snowflake as the cloud data warehouse.
• Build scalable and reliable ETL/ELT pipelines to integrate data from multiple source systems.
• Develop data processing and automation solutions using Python.
• Design and implement efficient data models, transformations, and data workflows in Snowflake.
• Perform Snowflake performance tuning, query optimization, and warehouse optimization.
• Develop and maintain SnapLogic pipelines, integrations, mappings, transformations, and error‑handing mechanisms.
• Schedule, monitor, and manage batch jobs and enterprise workflows using Control‑M.
• Troubleshoot data pipeline failures, integration issues, and production incidents.
• Implement data quality, validation, logging, monitoring, and exception‑handling mechanisms.
• Collaborate with architects, business analysts, application teams, and other stakeholders to understand data requirements.
• Participate in code reviews, technical design discussions, testing, deployment, and production support.
• Ensure data engineering solutions follow organizational standards for security, scalability, performance, and maintainability.
• Provide technical guidance and mentoring to junior and mid‑level data engineers.
• Contribute to data engineering initiatives within Data Automation & AI and Data Engineering - DataAnalytics - DataBricks (Technical) environments.
• Work effectively within Agile/Scrum development frameworks for data engineering and BI delivery.

Other Capabilities

• Strong analytical and problem‑solving skills.
• Ability to independently design and deliver data engineering solutions.
• Strong communication and stakeholder management skills.
• Ability to work effectively in a collaborative, cross‑functional environment.
• Strong troubleshooting and production‑support capabilities.
• Ability to mentor and support junior and mid‑level engineers across DA&A initiatives.

Qualifications and Skills

• 10–12 years of overall Data Engineering experience.
• Strong hands‑on experience with SnapLogic for enterprise data integration and pipeline development.
• Strong hands‑on experience with Snowflake, including data warehousing, SQL, performance tuning, optimization, and data modeling.
• Strong programming experience in Python for data processing and automation.
• Hands‑on experience with Control‑M for enterprise job scheduling, workflow orchestration, and monitoring.
• Strong understanding of ETL/ELT concepts and data integration patterns.
• Strong SQL development and query optimization skills.
• Experience working with relational and cloud‑based data sources.
• Understanding of data warehouse architecture and dimensional/data modeling.
• Experience with data pipeline monitoring, troubleshooting, and production support.
• Knowledge of cloud data engineering and modern data platform architecture is preferred.
• Experience working in Agile/Scrum development environments.
• Experience with Data Engineering - Data Analytics - DataBricks (Technical) solutions is an advantage.
• Bachelor’s or Master’s degree in Computer Science, Information Technology, Engineering, or a related field.
• Experience working on large‑scale enterprise data engineering projects.
• Experience with CI/CD, version control, and automated deployment processes.
• Good understanding of data governance, security, and data quality practices.
• Must‑have skills: SnapLogic, Snowflake, Python, Control‑M.
• Important: Candidates without strong hands‑on SnapLogic and Snowflake experience should not be considered for this position.