Snowflake Senior Data Engineer

InfoCepts; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

InfoCepts is seeking a Senior Data Engineer-Snowflake to lead the data engineering team in architecting and delivering enterprise Snowflake solutions for retail analytics. You will drive ingestion, multi-source data processing and governance, aligning with modernization initiatives.

The role requires 5–10 years in data engineering with strong Snowflake leadership, SQL proficiency, and experience with Informatica and AWS Glue, collaborating with analysts and stakeholders to deliver scalable data

Qualifications

• 5–10 years in data engineering with leadership experience
• Proven expertise in Snowflake architecture, governance and optimization
• Strong SQL and stored procedure development skills
• Experience with cloud-native ETL tools (Informatica, AWS Glue)
• Ability to lead cross-functional teams and delivery pipelines

Responsibilities

• Lead ingestion and transformation of multi-source retail data.
• Define and implement Snowflake architecture for multi-layered data processing.
• Lead migration from Netezza to Snowflake with automation and scalability.
• Build and optimize ETL workflows using Informatica, AWS Glue and SQL SPs.
• Align data engineering with retail business priorities (sales, customer, workforce, inventory).
• Create and maintain Snowflake tables and views for business consumption.
• Govern data standards, lineage, documentation and compliance.
• Collaborate with analysts, stakeholders and regulatory teams to deliver solutions.
• Mentor and manage engineers across levels.
• Explore Snowflake features for efficiency and innovation.

Skills

Snowflake architecture

SQL development

ETL design

Leadership

Retail data domain

Education

Bachelor’s or Master’s in CS/Data Science/related

Tools

Snowflake

Informatica

AWS Glue

SQL

Cortex (desirable)

Job description

Job Title: Senior Data Engineer-Snowflake

Purpose of the Position: To lead the data engineering team in architecting and delivering enterprise-scale Snowflake solutions for retail analytics, ensuring alignment with strategic business goals and modernization initiatives.

Work Location: Chennai/Bangalore/Pune/Nagpur

Key Result Areas and Activities:

• Data Pipeline Development: Drive ingestion and transformation of multi-source retail data (MMS, CRM, Workday, Courion etc).
• Architecture Leadership: Define and implement Snowflake architecture for multi-layered retail data processing.
• ETL Strategy: Lead migration strategy from Netezza to Snowflake, ensuring automation and scalability.
• ETL Development: Build and optimize ETL workflows using Informatica, AWS Glue and SQL stored procedures.
• Strategic Alignment: Align data engineering practices with retail business priorities (sales, customer, workforce, inventory)
• Data Modelling: Create and maintain Snowflake tables and layered views for business consumption.
• Data Governance: Implement standards for lineage, documentation, and compliance.
• Collaboration: Coordinate with team members, work closely with data analysts, business stakeholders, and regulatory teams to understand data needs and deliver solutions.
• Performance Optimization: Ensure efficient query performance, storage management and cost-effective data processing in Snowflake.
• Documentation & Governance: Maintain clear documentation of data models, transformations, and lineage to support audit and compliance requirements.
• Team Leadership: Mentor and manage engineers across different levels, ensuring delivery excellence.
• Innovation: Explore snowflake features like dynamic tables, automation, and advanced Snowflake features for efficiency.

Roles and Responsibilities

Essential Skills

• Advanced Snowflake expertise (architecture, optimization, governance).
• 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.
• Strong leadership in SQL-based ETL and stored procedure frameworks.
• Deep understanding of retail data domains and compliance frameworks.
• Proven experience in cloud-native ETL (Informatica, Talend).
• Experience in managing cross-functional teams and delivery pipelines

Desirable Skill

• Exposure to ML pipelines for retail analytics.
• Strategic experience in cost optimization and performance tuning.
• Strategic use of Cortex for innovation and advanced analytics.

Qualification:

• Experience: 5-10 years in data engineering, with 5+ years in Snowflake leadership/managerial roles.
• Education: Bachelor’s or master’s degree in computer science, Data Science, Bioinformatics, or related field.

Qualities:

• Strong analytical and problem-solving mindset.
• Detail-oriented with a focus on data accuracy and compliance.
• Excellent communication and stakeholder management skills.
• Ability to work independently and collaboratively in cross-functional teams.
• Adaptability to fast-paced and regulated environments.