Talent.com
ETL Developer - Data Integration
ETL Developer - Data IntegrationLION AND ELEPHANTS CONSULTANCY PRIVATE LIMITED • Pune
ETL Developer - Data Integration

ETL Developer - Data Integration

LION AND ELEPHANTS CONSULTANCY PRIVATE LIMITED • Pune
30+ days ago
Job description

Role Overview :

We are seeking a highly skilled and experienced ETL Developer with strong expertise in Snowflake and dbt (Jinja + SQL). The ideal candidate will be responsible for designing, building, and maintaining robust ETL pipelines and data workflows to support enterprise-level analytics and business intelligence initiatives.

Secondary expertise in Python for automation and scripting will be an added advantage.

This role requires hands-on technical expertise, problem-solving skills, and the ability to collaborate with cross-functional teams to deliver scalable and efficient data Responsibilities :

ETL Development & Data Integration :

  • Design, develop, and optimize ETL pipelines using Snowflake and dbt (Data Build Tool).
  • Implement transformations using Jinja templates and SQL models in dbt.
  • Ensure data is cleansed, validated, and transformed accurately to meet business Modeling & Architecture :
  • Work with stakeholders to design and implement star schema / snowflake schema and other

optimized data models.

  • Support data warehousing initiatives and ensure alignment with data architecture best Optimization :
  • Monitor, troubleshoot, and optimize SQL queries, dbt models, and Snowflake pipelines for better efficiency.
  • Implement best practices for performance tuning, query optimization, and cost management in & Scripting :
  • Leverage Python for automating ETL workflows, data quality checks, and operational tasks.
  • Integrate dbt with orchestration frameworks (e.g., Airflow, dbt Cloud, or Governance & Quality :
  • Implement data validation frameworks, audit checks, and reconciliation processes.
  • Maintain documentation of ETL workflows, data models, and transformations for transparency and & Support :
  • Partner with business analysts, data scientists, and BI developers to provide high-quality, reliable datasets.
  • Provide production support for ETL jobs, ensuring timely resolution of Skills (Mandatory) :
  • Snowflake :

  • Advanced knowledge of Snowflake features (Warehouses, Schemas, Cloning, Micro-partitioning, Streams, Tasks).
  • Experience in query optimization, performance tuning, and cost-effective scaling in (Data Build Tool) :
  • Strong experience in developing and maintaining dbt models.
  • Proficiency in Jinja templating and SQL transformations in dbt.
  • Knowledge of dbt testing frameworks and deployment Expertise :
  • Advanced SQL programming skills for data transformation, analysis, and performance Skills (Preferred) : :
  • Strong scripting and automation capabilities.
  • Experience in integrating Python scripts into ETL workflows.
  • Familiarity with data manipulation libraries (e.g., Pandas, PySpark).
  • Familiarity with cloud platforms (AWS / Azure / GCP) and orchestration tools like Airflow.
  • Knowledge of version control (Git / GitHub / GitLab) and CI / CD practices.
  • Exposure to data visualization tools (Tableau, Power BI) is a plus.
  • (ref : hirist.tech)

    Create a job alert for this search

    Etl Developer • Pune

    Related jobs
    Lead ETL ODI

    Lead ETL ODI

    Vienna Consultancy • Pune, IN
    We are seeking a skilled and experienced Data Integration Specialist with over 9 years of experience in designing and developing data solutions using Oracle Data Integrator (ODI).The ideal candidat...Show more
    Last updated: 15 hours ago • Promoted • New!
    Data Integration Developer (Level 2)

    Data Integration Developer (Level 2)

    Blutic • Pune, 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 more
    Last updated: 13 days ago • Promoted
    ETL / SSIS Developer

    ETL / SSIS Developer

    QUARKS TECHNOSOFT PRIVATE LIMITED • Noida,Jaipur,Pune
    Description : We are looking for an experienced ETL / SSIS Developer with strong hands-on expertise in building, managing, and optimizing complex dat...Show more
    Last updated: 3 days ago • Promoted
    Oracle ETL (ODI / OIC) Systems Analyst

    Oracle ETL (ODI / OIC) Systems Analyst

    Digile • Pune, IN
    We’re Hiring : Oracle ETL (ODI / OIC) Systems Analyst – Lead Role (8+ Years).This is a high-ownership role covering the full delivery lifecycle — from assessment and design to build, testing, deployme...Show more
    Last updated: 15 hours ago • Promoted • New!
    Data Integration Lead - ETL / Informatica

    Data Integration Lead - ETL / Informatica

    Reed and Willow • Pune
    Key Responsibilities : - Lead the design, development, and execution of enterprise-scale data integration strategies and architectures.Manage and gov...Show more
    Last updated: 30+ days ago • Promoted
    Reveille Technologies - ETL Developer - Informatica / Power Center

    Reveille Technologies - ETL Developer - Informatica / Power Center

    Reveille Technologies • Pune
    Description : We are seeking passionate, experienced, and highly skilled ETL (Extract, Transform, Load) and SQL Developers to join our dyn...Show more
    Last updated: 25 days ago • Promoted
    APM Data Integration Analyst

    APM Data Integration Analyst

    TribolaTech Inc • Pune, IN
    Title - APM Data Integration Analyst.This role ensures data integrity, integration, and governance across the APM ecosystem. The Data Integration Analyst will manage application metadata completenes...Show more
    Last updated: 30+ days ago • Promoted
    ETL Tester

    ETL Tester

    Stratawiz Technologies • Pune, Maharashtra, India
    Software developer / tester with specialization in ETL / Data.Warehouse Testing - -Hands-on experience in Sanity, Regression, UAT, Data Integrity, Data. Proven ability in end-to-end data validation, Sou...Show more
    Last updated: 11 days ago • Promoted
    ETL Developer

    ETL Developer

    Pinnacle Group, Inc. • Pune, IN
    PTR Global is a leader in providing innovative workforce solutions, dedicated to optimizing talent acquisition and management processes. Our commitment to excellence has earned us the trust of busin...Show more
    Last updated: 30+ days ago • Promoted
    Data Integration Developer (Level 1)

    Data Integration Developer (Level 1)

    Blutic • Pune, IN
    Data Integration Developer (Level 1).ETL processes and reports using.This entry-level role is ideal for developers looking to grow their skills in enterprise data solutions while contributing to cr...Show more
    Last updated: 4 days ago • Promoted
    CSO ETL Developer - AS

    CSO ETL Developer - AS

    Deutsche Bank • Pune, India
    The Information Security Analytics team is responsible for delivering a comprehensive near-time data warehouse covering all CSO controls. The resultant reporting and analytics will provide an extens...Show more
    Last updated: 25 days ago • Promoted
    CSO ETL Developer - AVP

    CSO ETL Developer - AVP

    Deutsche Bank • Pune, India
    The Information Security Analytics team is responsible for delivering a comprehensive near-time data warehouse covering all CSO controls. The resultant reporting and analytics will provide an extens...Show more
    Last updated: 26 days ago • Promoted
    Pentaho Data Integration Engineer - ETL / SQL

    Pentaho Data Integration Engineer - ETL / SQL

    Systechcorp • Pune
    Key Responsibilities : ETL Development & Management : <...Show more
    Last updated: 30+ days ago • Promoted
    ETL Consultant

    ETL Consultant

    EXL • Pune, Maharashtra, India
    We are seeking a detail-oriented ETL cum BI Engineer with strong expertise in Tableau and Databricks to maintain, optimize, and enhance our reporting infrastructure. This role focuses on dashboard u...Show more
    Last updated: 13 days ago • Promoted
    ETL Developer

    ETL Developer

    Programmers.io • pune, maharashtra, in
    Shift Timings : General Shift (12 : 00 PM IST till 9 : 00 PM or 9 : 30 PM IST).Location : PAN India-Remote Until Office Resume, Work from Home. Experience required : 5 to 8 years.Design, develop, and maintai...Show more
    Last updated: 11 days ago • Promoted
    ETL Developer

    ETL Developer

    SPIRO • Pune, India
    ETL Tester (Automation Specialist).We are seeking a skilled and proactive ETLTester with 4+ years of hands-on experience in software testing, including a strong foundation in manual testing and a p...Show more
    Last updated: 3 days ago • Promoted
    Stratacent - ETL Developer - SQL / Data Warehousing

    Stratacent - ETL Developer - SQL / Data Warehousing

    Stratacent India Private Limited • Pune
    Job Title : ETL Responsibilities : - Design, develop, and maintain efficient ETL workflows.Architect and optimize data warehouse (DWH) solutions for perfor...Show more
    Last updated: 30+ days ago • Promoted
    Integration Analyst - ITX

    Integration Analyst - ITX

    Quadrant IT Services • pune, maharashtra, in
    Position : Integration Analyst - ITX.Hybrid : 1 week in office every month.EDI mapping, integration, and business process understanding within logistics and supply chain domains.The ideal candidate w...Show more
    Last updated: 5 days ago • Promoted