2,302,348open jobs
146,096companies
269,856added this week
Browse all
Location
In office (Pune)
Seniority
Senior · 5+ years exp

Confirmed on the employer's own hiring board on Nov 16, 2026. First seen by Alion on Nov 10, 2026.

Overview
Company
Impact
Profile match
Vivantify Technology Solutions is an information technology consulting and custom software development company providing end-to-end digital solutions for businesses across diverse industries. Headquartered in Coimbatore, Tamil Nadu, India, the firm offers specialized expertise in application engineering, cloud infrastructure, artificial intelligence, and DevOps automation. By modernizing legacy systems and deploying scalable enterprise architectures, the organization helps clients streamline operational workflows and accelerate their digital transformation goals.

Location: Pan India

Experience: 5-7 Years

About the Role

We are looking for a Data Engineer with strong expertise in PostgreSQL and SQL to design, build, and support reliable data pipelines and enterprise data assets. The role focuses on data engineering, SQL performance optimization, data modeling, data quality, and scalable data integration for analytics and real-time consumption.

Job Description

The role involves designing and maintaining data pipelines that acquire, aggregate, refine, and securely move data between source and target systems. You will develop reusable data assets that support enterprise querying, analytics, feature engineering, APIs, and ingestion processes.

A key focus of the role is developing production-grade SQL and optimizing PostgreSQL performance through query tuning, execution plan analysis, indexing, partitioning, and database maintenance. You will also design logical and physical data models and establish standards for schemas, keys, constraints, naming conventions, and slowly changing dimensions.

The position requires building resilient pipelines with appropriate error handling, retry mechanisms, idempotency, and reprocessing capabilities. You will collaborate with data wranglers, data scientists, and technical development teams to deliver reliable and high-quality data solutions.

Key Responsibilities

  • Design, build, and support scalable data pipelines across source and target systems
  • Develop production-grade PostgreSQL SQL using CTEs, window functions, and set-based processing
  • Optimize PostgreSQL performance through query tuning, indexing, partitioning, and execution plan analysis
  • Use EXPLAIN ANALYZE BUFFERS to diagnose query performance and identify I/O and execution bottlenecks
  • Design and maintain logical, physical, normalized, and dimensional data models
  • Define and maintain data contracts covering schemas, keys, constraints, naming standards, and business definitions
  • Implement resilient data pipelines with error handling, retries, idempotency, and reprocessing/backfill capabilities
  • Implement data quality checks, monitoring, and reusable data assets for analytical and real-time consumption

Required Skills

  • PostgreSQL
  • Advanced SQL
  • CTEs, window functions, and set-based processing
  • PostgreSQL query tuning and execution plan analysis
  • Indexing strategies including B-tree, Hash, GiST, and GIN
  • Database partitioning and maintenance
  • VACUUM/ANALYZE and table statistics management
  • Locking and concurrency handling
  • EXPLAIN ANALYZE BUFFERS
  • Data modeling: logical, physical, normalized, and dimensional models
  • Data contracts and schema evolution
  • ETL and data integration
  • Data quality and pipeline monitoring
  • Error handling, retry logic, idempotency, and data reprocessing

Mandatory Skills

  • PostgreSQL

Candidate Profile

The ideal candidate should have 5-7 years of experience in data engineering with strong hands-on expertise in PostgreSQL and advanced SQL, including database performance optimization and data modeling. The candidate should be capable of building reliable data pipelines and reusable data assets while collaborating effectively with data scientists, data wranglers, and technical development 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
Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,302,348 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Data Science
Similar stack
Same company
Pune
APAC Data Steward 27 min ago
In office · 4+ years exp · Bengaluru
SQL
Analytics
Power BI
Informatica
Apply
In office · 4+ years exp · Bengaluru
Apply
Data Engineer 1 hour ago
In office · Full-Time · 4+ years exp · Bachelor's Degree · Bengaluru
Python
SQL
Python
pySpark
Databases
Databricks
Apache Kafka
AI/ML
Spark
DevOps
Terraform
Azure DevOps
Azure
CI/CD
Git
IAM
Analytics
ETL/ELT
Azure Data Factory
Collibra
Apply
Data Scientist 7 hours ago
In office · Full-Time · 3+ years exp · Hyderabad
Python
AI/ML
MLFlow
Scikit-learn
Kubeflow
TensorFlow
NumPy
PyTorch
Statsmodels
Time Series
Machine Learning
DevOps
GCP
Azure
CI/CD
AWS
Docker
Kubernetes
Apply
DB2 Database Engineer 2 hours ago
In office · Full-Time · 5+ years exp · Mumbai
Databases
Db2
DevOps
Azure
AWS
Linux
Apply
In office · 3+ years exp · Almaty
JavaScript
TypeScript
SQL
Node JS
Node JS
Nest.JS
Databases
PostgreSQL
Frontend
Vue.js
Vite
Sass
DevOps
Rest API
CI/CD
Git
Docker
Apply
In office · Full-Time · Melbourne
Python
Java
SQL
C++
AI/ML
dbt
DevOps
CI/CD
Analytics
Dimensional Modeling
Management
Agile
Apply
Remote (United States)
SQL
AI/ML
EU AI Act
DevOps
AWS
Cloudflare
IAM
Cybersecurity
ISO 27001
NIST CSF
SOC 2
GDPR
HIPAA
Apply
$112k – $269k per year · Equity · Hybrid · Bachelor's Degree · San Francisco
Python
Java
SQL
C++
C++
TensorFlow C++
AI/ML
Spark
XGBoost
Fine-tuning
Embeddings
Prompt Engineering
Computer Vision
MLlib
TensorFlow
PyTorch
LLM
OpenAI
Machine Learning
Apply
$107k – $180k per year · Equity · Remote (United States) · 5+ years exp · United States
Python
JavaScript
SQL
AI/ML
Copilot
Claude Code
Management
Zapier
Apply
Hybrid · 10+ years exp · Bachelor's Degree · Bengaluru
Python
SQL
Databases
Neo4j
Databricks
Delta Lake
Amazon Neptune
AI/ML
Spark
Airflow
RAG
Semantic Search
Knowledge Graph
Recommender Systems
Machine Learning
DevOps
Splunk
CI/CD
AWS
Grafana
AWS Lambda
Amazon S3
IAM
Analytics
ETL/ELT
Apply
In office · 7+ years exp · Hyderabad
SQL
Databases
PostgreSQL
Snowflake
Analytics
ETL/ELT
Apply
In office · 5+ years exp · Pune
SQL
Databases
PostgreSQL
Analytics
ETL/ELT
Dimensional Modeling
Apply
In office · 7+ years exp · Bachelor's Degree · Bengaluru
Python
SQL
Databases
Databricks
AI/ML
Spark
DevOps
Azure
CI/CD
Analytics
ETL/ELT
Azure Data Factory
Apply
In office · 5+ years exp · Hyderabad
Python
Databases
Snowflake
AI/ML
Airflow
Apply
$15k – $21k per year · In office · Full-Time · Bengaluru · Pune · Hyderabad · Chennai
Python
SQL
Databases
Google BigQuery
AI/ML
Airflow
DevOps
Terraform
GCP
Management
Agile
Apply
≈ $18k – $38k per year (Estimated) · Hybrid · Full-Time · 7+ years exp · Master's Degree · Pune
Python
SQL
Scala
SAS
AI/ML
Spark
AI Agents
Time Series
Machine Learning
DevOps
GCP
Azure
AWS
Linux
Unix
Apply
Hybrid · Full-Time · Pune
SQL
DevOps
Azure DevOps
Azure
Management
Agile
Scrum
Apply
Project Engineer 1 hour ago
In office · Full-Time · 4+ years exp · Bachelor's Degree · Pune
Energy
IEC 61850
Apply
In office · Full-Time · 3+ years exp · Bachelor's Degree · Pune · Chennai
Apply
See all jobs
This is one of many
2,302,348 more open roles from verified company boards, updated every day.