Snowflake AWS Engineer

InfoCepts; Pune District, Chennai District, Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

InfoCepts is seeking a Data Engineer focused on Snowflake, AWS Glue and end-to-end data pipelines to serve retail operations across customer, sales, inventory and workforce domains. The role involves designing scalable pipelines, writing optimized SQL and Python code, and integrating with AWS services and third‑party sources.

The candidate will collaborate with data analysts and regulatory teams to ensure accurate reporting, governance and efficient data processing.

Qualifications

• Experience with Snowflake data warehousing, performance tuning and security.
• Strong SQL skills and ability to develop stored procedures.
• Proficient Python development for data engineering and ETL/ELT pipelines.

Responsibilities

• Develop and maintain scalable data pipelines from MMS, CRM, Workday, and other sources into Snowflake via S3, APIs or staging.
• Build and optimize ETL workflows using Talend, AWS Glue and SQL stored procedures.
• Model data in Snowflake with layered views for business consumption.
• Collaborate with analysts, stakeholders and regulatory teams to meet data needs.
• Monitor performance, optimize costs and ensure governance and data lineage.

Skills

Snowflake

SQL

Python

AWS Glue

AWS Services

Git

Cloud platforms

Education

Bachelor's or Master's in CS / Data Science / Bioinformatics

Tools

Talend

Data Catalog

Job description

Position: Data Engineer- Snowflake AWS Glue

Purpose of the Position: To design, develop, and maintain scalable data pipelines and models in Snowflake for retail operations, enabling accurate reporting and analytics across customer, sales, inventory, and workforce domains.

Location: Pune/ Bangalore/Chennai/ Nagpur(hybrid)

Key Result Areas and Activities:

• Data Pipeline Development: Integrate data from different sources like MMS, CRM, Workday, Courion, and other sources via S3 files, APIs, or direct staging in Snowflake.
• ETL Development: Build and optimize ETL workflows using Talend , AWS Glue and SQL stored procedures.
• Data Modeling: Create and maintain Snowflake tables and layered views for business consumption.
• Collaboration: Work closely with data analysts, business stakeholders, and regulatory teams to understand data needs and deliver solutions.
• Performance Optimization: Ensure efficient query performance and cost-effective data processing in Snowflake.
• Documentation & Governance: Maintain clear documentation of data models, transformations, and lineage to support audit and compliance requirements.

Essential Skills

• Strong hands-on experience with Snowflake (data warehousing, performance tuning, security).
• Strong SQL skills with stored procedure development.
• Solid understanding of SQL and advanced query optimization techniques.lis
• Strong experience in Python development for data engineering, automation, and ETL/ELT pipeline development.
• Hands-on experience in designing, developing, and maintaining AWS Glue pipelines, including Glue Jobs, Crawlers, Data Catalog, and workflow orchestration.
• Experience building scalable data integration and transformation solutions using AWS services such as S3, Glue, Lambda, and Step Functions.
• Familiarity with version control (Git) and CI/CD workflows.
• Experience with cloud platforms (AWS, Azure, or GCP), with strong preference for AWS.
• Knowledge of data pipeline monitoring, performance optimization, and troubleshooting in cloud-based data environments.

Qualification:

• Experience: 5+ years in data engineering, with at least 2 years in Snowflake.
• Education: Bachelors or master's degree in computer science, Data Science, Bioinformatics, or related field.