Key Responsibilities

- Design, develop, test, and maintain ETL/ELT pipelines using Snowflake, AWS, Python, and PySpark.
- Integrate Snowflake with AWS services, including S3, IAM, Lambda, Glue, SNS/SQS, and Step Functions.
- Develop and manage Snowflake objects such as Snowpipe, Streams, Tasks, stages, storage integrations, and external/Iceberg tables.
- Perform data migration from on-premises systems, Hadoop/Hive, and legacy data warehouses to Snowflake.
- Write complex SQL queries and optimize query performance, warehouse utilization, and data processing.
- Implement secure data access using Snowflake RBAC, AWS IAM, KMS, and other relevant cloud security mechanisms.
- Collaborate with Subject Matter Experts (SMEs), Business Analysts, developers, and business stakeholders to understand requirements and deliver data solutions.
- Troubleshoot data pipeline failures, cloud permissions, networking issues, and production incidents.
- Support technical implementations, ongoing maintenance, and platform stability.
- Use Git, Bitbucket, and other source control tools to manage code.
- Support CI/CD and Infrastructure-as-Code practices for reliable deployments.

Mandatory Skills and Qualifications

- Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent experience.
- 4–6 years of overall IT experience.
- Minimum 2 years of hands-on experience in Snowflake Data Engineering.
- Strong hands-on experience with AWS services:
- Amazon S3
- AWS IAM
- AWS Lambda
- AWS Glue
- Amazon SNS/SQS
- AWS Step Functions
- AWS KMS
- Amazon CloudWatch
- Robust programming experience in Python and PySpark, with experience delivering multiple projects.
- Advanced SQL skills, including window functions, semi-structured data processing, and query performance tuning.
- Hands-on experience with Snowflake Snowpipe, Streams, Tasks, stages, storage integrations, RBAC, and warehouse optimization.
- Experience with Git, Bitbucket, or other source code management tools.
- Understanding of cloud security,



data integration, and scalable data pipeline architecture.
- Previous experience working with MNCs.
- Must be a local candidate from Delhi NCR and available to work onsite in Gurgaon.

Technical Skills

Snowflake

- Snowpipe, Streams, and Tasks
- Snowpark
- External and Iceberg tables
- Role-Based Access Control (RBAC)
- Warehouse and query optimization

AWS

- S3, IAM, Lambda, Glue
- SNS/SQS and Step Functions
- KMS and CloudWatch
- VPC and PrivateLink

Programming and Data Processing

- Python
- PySpark
- Advanced SQL
- ETL/ELT pipeline development

DevOps and Deployment

- Git and Bitbucket
- Jenkins
- Terraform and CloudFormation
- dbt
- Ansible

Data Migration

- Hadoop
- Hive
- Legacy data warehouses

Scheduling Tools

- Zeke
- AutoSys

Good-to-Have Skills

- Experience with Terraform, CloudFormation, Jenkins, Ansible, or other DevOps and Infrastructure-as-Code tools.
- Knowledge of dbt and schema change management for Snowflake deployments.
- Experience migrating Hadoop/Hive workloads or legacy data warehouses to Snowflake.
- Exposure to Snowflake Snowpark and external/Iceberg tables.
- Experience with Informatica IDMC.
- Familiarity with Zeke, AutoSys, or similar scheduling tools.
- Snowflake SnowPro Core or AWS certifications.
- Insurance industry experience, preferably involving multiple clients.
- Experience working in a global delivery environment.

Candidate Eligibility Requirements

Candidates must meet the following criteria:

- 4–6 years of overall IT experience.
- At least 2 years of hands-on Snowflake Data Engineering experience.
- Previous MNC experience.
- Must be based locally in Delhi NCR.
- Must be willing to work onsite in Gurgaon.
- Must be an immediate joiner or serving a notice period of no more than 15 days.
- Must be available for two virtual interview rounds.

Pay: ₹1,100,000.00 - ₹1,500,000.00 per year

Application Question(s):

- By applying, you agree that your resume and personal details may be stored securely for up to 2 years for recruitment purposes.

Work Location: Hybrid remote in Gurgaon, Haryana 122022

📌 Snowflake Data Engineer (AWS) (Gurugram)
🏢 Ananta Services
📍 Gurugram