Snowflake / AWS Engineer

Snowflake AWS - Engineer

Job Location: Hyderabad, Indore and Ahmedabad (India)

Exp - 2-4 years experience

Role Overview

We are seeking a skilled Snowflake Data Engineer to join our team. The ideal candidate will be responsible for designing, developing, deploying, and supporting enterprise data solutions on the Snowflake platform. This role involves building scalable data pipelines, developing metadata-driven frameworks, automating database deployments, and supporting production environments. The successful candidate will possess strong troubleshooting skills, be comfortable working across both application and database administration domains, and consistently produce well-documented, maintainable solutions.

Key Responsibilities

Snowflake Engineering & Development

• Design, develop, and maintain robust data solutions using Snowflake.
• Develop and support database objects including tables, views, streams, tasks, stored procedures, and dynamic SQL frameworks.
• Build scalable and performant ETL/ELT pipelines for data integration and analytics workloads.
• Optimize Snowflake query performance, storage utilization, and compute efficiency.
• Implement metadata-driven and configuration-based data processing frameworks.

Database Administration & Scripting

• Develop, support, and maintain database administration scripts for operational and support activities.
• Create automation scripts for database monitoring, housekeeping, deployments, validations, and health checks.
• Assist with Snowflake platform administration activities, including role management, access controls, warehouse management, and object security.
• Support operational automation across development, test, and production environments.
• Support Amazon Aurora PostgreSQL operational activities, including connectivity validation, performance troubleshooting, access coordination, and environment support.

Database Deployment & Release Management

• Utilize Liquibase for source-controlled database deployments and schema migrations.
• Develop and maintain deployment scripts and release automation processes.
• Ensure database changes are properly version-controlled, tested, and promoted through environments.

Data Engineering & Operational Support

• Develop efficient data ingestion, transformation, and validation processes.
• Design, develop, and support AWS Glue jobs and workflows for data ingestion, transformation, cataloging, and orchestration across cloud and enterprise data platforms.
• Work with Amazon S3 for data landing, staging, archival, file organization, access patterns, and integration with Snowflake and AWS Glue pipelines.
• Support AWS Database Migration Service (AWS DMS) tasks for data replication, migration, validation, monitoring, and issue resolution across source and target platforms.
• Troubleshoot and resolve issues related to data pipelines, database performance, and application integrations.
• Perform root cause analysis and implement corrective actions for recurring issues.
• Monitor data loads, data quality processes, and platform performance to ensure reliability and
• availability.
• Support production incident management and operational escalations.

System Integration & DevOps

• Support CI/CD processes for database and data engineering solutions.
• Utilize GitHub for source code management, version control, and collaboration.
• Collaborate with application development, infrastructure, and data teams to deliver integrated enterprise solutions.
• Integrate Snowflake solutions with AWS services, including AWS Glue, Amazon Aurora PostgreSQL, Amazon S3, and AWS DMS, to support scalable enterprise data processing and interoperability.
• Participate in code reviews, deployment reviews, and technical design discussions.

Required Skills & Experience

• Snowflake Engineer 4 years experience and at least 2 years of relevant data engineering experience, including hands-on work with cloud data platforms and production data environments.
• Strong hands-on working experience with Snowflake development and administration.
• Proficiency in writing and optimizing complex SQL queries and Snowflake stored procedures.
• Hands-on proficiency with AWS Glue for ETL development, workflow orchestration, job monitoring, and troubleshooting.
• Experience developing database and application support scripts.
• Experience working with Amazon Aurora PostgreSQL, including SQL development, integration support, operational troubleshooting, and performance analysis.
• Experience working with Amazon S3 for storage, ingestion, staging, and integration with cloud-native data pipelines.
• Experience with AWS DMS for database migration, change data capture, replication monitoring, and troubleshooting.
• Hands-on experience with Liquibase for database deployment and schema version management.
• Strong troubleshooting, analytical, and problem-solving skills.
• Experience supporting production data warehouse or data platform environments.
• Ability to develop maintainable, reusable, and well-documented code.
• Experience with source control systems such as GitHub.
• Excellent verbal and written communication skills.
• Strong attention to detail and commitment to operational excellence. .

Education

• Bachelor's or master's degree in computer science, Engineering or a related field (or equivalent