Tech Lead

Tech Lead - MS SQL,Snowflake,ADF Job

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 hire MS SQL Professionals in the following areas :

Experience

8-10 Years

Job Description

Job Summary:
We are looking for a skilled SQL Server, Snowflake Developer to join our data and analytics team.
The ideal candidate will have strong experience in developing and maintaining data solutions using SQL Server, Snowflake, ADF.
You will play a key role in building scalable data pipelines, designing data models, and delivering business intelligence solutions.

Key Responsibilities:
-Develop and optimize complex SQL queries, stored procedures, and ETL processes in SQL Server.
-Design and implement data pipelines and models in Snowflake.
-Build and maintain SSIS packages for ETL workflows.
-Design ADF pipeline to migrate data from different sources
-Migrate and integrate data between on-premise SQL Server and Snowflake cloud platform.
-Collaborate with business analysts and stakeholders to understand reporting needs.
-Ensure data quality, performance tuning, and error handling across all solutions.
-Maintain technical documentation and support data governance initiatives.

Required Skills & Qualifications:
years of experience with Database Development (MS-SQL/SQL).
years of hands-on experience with Snowflake.
years of hands-on experience with ADF
years of hands-on Alteryx (good to have)
-Strong understanding of ETL/ELT processes and data warehousing principles.
-Experience with data modeling, performance tuning, and data integration.
-Familiarity with Azure cloud platforms is a plus.
-Good communication and problem-solving skills.

Required Technical/ Functional Competencies

Domain/ Industry Knowledge:

• Basic knowledge of customer's business processes- relevant technology platform or product.
• Able to prepare process maps, workflows, business cases and simple business models in line with customer requirements with assistance from SME and apply industry standards/ practices in implementation with guidance from experienced team members.

Requirement Gathering and Analysis:

• Working knowledge of requirement management processes and requirement analysis processes, tools & methodologies.
• Able to analyse the impact of change requested/ enhancement/ defect fix and identify dependencies or interrelationships among requirements & transition requirements for engagement.

Product/ Technology Knowledge:

• Working knowledge of technology product/platform standards and specifications.
• Able to implement code or configure/customize products and provide inputs in design and architecture adhering to industry standards/ practices in implementation.
• Analyze various frameworks/tools, review the code and provide feedback on improvement opportunities.

Architecture tools and frameworks:

• Working knowledge of architecture Industry tools & frameworks.
• Able to identify pros/ cons of available tools & frameworks in market and use those as per Customer requirement and explore new tools/ framework for implementation.

Architecture concepts and principles:

• Working knowledge of architectural elements, SDLC, methodologies.
• Able to provides architectural design/ documentation at an application or function capability level and implement architectural patterns in solution & engagements and communicates architecture direction to the business.

Analytics Solution Design:

• Knowledge of statistical & machine learning techniques like classification, linear regression modelling, clustering & decision trees.
• Able to identify the cause of errors and their potential solutions.

Tools & Platform Knowledge:

• Familiar with wide range of mainstream commercial & open-source data science/analytics software tools, their constraints, advantages, disadvantages, and areas of application.

Required Behavioral Competencies

Accountability:

• Takes responsibility for and ensures accuracy of own work, as well as the work and deadlines of the team.

Collaboration:

• Shares information within team, participates in team activities, asks questions to understand other points of view.

Agility:

• Demonstrates readiness for change, asking questions and determining how changes could impact own work.

Customer Focus:

• Identifies trends and patterns emerging from customer preferences and works towards customizing/ refining existing services to exceed customer needs and expectations.

Communication:

• Targets communications for the appropriate audience, clearly articulating and presenting his/her position or decision.

Drives Results:

• Sets realistic stretch goals for self & others to achieve and exceed defined goals/targets.

Resolves Conflict:

• Displays sensitivity in interactions and strives to understand others' views and concerns.

Certifications Mandatory

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

Experience LevelSenior Level

---