8+ Snow flake schema Jobs in Pune | Snow flake schema Job openings in Pune

About Oneture Technologies

Founded in 2016, Oneture is a cloud-first, full-service digital solutions company, helping clients harness the power of Digital Technologies and Data to drive transformations and turning ideas into business realities. Our team is full of curious, full-stack, innovative thought leaders who are dedicated to providing outstanding customer experiences and building authentic relationships.

We are compelled by our core values to drive transformational results from Ideas to Reality for clients across all company sizes, geographies, and industries. The Oneture team delivers full lifecycle solutions—from ideation, project inception, planning through deployment to ongoing support and maintenance.

Our core competencies and technical expertise includes Cloud powered: Product Engineering, Big Data and AI ML. Our deep commitment to value creation for our clients and partners and “Startups-like agility with Enterprises-like maturity” philosophy has helped us establish long- term relationships with our clients and enabled us to build and manage mission-critical platforms for them.

About The Role

As a Data Platform Lead, you will utilize your strong technical background and hands-on development skills to design, develop, and maintain data platforms.

Leading a team of skilled data engineers, you will create scalable and robust data solutions that enhance business intelligence and decision-making. You will ensure the reliability, efficiency, and scalability of data systems while mentoring your team to achieve excellence.

Collaborating closely with our client’s CXO-level stakeholders, you will oversee pre-sales activities, solution architecture, and project execution. Your ability to stay ahead of industry trends and integrate the latest technologies will be crucial in maintaining our competitive edge.

Key Responsibilities

• Client-Centric Approach: Understand client requirements deeply and translate them into robust technical specifications, ensuring solutions meet their business needs.
• Architect for Success: Design scalable, reliable, and high-performance systems that exceed client expectations and drive business success.
• Lead with Innovation: Provide technical guidance, support, and mentorship to the development team, driving the adoption of cutting-edge technologies and best practices.
• Champion Best Practices: Ensure excellence in software development and IT service delivery, constantly assessing and evaluating new technologies, tools, and platforms for project suitability.
• Be the Go-To Expert: Serve as the primary point of contact for clients throughout the project lifecycle, ensuring clear communication and high levels of satisfaction.
• Build Strong Relationships: Cultivate and manage relationships with CxO/VP level stakeholders, positioning yourself as a trusted advisor.
• Deliver Excellence: Manage end-to-end delivery of multiple projects, ensuring timely and high-quality outcomes that align with business goals.
• Report with Clarity: Prepare and present regular project status reports to stakeholders, ensuring transparency and alignment.
• Collaborate Seamlessly: Coordinate with cross-functional teams to ensure smooth and efficient project execution, breaking down silos and fostering collaboration.
• Grow the Team: Provide timely and constructive feedback to support the professional growth of team members, creating a high-performance culture.

Qualifications

• Master’s (M. Tech., M.S.) in Computer Science or equivalent from reputed institutes like IIT, NIT preferred
• Overall 6-8 years of experience with minimum 2 years of relevant experience and a strong technical background.
• Experience working in mid size IT Services company is preferred

Location : Mumbai / Pune (Hybrid)

Technical Expertise:

• Advanced knowledge of distributed architectures and data modeling practices.
• Extensive experience with Data Lakehouse systems like Databricks and data warehousing solutions such as Redshift and Snowflake.
• Hands-on experience with data technologies such as Apache Spark, SQL, Airflow, Kafka, Jenkins, Hadoop, Flink, Hive, Pig, HBase, Presto, and Cassandra.
• Knowledge in BI tools including PowerBi, Tableau, Quicksight and open source equivalent like Superset and Metabase is good to have
• Strong knowledge of data storage formats including Iceberg, Hudi, and Delta.
• Proficient programming skills in Python, Scala, Go, or Java.
• Ability to architect end-to-end solutions from data ingestion to insights, including designing data integrations using ETL and other data integration patterns.
• Experience working with multi-cloud environments, particularly AWS and Azure.
• Excellent teamwork and communication skills, with the ability to thrive in a fast-paced, agile environment.

Role Overview

We're looking for experienced Data Engineers who can independently design, build, and manage scalable data platforms. You'll work directly with clients and internal teams to develop robust data pipelines that support analytics, AI/ML, and operational systems.

You’ll also play a mentorship role and help establish strong engineering practices across our data projects.

Key Responsibilities

• Design and develop large-scale, distributed data pipelines (batch and streaming)
• Implement scalable data models, warehouses/lakehouses, and data lakes
• Translate business requirements into technical data solutions
• Optimize data pipelines for performance and reliability
• Ensure code is clean, modular, tested, and documented
• Contribute to architecture, tooling decisions, and platform setup
• Review code/design and mentor junior engineers

Must-Have Skills

• Strong programming skills in Python and advanced SQL
• Solid grasp of ETL/ELT, data modeling (OLTP & OLAP), and stream processing
• Hands-on experience with frameworks like Apache Spark, Flink, etc.
• Experience with orchestration tools like Airflow
• Familiarity with CI/CD pipelines and Git
• Ability to debug and scale data pipelines in production

Preferred Skills

• Experience with cloud platforms (AWS preferred, GCP or Azure also fine)
• Exposure to Databricks, dbt, or similar tools
• Understanding of data governance, quality frameworks, and observability
• Certifications (e.g., AWS Data Analytics, Solutions Architect, Databricks) are a bonus

What We’re Looking For

• Problem-solver with strong analytical skills and attention to detail
• Fast learner who can adapt across tools, tech stacks, and domains
• Comfortable working in fast-paced, client-facing environments
• Willingness to travel within India when required

Job Title: Lead Data Engineer

📍 Location: Pune

🧾 Experience: 10+ Years

💰 Budget: Up to 1.7 LPM

Responsibilities

• Collaborate with Data & ETL teams to review, optimize, and scale data architectures within Snowflake.
• Design, develop, and maintain efficient ETL/ELT pipelines and robust data models.
• Optimize SQL queries for performance and cost efficiency.
• Ensure data quality, reliability, and security across pipelines and datasets.
• Implement Snowflake best practices for performance, scaling, and governance.
• Participate in code reviews, knowledge sharing, and mentoring within the data engineering team.
• Support BI and analytics initiatives by enabling high-quality, well-modeled datasets.

Exp: 10+ Years

CTC: 1.7 LPM

Location: Pune

SnowFlake Expertise Profile

Should hold 10 + years of experience with strong skills with core understanding of cloud data warehouse principles and extensive experience in designing, building, optimizing, and maintaining robust and scalable data solutions on the Snowflake platform.

Possesses a strong background in data modelling, ETL/ELT, SQL development, performance tuning, scaling, monitoring and security handling.

Responsibilities:

* Collaboration with Data and ETL team to review code, understand current architecture and help improve it based on Snowflake offerings and experience

* Review and implement best practices to design, develop, maintain, scale, efficiently monitor data pipelines and data models on the Snowflake platform for

ETL or BI.

* Optimize complex SQL queries for data extraction, transformation, and loading within Snowflake.

* Ensure data quality, integrity, and security within the Snowflake environment.

* Participate in code reviews and contribute to the team's development standards.

Education:

* Bachelor’s degree in computer science, Data Science, Information Technology, or anything equivalent.

* Relevant Snowflake certifications are a plus (e.g., Snowflake certified Pro / Architecture / Advanced).

Job Title : Data Engineer – Snowflake Expert

Location : Pune (Onsite)

Experience : 10+ Years

Employment Type : Contractual

Mandatory Skills : Snowflake, Advanced SQL, ETL/ELT (Snowpipe, Tasks, Streams), Data Modeling, Performance Tuning, Python, Cloud (preferably Azure), Security & Data Governance.

Job Summary :

We are seeking a seasoned Data Engineer with deep expertise in Snowflake to design, build, and maintain scalable data solutions.

The ideal candidate will have a strong background in data modeling, ETL/ELT, SQL optimization, and cloud data warehousing principles, with a passion for leveraging Snowflake to drive business insights.

Responsibilities :

• Collaborate with data teams to optimize and enhance data pipelines and models on Snowflake.
• Design and implement scalable ELT pipelines with performance and cost-efficiency in mind.
• Ensure high data quality, security, and adherence to governance frameworks.
• Conduct code reviews and align development with best practices.

Qualifications :

• Bachelor’s in Computer Science, Data Science, IT, or related field.
• Snowflake certifications (Pro/Architect) preferred.

Job Location: Hyderabad/Bangalore/ Chennai/Pune/Nagpur

Notice period: Immediate - 15 days

1.      Python Developer with Snowflake

Job Description :

1. 5.5+ years of Strong Python Development Experience with Snowflake.
2. Strong hands of experience with SQL ability to write complex queries.
3. Strong understanding of how to connect to Snowflake using Python, should be able to handle any type of files
4.  Development of Data Analysis, Data Processing engines using Python
5. Good Experience in Data Transformation using Python. 
6.  Experience in Snowflake data load using Python.
7.  Experience in creating user-defined functions in Snowflake.
8.  Snowsql implementation.
9.  Knowledge of query performance tuning will be added advantage.
10. Good understanding of Datawarehouse (DWH) concepts.
11.  Interpret/analyze business requirements & functional specification
12.  Good to have DBT, FiveTran, and AWS Knowledge.