Projects

Pharma Data Integration

☁️ Data Migration

Pharma Data Integration

Post-acquisition SQL Server data integration for a pharma company using Python ETL and middleware for seamless system unification across two organisations.

Industry

Pharmaceutical

Services

Data Migration

Location

Plainsboro, NJ

Duration

2 months

Tech Stack

SQL Server · Python

⚠️

Business Problem

Following a strategic acquisition, a large pharma parent company inherited a smaller regional firm with entirely separate IT systems — different SQL schemas, naming conventions, and no shared data pipeline. Operations required a unified view of inventory, R&D records, and patient data across both entities without disrupting ongoing work.

✅

Our Solution

We built a Python-based ETL pipeline connecting both SQL Server instances via middleware. Schema mapping was done collaboratively with both IT teams, data was cleansed and validated before migration, and a final delta-sync ensured zero data gaps at cutover.

Project Plan

Schema Analysis & Mapping

Analysed both SQL Server databases — mapped tables, relationships, and naming conventions. Identified ~340 tables requiring transformation logic.

ETL Pipeline Development

Built Python ETL scripts using pandas and SQLAlchemy. Each transformation was unit-tested against representative data sets before being approved for production use.

Data Cleansing & Validation

Ran deduplication, null-handling, and format normalisation across all migrated records. Client signed off on row counts and sample audits at each stage.

Middleware Integration & Testing

Deployed middleware layer enabling real-time reads across both databases during the transition period. Parallel-run testing lasted 3 weeks before full cutover.

Final Delta Sync & Go-Live

Final delta sync captured all changes since Day 1 of migration. Both databases unified into the parent's SQL Server instance with zero data loss confirmed.

Outcomes

340

Database tables successfully migrated

Data loss across all migrated records

Full delivery including testing & validation

"We had two SQL Server environments from a merger that needed to become one. Inputiv built the entire ETL pipeline in Python — clean, documented, and tested before a single byte moved to production. Our client didn't feel a thing during cutover."

— Managing Director · MSP, New Jersey

Tech Stack

📊 Power BI

🗄️ SQL Server

🐍 Python (pandas)

⚙️ SQLAlchemy

🔀 ETL Pipeline

MORE PROJECTS

DC Migration to Azure

Full on-premise DC to Azure IaaS for a multi- branch US MSP client — zero downtime cutover.

Azure

Hyper-V

Cloud DC Migration

Legacy infrastructure lifted and shifted to a fully redundant cloud DC — 99.9% uptime achieved.

AWS

Azure

VMware

Project Details

Client type

Direct (Pharma Co.)

Records migrated

Millions of rows

Project type

Data Integration

Delivery model

Fixed-cost project

Need data integration?

We've unified complex databases across industries. Let's scope your project.

Discuss your project →