Tech Lead - ETL Snowflake

YASH Technologies, Inc.; Pune District; Presencial; INR 1.200.000 - 2.400.000; Jornada completa

Descripción de la vacante

YASH Technologies is seeking a seasoned Lead ETL Developer / Data Engineer in Pune to design, develop, and optimize scalable data pipelines and data warehouse solutions. The ideal candidate will excel in SQL, Snowflake, ETL processes, and data engineering principles, with a strong focus on performance tuning and code optimization.

You will lead the data transformation initiatives, collaborate with cross‑functional teams, and contribute to delivering high‑quality, scalable data platforms in a

Formación

• Experience with SQL development and query optimization in SQL Server and Snowflake.
• Strong understanding of ETL/ELT processes and data engineering best practices.
• Knowledge of data warehousing concepts (STAR/Snowflake schemas) and performance tuning.

Responsabilidades

• Develop and maintain ETL/ELT pipelines for data integration and transformation.
• Design and optimize data warehouse solutions using Snowflake.
• Write and tune complex SQL queries, stored procedures, and data transformations.
• Implement data models, fact/dimension tables, and SCD frameworks.
• Ensure data quality, reliability, and performance across data platforms.
• Collaborate with business and technical teams to deliver scalable data solutions.
• Troubleshoot production issues and optimize ETL workflows.

Conocimientos

SQL Server

Snowflake

ETL/ELT Development

Data Warehousing

Data Engineering

Performance Optimization

Herramientas

Azure Data Factory (ADF)

Power BI

Microsoft Fabric

Descripción del empleo

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

YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation.

At YASH, we’re a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth – bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future.

We are looking forward to hireSnowFlake Professionals in the following areas :

Lead ETL Developer / Data Engineer

Experience: 7 + Years

Key Skills: SQL Server, Snowflake, ETL/ELT Development, Data Engineering, Data Warehousing, Performance Optimization

Job Summary

We are seeking an experienced ETL Developer / Data Engineer to design, develop, and optimize scalable data pipelines and data warehouse solutions. The ideal candidate should have strong expertise in SQL, Snowflake, ETL processes, and data engineering principles, with a focus on performance tuning and code optimization.

Responsibilities

• Develop and maintain ETL/ELT pipelines for data integration and transformation.
• Design and optimize data warehouse solutions using Snowflake.
• Write and tune complex SQL queries, stored procedures, and data transformations.
• Implement data models, fact/dimension tables, and SCD frameworks.
• Ensure data quality, reliability, and performance across data platforms.
• Collaborate with business and technical teams to deliver scalable data solutions.
• Troubleshoot production issues and optimize ETL workflows.

Required Skills

• Strong SQL development and query optimization experience with SQL SERVER , Snowflake
• Hands‑on experience with Snowflake and cloud data platforms.
• Solid understanding of Data Warehousing concepts (Star Schema, Snowflake Schema, SCD).
• Experience building scalable ETL/ELT pipelines.
• Strong knowledge of data engineering best practices and performance tuning.
• Experience with source‑to‑target mapping and data validation.

Good to Have

• Experience with Microsoft Fabric (Data Factory, Lakehouse, Data Warehouse, Notebooks, Pipelines, and OneLake).
• Experience in developing and optimizing Power BI dashboards, semantic models, DAX measures, and reports.
• Knowledge of Fabric‑Snowflake integration and modern analytics architectures. Experience with ETL/ELT tools such as Azure Data Factory (ADF)
• Exposure to Azure, AWS, or GCP cloud platforms.

At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment.We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale.

Our Hyperlearning workplace is grounded upon four principles

• Flexible work arrangements, Free spirit, and emotional positivity
• Agile self-determination, trust, transparency, and open collaboration
• All Support needed for the realization of business goals,
• Stable employment with a great atmosphere and ethical corporate culture