Data Architect

Experion Technologies; Kerala; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

Experion Technologies in India is seeking a Snowflake Architect to lead architecture, design and delivery of enterprise-scale Snowflake data platforms, focusing on migration from legacy systems and cost-effective, secure data solutions.

The role requires 10+ years in Data Engineering/Architecture and hands-on Snowflake expertise, with strong SQL, ETL/ELT and cloud migration experience across Azure/AWS. Immediate onboarding expected.

Qualifications

• Lead the architecture, design and delivery of enterprise-scale Snowflake data platforms, focusing on data warehouse modernization and migration.

Responsibilities

• Design enterprise-scale Snowflake architectures and data models, including dimensional, normalized and Data Vault approaches.

Skills

Snowflake

SQL

ETL/ELT

CICD

Azure

AWS

PySpark/Python

Databricks

Education

Bachelor's Degree

Tools

IICS

Netezza

Greenplum

SQL Server

DB2

Job description

Skills - Mandatory - Snowflake, SQL, ETL/ELT, CICD

Skills - Primary - Snowflake, SQL, ETL, CICD

Skills - Good to have - Azure/AWS, PySpark/ Python , Databricks

Qualification -Bachelor’s Degree

Total Experience - 10+ years

Relevant Experience - 7+ years

Expected Date of Onboarding - Immediate

Job Purpose (both Onsite / Offshore)

Lead the architecture, design and delivery of enterprise-scale Snowflake data platforms, with a strong focus on data warehouse modernization and migration. The role will drive migration from legacy appliances and databases to Snowflake, while ensuring scalable, secure, performant and cost-effective data solutions.

Job Description / Duties and Responsibilities

The Snowflake Architect will provide end-to-end technical leadership for Snowflake implementations, modernization and migration programs. The role requires strong understanding of legacy data platforms, migration strategies, data modelling, ETL/ELT, performance optimization and cloud architecture. The candidate should be able to assess existing platforms, define migration strategy and target architecture, lead technical implementation, address data and application dependencies, and ensure successful migration with minimal business disruption.

Key Responsibilities

• Design and implement enterprise-scale Snowflake architectures.
• Lead migration and modernization initiatives from legacy data platforms to Snowflake.
• Assess source platforms, workloads, data models, stored procedures, ETL processes and dependencies to define migration strategy.
• Develop migration frameworks, assessment approaches, estimation models and migration roadmaps.
• Design Snowflake data models including dimensional, normalized and Data Vault approaches where appropriate.
• Develop scalable ELT/ETL pipelines and data integration solutions.
• Optimize Snowflake workloads for performance, scalability and cost.
• Define Snowflake architecture including warehouses, databases, schemas, roles, resource management and workload isolation.
• Implement security, access control, governance, data quality and auditing standards.
• Design data ingestion from relational databases, files, APIs and enterprise applications.
• Identify and resolve data type, SQL compatibility, performance and data reconciliation challenges during migration.
• Establish CI/CD and DevOps practices for Snowflake development and deployment.
• Work with cloud teams across Azure, AWS and/or GCP to implement cloud-native data architectures.
• Provide technical leadership through architecture reviews, design reviews and code reviews.
• Mentor Snowflake developers and data engineers.
• Conduct POCs and evaluate Snowflake capabilities and migration tools.
• Collaborate with business stakeholders, enterprise architects, project managers and client teams. Support solutioning, technical proposals, estimation and client presentations.
• 10+ years of experience in Data Engineering / Data Architecture / Data Warehousing.
• Strong hands-on experience with Snowflake and enterprise data warehouse architecture.
• Proven experience leading data warehouse migration and modernization programs.
• Strong experience migrating from Teradata and/or Oracle to Snowflake.
• Strong SQL and data modelling skills.
• Experience with ETL/ELT, data integration and migration frameworks.
• Strong understanding of Snowflake architecture, warehouses, storage, compute and workload management.
• Experience with Snowflake security, RBAC, governance and data sharing.
• Strong understanding of performance tuning and Snowflake cost optimization.
• Experience with data reconciliation, validation and migration testing.
• Experience with cloud platforms - Azure, AWS and/or GCP.
• Strong technical leadership and stakeholder management skills.

Good to Have

• IICS (Informatica Intelligent Data Management Cloud)
• Experience migrating from other appliances/databases such as Netezza, Greenplum, SQL Server or DB2
• Experience with automated migration/conversion tools
• Experience with large enterprise / multi-cloud migration programs