Senior Data Engineer (SQL / DBT / Postgres)

10 years

0 Lacs

Posted:2 weeks ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Senior DBT Data Engineer


Location: Hyderabad (Hybrid)

Experience: 5–10 Years

Availability: Immediate Joiner

Employment Type: Full-Time


Key Responsibility:

  • Design, develop, and optimize

    data pipelines

    using SQL and DBT.
  • Implement and manage

    Postgres-based data solutions

    , ensuring scalability, reliability, and performance.
  • Build

    near real-time replication pipelines

    and support continuous data integration.
  • Collaborate with internal teams to translate data requirements into efficient, maintainable solutions.
  • Automate workflows using

    Airflow, Rundeck, Mage, or Dagster

    .
  • Monitor, validate, and ensure

    data quality and system performance

    through proactive testing and optimization.


Core Technical Skills & Expertise:

SQL & DBT (Core Focus)

  • Advanced SQL development (complex queries, views, performance tuning).
  • Strong experience with

    DBT transformations, testing, and orchestration

    .
  • Hands-on with

    data validation tools

    (dbt tests, Great Expectations, etc.).

Postgres Expertise

  • Deep knowledge of

    Postgres internals, tuning, and replication

    .
  • Experience with

    JSON-B

    , Postgres extensions, and

    version upgrades

    with minimal downtime.
  • Configuring and maintaining

    self-hosted Postgres environments

    for high reliability.

Automation & Infrastructure

  • Skilled with

    workflow orchestration tools

    (Airflow, Dagster, Metaflow, etc.).
  • Familiar with

    CI/CD systems

    (Jenkins or similar).
  • Experience in

    Docker

    and containerized deployment environments.


Nice-to-Have Skills:

  • AWS ecosystem experience

    (EC2, RDS, Aurora).
  • Knowledge of

    metadata/catalog systems

    (e.g., OpenMetadata).
  • Familiarity with analytical databases such as

    ClickHouse, DuckDB

    , or

    Cloudberry

    .
  • Exposure to

    Python/Django

    , with the ability to map models to SQL schemas.

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

RecommendedJobs for You