Technical Architect - SnowFlake Dataware Housing Job

YASH Technologies, Inc.; Hyderabad; On-site; INR 3,000,000 - 6,000,000; Full time

Job summary

YASH Technologies, Inc. is seeking an experienced Technical Architect to design Snowflake‑based data warehouse and lakehouse solutions and lead enterprise data modernization programs on AWS.

The role requires deep SQL/PL‑SQL, ETL tooling knowledge (Informatica/Datastage/Talend), Python/PySpark, and strong stakeholder collaboration with data engineers, analysts, and architects in a cloud data environment.

Qualifications

• Design Snowflake-based data warehouse and lakehouse solutions.
• Lead architecture and data modernization programs on AWS.
• Define target-state architectures and migration roadmaps.
• Define Snowflake data modelling, clustering, and cost controls.
• Collaborate with stakeholders, engineers, and architects.

Responsibilities

• 10+ years of design and implementation in Snowflake-based data architectures.
• Lead enterprise-wide data modernization programs and cloud platforms.
• Define migration strategies, modernization roadmaps, and ETL ecosystems.
• Provide technical leadership and architecture governance.
• Collaborate with business stakeholders, product teams, and data teams.
• Enable CI/CD, DevOps, and automation for data workflows.

Skills

Snowflake

Data Warehousing

Cloud Data Platform (AWS)

SQL/PL-SQL

Python / PySpark

Data Modeling

ETL Knowledge

CI/CD / DevOps for data

Stakeholder Communication

Data Ingestion & Transformation

Tools

Informatica

Datastage

Talend

Python

PySpark

Job description

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 Dataware Housing Professionals in the following areas :

Technical Architect - SnowFlake Dataware Housing Job

Location: Hyderabad, IN Bangalore, KA, IN Indore, MP, IN Pune, IN

Experience

10-14 Years

Job Description

• 10 + years of Design and implement experience into Snowflake-based data warehouse and Lakehouse solutions.
• Lead the architecture and design of enterprise-wide data modernization programs and cloud data platforms (AWS )
• Define target-state architectures, migration strategies, and modernization roadmaps for legacy data warehouses and ETL ecosystems.
• Define Snowflake data modelling strategies, clustering, partitioning, workload optimization, and cost management practices.
• Design scalable data ingestion, transformation, and consumption patterns for structured and unstructured data.
• Provide technical leadership, solution reviews, and architecture governance.
• Collaborate with business stakeholders, product teams, data engineers, analysts, and enterprise architects.
• Strong knowledge in ETL (Any of the ETL Tools- Ex: Informatica/Datastage/Talend etc. ) & SQL/PL-SQL and Knowledge in Python / Pyspark is preferable
• Good to have experience in the Manufacturing domain, with a strong understanding of industry processes and data workflows
• Enable CI/CD, DevOps, and automation practices for data engineering and analytics workflows.
• Proven experience leveraging AI-assisted tools and modern automation technologies to accelerate architecture design, optimize cloud and data platform performance.
• Excellent communication and stakeholder management

Certifications

AWS Solutions Architect - Professional

AWS Certification, Any Technical Certification

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