Talent.com
Data Warehouse Developer

Data Warehouse Developer

E4 Software Services Pvt. LtdRepublic Of India, IN
2 days ago
Job description

About the Role :

  • We are seeking an experienced Snowflake Developer with strong hands-on expertise to design, implement, and optimize data solutions on the Snowflake Data Cloud platform. The ideal candidate will demonstrate deep proficiency in SnowSQL, performance optimization, and advanced data engineering using SQL and Python. Location is Bangalore / Mumbai / Chennai / Pune

Key Responsibilities :

  • SnowSQL & Advance SQL Expertise
  • Expert-level knowledge of SQL and SnowSQL for complex query development and optimization
  • Proficiency in DDL and DML operations, advanced SQL constructs (window functions, CTEs, subqueries, joins)
  • Expertise handling semi-structured data (JSON, AVRO, Parquet, XML) using VARIANT column type and LATERAL FLATTEN
  • Experience with stored procedures, transaction management, and data transformations
  • Performance Optimization & Query Tuning

  • Deep understanding of Snowflake query optimization strategies and best practices
  • Expertise in warehouse sizing, clustering keys, and micro-partition optimization
  • Proficiency with Snowflake's caching mechanisms and partition pruning techniques
  • Experience with filter pushdown optimization and predicate optimization techniques
  • Ability to analyze query execution plans using EXPLAIN and Query Profile features
  • Experience with Query Acceleration Service (QAS), Search Optimization Service, materialized views, and dynamic tables
  • Proven track record identifying and resolving query bottlenecks, spilling issues, and warehouse queuing problems
  • Python Development & Integration

  • Strong Python programming for data engineering, automation, and ETL / ELT workflows
  • Proficiency in Snowpark for Python to build scalable data processing applications
  • Experience with Snowflake Python APIs, Snowflake Connector for Python, and pandas on Snowflake
  • Ability to develop Python UDFs and stored procedures
  • Design, develop, and maintain robust data solutions using Snowflake platform
  • Write and optimize complex SQL queries for high performance and cost efficiency
  • Implement performance tuning strategies for optimal query execution and warehouse utilization
  • Develop Python-based automation scripts and data processing workflows
  • Create and maintain data models supporting business intelligence and analytics
  • Monitor and troubleshoot data pipeline issues and performance bottlenecks
  • Collaborate with cross-functional teams to translate business requirements into technical solutions
  • Document technical processes, data flows, and architectural decisions
  • Stay current with Snowflake features and implement industry best practices
  • Participate in code reviews and mentor junior developers
  • Work Location

  • Work from office
  • Bangalore / Mumbai / Chennai / Pune
  • Experience

  • Minimum 6 – 10 years of work experience with at least two projects implementation leveraging Snowflake - either migration from traditional DWHs or a fresh implementation
  • Create a job alert for this search

    Developer • Republic Of India, IN

    Related jobs
    • Promoted
    Data Integration Developer (Level 2)

    Data Integration Developer (Level 2)

    BluticNagpur, IN
    Data Integration Developer (Level 2).ETL processes, reports, and database solutions using.This role requires solid technical skills to implement solutions, optimize code, and collaborate effectivel...Show moreLast updated: 4 days ago
    • Promoted
    ETL Developer

    ETL Developer

    Philodesign Technologies IncNagpur, IN
    We’re Hiring : Enterprise Data Engineer.Are you passionate about building large-scale, high-performance data solutions? We’re looking for an experienced. Implement and orchestrate data workflows with...Show moreLast updated: 2 days ago
    • Promoted
    Data Engineer

    Data Engineer

    DigitalzoneNagpur, IN
    As a Data Engineer, you will design, build, and optimize data pipelines and real-time systems that power AI-driven decisioning and analytics. Develop and maintain scalable ETL / ELT pipelines using Py...Show moreLast updated: 4 days ago
    • Promoted
    Data Engineer

    Data Engineer

    Philodesign Technologies IncIndia, India
    The ideal candidate will have strong hands-on expertise in.Azure Data Factory (ADF), Synapse, and Databricks.ETL, SQL, and data warehousing concepts. Design, develop, and implement ETL solutions usi...Show moreLast updated: 4 days ago
    • Promoted
    Electronic Data Interchange Developer

    Electronic Data Interchange Developer

    BGSFNagpur, IN
    Years Experience in EDI / Seeburger technology ( Minimum 2-4 years specifically in SEE burger must).Knowledge of EDI X12 , mapping, and working experience preferred. Experience in Mapping, Cloud, et...Show moreLast updated: 1 day ago
    • Promoted
    Azure Databricks+Pyspark

    Azure Databricks+Pyspark

    Tata Consultancy ServicesIndia
    TCS is conducting Virtual Drive for Azure Data Engineer + Pyspark.Years of Experience : 6 to 10yrs.Location : Bangalore & Hyderabad. Kindly apply if there is a skill match with 6+yrs of experience.Ove...Show moreLast updated: 4 days ago
    • Promoted
    Enterprise Data Architect

    Enterprise Data Architect

    DBiz.aiNagpur, IN
    You will ensure that data is modeled, structured and integrated across the organization to support analytics and AI / ML initiatives at scale. You will work closely with business stakeholders and tech...Show moreLast updated: 15 days ago
    • Promoted
    Senior Snowflake Data Engineer

    Senior Snowflake Data Engineer

    iVoyantNagpur, IN
    One of our clients is looking for an experienced Senior Snowflake Data Engineer to join their team.We are seeking a Senior Data Engineer with 8+ years of experience in end-to-end data engineering a...Show moreLast updated: 4 days ago
    • Promoted
    Teradata Developer

    Teradata Developer

    AdastraIndia, India
    We are looking for an experienced.The ideal candidate will have strong hands-on experience in Teradata development, advanced SQL expertise, and the ability to perform independent analysis and probl...Show moreLast updated: 15 days ago
    • Promoted
    Database Developer

    Database Developer

    AVASO Technology SolutionsNagpur, IN
    AVASO Technology is a global leader in providing IT solutions and services, specializing in offering top-tier support and managed services. We are committed to delivering cutting-edge technology sol...Show moreLast updated: 1 day ago
    • Promoted
    Database Developer

    Database Developer

    CareerUS SolutionsNagpur, IN
    SQL queries, stored procedures, triggers, and functions.Collaborate with software developers to design.Monitor and tune database performance, including. Document database designs, architecture decis...Show moreLast updated: 3 days ago
    • Promoted
    Looker Developer

    Looker Developer

    RiDiK (a Subsidiary of CLPS. Nasdaq : CLPS)Nagpur, IN
    We are looking for a skilled BI Developer to support a large client in the Healthcare domain.The role will involve enhancing and maintaining reports using Looker / LookML, developing dimensional data...Show moreLast updated: 4 days ago
    • Promoted
    Data Engineer with Snowflake Experience- Contract

    Data Engineer with Snowflake Experience- Contract

    Gravity Infosolutions, Inc.Nagpur, IN
    Data Engineer with Snowflake & Data Vault 2.The project involves setting up a new software tool to meet audit requirements and is therefore critical. Most data to be migrated is already in Snowflake...Show moreLast updated: 15 days ago
    • Promoted
    Oracle Data Integrator (ODI) Developer

    Oracle Data Integrator (ODI) Developer

    KPG99 INCNagpur, IN
    Role- Oracle Data Integrator (ODI) Developer.Strong understanding of relational database design and performance optimization. Excellent troubleshooting and problem-solving skills.Ability to work ind...Show moreLast updated: 17 days ago
    • Promoted
    Senior SQL Developer

    Senior SQL Developer

    Programmers.ioNagpur, IN
    Job Title : : Senior SQL Developer.Experience Range : 6 to 12 Years.Shift Time : 2 : 30 PM to 11 : 30 PM IST.Must have skills set C#, SQL Server &. Good to have skills Set : Finance Background.Design, devel...Show moreLast updated: 3 days ago
    • Promoted
    Data Engineer

    Data Engineer

    VeraxionNagpur, IN
    Python, Spark, DBT, and AWS-native services.Agile environment to deliver scalable, secure, and high-performance data solutions. Python, DBT, and AWS services (Data Ops Live).Deliver end-to-end data ...Show moreLast updated: 15 days ago
    • Promoted
    Data Architect

    Data Architect

    Tata Consultancy Servicesnagpur, maharashtra, in
    Role- Snowflake Data Architect.Cloud data warehouse technologies on Snowflake and AWS, Azure or GCP.At least one End-to-end Snowflake implementation is a must covering all aspects including archite...Show moreLast updated: 30+ days ago
    • Promoted
    Remote - Python SQL Developer

    Remote - Python SQL Developer

    KPG99 INCnagpur, maharashtra, in
    Remote
    Position : Python SQL Developer.Long term annually extending contract.Minimum of 7 years’ experience in a similar role, with a focus on data management and process automation.NEED SOMEONE WHO CAN H...Show moreLast updated: 1 day ago