Senior Data Engineer

helixops

pune 5 Years Exp Posted 1h ago

Lead data engineering projects across Marketing, Sales, Customer Success, and Product R&D
Design, develop, and maintain ELT/ETL pipelines using Informatica into Snowflake data warehouses and lakes
Contribute to building and governing the semantic layer in Snowflake, defining business logic and metrics that serve as a single source of truth across BI and AI tooling
Lead data modelling efforts in Snowflake, ensuring performance, lineage, and security best practices
Manage and optimise job scheduling and workflow orchestration using Control-M
Develop and maintain Salesforce.com data integrations, supporting CRM-driven analytics across Sales and Customer Success
Develop pipelines that support the full machine learning lifecycle, including data preparation and feature stores for AI/ML consumption
Monitor and optimise Snowflake compute spend in collaboration with IT and Finance
Collaborate with data scientists, analysts, ML engineers, and business stakeholders
Mentor junior engineers; maintain documentation for data structures, lineage, and data contracts
Contribute to platform strategy discussions, including evaluation of emerging platforms such as Microsoft Fabric

Required Skills & Experience:

5+ years in data engineering, data warehousing, and enterprise-level integrations
Strong SQL proficiency with Snowflake as the primary platform; MS SQL Server experience advantageous
Hands-on experience with Informatica (PowerCenter and/or IDMC/Intelligent Data Management Cloud) for ETL/ELT pipeline development
Proficiency in Control-M for enterprise job scheduling, dependency management, and workflow automation
Salesforce.com data model knowledge — including standard/custom objects, APIs, and data extraction patterns
2+ years on cloud platforms (AWS, GCP, Azure, or OCI)
Python and Apache Spark expertise
- Familiarity with Git/Bitbucket and Agile delivery (Jira)