Role Overview
YASH Technologies is seeking a Sr. Software Engineer – ETL & Snowflake Data Engineer to join its data engineering practice in Pune, Maharashtra, India. Focused on building and optimizing scalable cloud data warehouses and high-throughput ETL/ELT pipelines, you will partner with business and technical teams to design resilient dimensional data models and drive query performance across Snowflake and SQL Server environments.
Core Responsibilities
- ETL/ELT Pipeline Engineering: Design, build, and maintain scalable data integration and transformation pipelines ensuring end-to-end data reliability and quality.
- Snowflake Data Warehouse Architecture: Architect, implement, and optimize cloud data warehouse solutions using Snowflake—building fact/dimension tables and Slowly Changing Dimension (SCD) frameworks.
- SQL Query & Performance Optimization: Write and tune complex SQL queries, stored procedures, and data transformations across SQL Server and Snowflake for maximum execution efficiency.
- Production Troubleshooting & Collaboration: Perform source-to-target mapping and data validation, troubleshoot production ETL bottlenecks, and collaborate with cross-functional stakeholders on enterprise analytics delivery.
Qualifications & Requirements
- Educational Background: Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related discipline.
- Professional Experience: 4+ years (4–8 years) of hands-on experience as an ETL Developer or Data Engineer working with Snowflake and SQL Server.
- Core Data Engineering Stack: Strong proficiency in Snowflake, SQL Server, complex SQL optimization, ETL/ELT pipeline design, source-to-target mapping, and Data Warehousing concepts (Star Schema, Snowflake Schema, SCD).
- Preferred Qualifications: Hands-on exposure to Microsoft Fabric (Data Factory, Lakehouse, Notebooks, OneLake), Azure Data Factory (ADF), Power BI (semantic models and DAX), and cloud platforms (Azure, AWS, or GCP).
- Work Mode & Location: Full-time role based in Pune, Maharashtra, India.
About YASH Technologies
YASH Technologies is a global technology integrator helping enterprises reimagine operating models, optimize costs, and accelerate digital transformation. Grounded in a Hyperlearning culture of agile collaboration, continuous upskilling, and flexible work arrangements, YASH empowers technologists to deliver impactful cloud, data, and enterprise solutions worldwide.