Get started
Home/Projects/Directorate of Indian Army Veterans
Government & defenceLiveDelhi

Directorate of Indian Army Veterans

Welfare and pension records moved off an Oracle 8i database to PostgreSQL.

The problem

The Welfare & Pension system's data sat on Oracle 8i, a database long past support.

What we built

A custom ETL pipeline to extract, transform, validate and load the records into PostgreSQL, with accuracy and integrity checks at each stage.

What changed

Data migrated from an outdated database through a custom ETL pipeline.

ClientDirectorate of Indian Army Veterans
IndustryGovernment & defence
Scope
Data migrationCustom ETL pipelineOracle 8i → PostgreSQL
Teams leaving legacy systems

ETL Pro

Move decades of data off old systems without losing a record.

  • Legacy sources, including Oracle 8i
  • Mapping, validation and reconciliation
  • Re-runnable loads, secure handling
Started as a project for Indian Army veterans' welfare & pension records
Innosync delivered a secure and reliable ETL solution. Innosync demonstrated strong technical expertise, a structured delivery approach, and a clear focus on data accuracy and integrity.
Lt. Col. VikramadityaRehabilitation & Welfare Section, Directorate of Indian Army Veterans

Facing something similar?

We'll start where this project started: by understanding how the work really happens.