Snowflake Data Engineer | Techknomatic | Pune

Techknomatic Services Private Limited; Pune District; Presencial; INR 900.000 - 1.200.000; Jornada completa

Descripción de la vacante

Techknomatic Services Private Limited in Pune seeks an experienced Snowflake Data Engineer for full-time on-site work. You will design, build, optimize, and maintain scalable data architectures and analytics pipelines using Snowflake, advanced SQL, Python, and ETL/ELT frameworks.

The role requires 2+ years of relevant experience, strong data modeling skills, and hands-on expertise with cloud data warehousing. On-site Pune availability is mandatory, with immediate notice period expectations.

Formación

• Bachelor’s degree in Computer Science, Information Technology, Data Analytics, Software Engineering, or a related technical discipline.
• Minimum of 2+ years of progressive professional experience in software engineering, data warehousing, and database development.
• Strong, demonstrable hands-on expertise with Snowflake data warehousing development, architecture, and performance optimization.
• Deep practical proficiency in advanced SQL programming, relational database management, and complex query tuning.

Responsabilidades

• Design, develop, test, and deploy scalable data pipelines, data warehouses, and analytics infrastructure using Snowflake.
• Build, configure, and maintain robust ETL/ELT data ingestion and transformation workflows across distributed cloud environments.
• Write highly optimized SQL queries, database views, and stored procedures for high-performance analytical reporting.
• Design and implement comprehensive data modeling schemas, dimensional models, and star/snowflake database structures.
• Develop automated data processing, transformation, and validation scripts utilizing Python programming.
• Monitor data pipeline execution telemetry, investigate data discrepancies, and resolve performance bottlenecks.
• Collaborate seamlessly with multidisciplinary data science, analytics, and software engineering squads during sprint cycles.
• Author meticulous technical documentation, data dictionary specifications, architecture diagrams, and deployment runbooks.

Conocimientos

Snowflake

SQL

Python

ETL/ELT

Data modeling

Data warehousing

Problem solving

English communication

On-site Pune

Educación

Bachelor's degree in Computer Science / IT / Data Analytics

Herramientas

Airflow

Dagster

CI/CD pipelines

AWS / Azure / GCP

Descripción del empleo

Position Summary:

Techknomatic is actively seeking an experienced, high-caliber, and technical Snowflake Data Engineer with 2+ years of progressive professional experience in cloud data warehousing, ETL/ELT pipeline development, and database engineering to join our technology team on a full-time permanent on-site basis in Pune. In this critical data engineering role, you will be responsible for designing, building, optimizing, and maintaining scalable data architectures, data models, and analytics pipelines leveraging Snowflake and modern data tooling. You will leverage your deep specialist expertise in Snowflake, advanced SQL, data modeling methodologies, ETL/ELT frameworks, and Python programming to deliver uncompromised data integrity, high query performance, and operational excellence. This opportunity offers competitive compensation, executive technical visibility, and exceptional career growth prospects within a premier global technology consulting and digital solutions enterprise.

Detailed Job Description:

As a Snowflake Data Engineer supporting Techknomatic in Pune, you will take full operational, tactical, and technical ownership of cloud data warehouse architecture, pipeline development, performance optimization, and data integration workflows. Your day-to-day responsibilities include building and maintaining robust ETL/ELT data pipelines, designing optimized Snowflake data models, writing advanced SQL queries and stored procedures, developing data processing scripts in Python, troubleshooting data ingestion and transformation bottlenecks, and collaborating closely with cross-functional software developers, data scientists, and business stakeholders. You will utilize your proactive troubleshooting and analytical problem-solving skills to resolve complex data architecture bottlenecks under strict enterprise service level agreements.

Key Responsibilities:

• Design, develop, test, and deploy scalable data pipelines, data warehouses, and analytics infrastructure using Snowflake.
• Build, configure, and maintain robust ETL/ELT data ingestion and transformation workflows across distributed cloud environments.
• Write highly optimized SQL queries, database views, and stored procedures for high-performance analytical reporting.
• Design and implement comprehensive data modeling schemas, dimensional models, and star/snowflake database structures.
• Develop automated data processing, transformation, and validation scripts utilizing Python programming.
• Monitor data pipeline execution telemetry, investigate data discrepancies, and resolve performance bottlenecks.
• Collaborate seamlessly with multidisciplinary data science, analytics, and software engineering squads during sprint cycles.
• Author meticulous technical documentation, data dictionary specifications, architecture diagrams, and deployment runbooks.

Required Qualifications & Skills:

• Bachelor’s degree in Computer Science, Information Technology, Data Analytics, Software Engineering, or a related technical discipline.
• Minimum of 2+ years of progressive professional experience in software engineering, data warehousing, and database development.
• Strong, demonstrable hands-on expertise with Snowflake data warehousing development, architecture, and performance optimization.
• Deep practical proficiency in advanced SQL programming, relational database management, and complex query tuning.
• Proven operational experience building and maintaining ETL/ELT pipelines and data integration workflows.
• Solid practical experience in data modeling methodologies, dimensional design, and schema structuring.
• Strong hands-on coding proficiency in Python for data manipulation, automation, and script development.
• Exceptional analytical, troubleshooting, debugging, and problem-solving capabilities under active enterprise environments.
• Excellent written and verbal English communication skills with strong cross-functional collaboration abilities.
• Mandatory legal work eligibility in India and physical availability for full-time on-site operations in Pune.

Nice‑to‑Have Skills:

• Professional certifications such as Snowflake SnowPro Core Certified Professional.
• Hands-on familiarity with cloud platforms such as AWS, Microsoft Azure, or Google Cloud Platform (GCP).
• Experience with modern workflow orchestration tools (Apache Airflow, Prefect, Dagster) and CI/CD pipelines.
• Prior professional working experience in top-tier technology consulting firms, global enterprise IT companies, or analytics service providers.

Application Information:

• Recruiter: Techknomatic Human Resources & Talent Acquisition Division
• Contact Name: Pooja Patil (Talent Acquisition Specialist)
• Email: [e-mail]
• Company Website: https://www.techknomatic.com
• Salary/Rate: Market Competitive / Enterprise Technology Package
• Deadline: Open until filled (Urgent Pune On-Site Opening)
• Notice Period: Immediate to 30 Days
• Contract Duration: Permanent / Full-Time On-Site Engagement (Pune, India)