Associate Data Architect I- Azure/Snowflake & AWS Migration

UST
₹9,06,023 - ₹11,47,227 एक वर्ष
केरल
3 सप्ताह पहले
    9 - 12 Years
    1 Opening
    Trivandrum


Role description

Tech Lead – Azure/Snowflake & AWS Migration

Key Responsibilities

  • Design and develop scalable data pipelines using Snowflake as the primary data platform, integrating with tools like Azure Data Factory, Synapse Analytics, and AWS services.
  • Build robust, efficient SQL and Python-based data transformations for cleansing, enrichment, and integration of large-scale datasets.
  • Lead migration initiatives from AWS-based data platforms to a Snowflake-centered architecture, including:

o Rebuilding AWS Glue pipelines in Azure Data Factory or using Snowflake-native ELT approaches.

o Migrating EMR Spark jobs to Snowflake SQL or Python-based pipelines.

o Migrating Redshift workloads to Snowflake with schema conversion and performance optimization.

o Transitioning S3-based data lakes (Hudi, Hive) to Snowflake external tables via ADLS Gen2 or Azure Blob Storage.

o Redirecting Kinesis/MSK streaming data to Azure Event Hubs, followed by ingestion into Snowflake using Streams & Tasks or Snowpipe.

  • Support database migrations from AWS RDS (Aurora PostgreSQL, MySQL, Oracle) to Snowflake, focusing on schema translation, compatibility handling, and data movement at scale.
  • Design modern Snowflake lakehouse-style architectures that incorporate raw, staging, and curated zones, with support for time travel, cloning, zero-copy restore, and data sharing.
  • Integrate Azure Functions or Logic Apps with Snowflake for orchestration and trigger-based automation.
  • Implement security best practices, including Azure Key Vault integration and Snowflake role-based access control, data masking, and network policies.
  • Optimize Snowflake performance and costs using clustering, multi-cluster warehouses, materialized views, and result caching.
  • Support CI/CD processes for Snowflake pipelines using Git, Azure DevOps or GitHub Actions, and SQL code versioning.
  • Maintain well-documented data engineering workflows, architecture diagrams, and technical documentation to support collaboration and long-term platform maintainability.

Required Qualifications

  • 9+ years of data engineering experience, with 3+ years on Microsoft Azure stack and hands-on Snowflake expertise.
  • Proficiency in:

o Python for scripting and ETL orchestration

o SQL for complex data transformation and performance tuning in Snowflake

o Azure Data Factory and Synapse Analytics (SQL Pools)

  • Experience in migrating workloads from AWS to Azure/Snowflake, including services such as Glue, EMR, Redshift, Lambda, Kinesis, S3, and MSK.
  • Strong understanding of cloud architecture and hybrid data environments across AWS and Azure.
  • Hands-on experience with database migration, schema conversion, and tuning in PostgreSQL, MySQL, and Oracle RDS.
  • Familiarity with Azure Event Hubs, Logic Apps, and Key Vault.
  • Working knowledge of CI/CD, version control (Git), and DevOps principles applied to data engineering workloads.

Preferred Qualifications

  • Extensive experience with Snowflake Streams, Tasks, Snowpipe, external tables, and data sharing.
  • Exposure to MSK-to-Event Hubs migration and streaming data integration into Snowflake.
  • Familiarity with Terraform or ARM templates for Infrastructure-as-Code (IaC) in Azure environments.
  • Certification such as SnowPro Core, Azure Data Engineer Associate, or equivalent.

Skills

Azure,AWS REDSHIFT,Athena,Azure Data Lake


About UST

UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.
आवेदन करें
अन्य नौकरी सुझाव:

Architect & JUNIOR ARCHITECTS

Syal and associates.
पंजाब
₹20,000 - ₹40,000 एक माह
The ideal candidate will work closely with clients ,engineers and project managers . Qualification : Diploma and Degree in...
2 दिन पहले

Housekeeping Associate

Amabara Suites
केरल
  • Performing cleaning activities such as sweeping, mopping,...
  • Ensuring all rooms are cared for and inspected according to...
  • Bed Making...
2 सप्ताह पहले

Azure Migration Lead

Bosch Group
Bengaluru, कर्नाटक
  • Lead Lift & Shift and clean deployment migrations...
  • Conduct application intake, discovery, and dependency...
3 सप्ताह पहले

Snowflake Architect

Birlasoft
महाराष्ट्र
₹15,21,255 - ₹19,26,248 एक वर्ष
  • Must have at least 4 years of experience as a Snowflake Data...
  • Lead the deployment of Snowflake solutions, covering data...
2 सप्ताह पहले

Customer Support Associate

Kareer Hubb
हरियाणा
₹25,000 - ₹35,000 एक माह
Profile : Customer support associate (Inbound - Voice) Graduate -Fresher/ Undergraduate with minimum 6 months of international exp...
4 दिन पहले

Azure Data Architect

Virtusa
तमिलनाडु
₹17,24,037 - ₹21,83,015 एक वर्ष
Good skills in Data warehousing and Datalake architecture; overall 15+ years of experience in Data & Analytics space with more...
21 घंटे पहले

Snowflake DBT

Virtusa
तमिलनाडु
₹9,76,909 - ₹12,36,984 एक वर्ष
This role is for an OSP provider resource to migrate legacy ETL pipelines (Informatica/Talend) to a modern data stack on...
21 घंटे पहले

LSE / Associate Architect - Big Data

Impetus Technologies
मध्य प्रदेश
₹11,57,868 - ₹14,66,119 एक वर्ष
Lead Software Engineer / Associate Architect with proficiency in design and implmentation of scalable and robust data engineering...
2 दिन पहले

Architect

Studio solids
केरल
₹10,000 - ₹20,000 एक माह
The ideal candidate will be responsible for developing building designs, preparing detailed drawings, collaborating with clients...
3 सप्ताह पहले

Librarian for school

Amrita Vidyalayam Nagapattinam & Thanjavur
तमिलनाडु
₹2,16,281 - ₹2,73,861 एक वर्ष
The Librarian will be responsible for maintaining the library collection, assisting students and staff with resources, and...
21 घंटे पहले