Senior Data Engineer - ETL & Data Analytics Specialist
Vertiv Energy Pvt Ltd
Apply on company website
Senior Data Engineer - ETL & Data Analytics Specialist
Vertiv Energy Pvt Ltd
Pune
Not disclosed
Job Details
Job Description
IT Data Analytics Specialist (ETL Developer)
Job Title: Senior Data Engineer
Function/Department: Global Data Analytics
Reports to: Data Analytics Supervisor
Location: Pune
Overview
We are seeking a highly skilled Senior Data Engineer with deep expertise in Snowflake and strong hands‑on experience with Matillion or similar ETL/ELT tools. The ideal candidate will design, build, and optimize scalable data pipelines, ensure data quality, and contribute to the modernization of our data architecture.
This role is ideal for someone who thrives in complex, enterprise‑level environments, collaborates effectively with cross‑functional teams, and is passionate about high‑quality, reliable data solution.
Key Responsibilities
Data Architecture & Engineering
- Design, build, and maintain scalable ETL/ELT pipelines using Matillion or comparable tools (Informatica, Talend, dbt, ADF, etc.).
- Develop and optimize Snowflake objects, including warehouses, schemas, tables, views, streams, tasks, and stored procedures.
- Implement robust data ingestion frameworks for batch and real‑time data flows.
- Optimize Snowflake performance through clustering, caching, micro-partitioning, and resource monitoring.
Data Quality & Governance
- Ensure the integrity, availability, and reliability of data across all systems.
- Define and automate data validation, profiling, and quality checks.
- Collaborate with data governance teams to implement standards and policies.
Collaboration & Delivery
- Work closely with data analysts, data scientists, product teams, and business stakeholders to understand requirements and translate them into technical solutions.
- Lead code reviews, provide mentorship, and support best practices across the engineering team.
- Contribute to architectural decisions and participate in strategic data roadmap planning.
Automation & DevOps
- Build CI/CD pipelines for data workflow deployments.
- Develop reusable frameworks or templates to increase efficiency of future data engineering builds.
- Implement monitoring, alerting, and operational excellence practices for data pipelines.
Required Qualifications
- 4 to 7 years of experience as a Data Engineer or similar role.
- Strong expertise with Snowflake (SQL, performance tuning, data modeling, warehouse configuration).
- Hands-on experience with Matillion or other ETL/ELT tools (e.g., Talend, Informatica, dbt, Azure Data Factory).
- Advanced SQL skills; ability to write complex queries and optimize them.
- Strong understanding of data modeling, dimensional models, and data warehouse concepts.
- Experience with cloud platforms such as AWS, Azure, or GCP.
- Experience in Oracle Business Application (ERP) is a plus.
- Proficiency in Python, Airflow, or other orchestration tools.
- Familiarity with Git, CI/CD, and general DevOps practices.
Experience Level
Senior LevelJob role
Work location
Pune, India
Department
Data Science & Analytics
Role / Category
Data Science & Machine Learning
Employment type
Full Time
Shift
Day Shift
Job requirements
Experience
Min. 4 years
About company
Name
Vertiv Energy Pvt Ltd
Job posted by Vertiv Energy Pvt Ltd
Apply on company website