Specialist - Data Engineering - PSQL

Vivantify Technology Solutions India Private Limited; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Competitive salary package

Professional growth opportunities

Collaborative work environment

Job summary

Vivantify Technology Solutions India Private Limited in Pune is seeking a Data Engineer with strong expertise in PostgreSQL, SQL, data pipelines, and data modeling. You will design, develop, and optimize data platforms to support analytics, APIs, and real-time consumption.

The role focuses on building reliable data pipelines, tuning queries, and partnering with data scientists and developers to deliver high‑quality data solutions for enterprise clients.

Qualifications

• 5–7 years of experience in data engineering or equivalent.
• Design and build reliable data pipelines for enterprise analytics and APIs.
• Develop production-grade SQL in PostgreSQL and manage data models.

Responsibilities

• Design, build, and support data pipelines for enterprise platforms.
• Develop reusable data assets for analytics, APIs, and feature engineering.
• Write production-grade PostgreSQL SQL using CTEs and window functions.
• Optimize PostgreSQL performance via query tuning, indexing, and partitioning.
• Use Explain Analyze and BUFFERS to diagnose slow queries and bottlenecks.
• Maintain data contracts, schemas, and backward compatibility.

Skills

PostgreSQL

Advanced SQL

Data pipelines

Data modeling

Performance tuning

Partitioning

ETL

Data quality

Code reviews

Tools

Explain Analyze

BUFFERS

Job description

Location: Pune

Experience: 5–7 Years

About the Role

We are seeking a Data Engineer with strong expertise in PostgreSQL, SQL, data pipelines, and data modeling. The role focuses on building reliable data platforms and reusable data assets that support enterprise analytics, querying, APIs, feature engineering, and real-time and analytical consumption.

Job Description

The role involves designing, developing, and supporting data pipelines that securely acquire, aggregate, refine, and move data from source systems to target platforms. The candidate will develop production-grade SQL and optimize PostgreSQL performance through query tuning, indexing, partitioning, statistics management, and concurrency handling.

The position also requires designing logical and physical data models, establishing data contracts, managing schema evolution, and implementing resilient data processing with error handling, retries, idempotency, and reprocessing capabilities. The candidate will collaborate with data scientists, data wranglers, and technical development teams to deliver high-quality data solutions.

Key Responsibilities

• Design, build, and support reliable data pipelines for enterprise data platforms.
• Develop and maintain reusable data assets for analytics, querying, APIs, and feature engineering.
• Write production-grade PostgreSQL SQL using CTEs, window functions, and set-based processing.
• Optimize PostgreSQL performance through query tuning, execution plan analysis, indexing, partitioning, and statistics management.
• Use EXPLAIN ANALYZE and BUFFERS to diagnose slow queries and identify I/O and execution bottlenecks.
• Design effective indexes including B-tree, Hash, GiST, and GIN, aligned with filtering, joins, and sorting requirements.
• Implement resilient pipelines with error handling, retry logic, idempotency, reprocessing, and backfill capabilities.
• Design and maintain logical and physical data models using normalized and dimensional modeling approaches.
• Define and maintain data contracts covering schemas, keys, constraints, naming conventions, SCD approaches, and business definitions.
• Manage schema evolution with backward compatibility, deprecation planning, and impact analysis.
• Implement data integration using ETL and other data tools across databases and platforms.
• Establish data quality checks and monitoring for analytics data flows.

Required Skills

• PostgreSQL
• Advanced SQL
• Query tuning and execution plan analysis
• Indexing and partitioning
• VACUUM/ANALYZE and table statistics
• Locking and concurrency management
• EXPLAIN ANALYZE / BUFFERS
• Data pipeline development
• Data modeling — logical and physical
• 3NF and dimensional modeling
• Data contracts and schema management
• Schema evolution and backward compatibility
• ETL and data integration
• Data quality and monitoring
• Version control and peer review
• Error handling, retry, idempotency, and data reprocessing

Mandatory Skills

• PostgreSQL

Candidate Profile

The ideal candidate will have 5–7 years of experience in Data Engineering, with strong hands‑on expertise in PostgreSQL and production‑grade SQL development. The candidate should have solid experience in data pipelines, performance optimization, data modeling, data integration, and data quality, along with the ability to collaborate effectively with data and technical teams.

Benefits Package

• Competitive salary and benefits package
• Opportunities for professional growth and development
• A collaborative and inclusive work environment
• The opportunity to work on exciting and challenging projects with leading clients