Projects
/
Pharma Data Integration
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.
⚠️
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
1
Schema Analysis & Mapping
Analysed both SQL Server databases — mapped tables, relationships, and naming conventions. Identified ~340 tables requiring transformation logic.
2
Built Python ETL scripts using pandas and SQLAlchemy. Each transformation was unit-tested against representative data sets before being approved for production use.
3
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.
4
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.
5
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
0
%
Data loss across all migrated records
2
Mo
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)
🔀 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
AD
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 →
Inputiv
Expert helpdesk & project support for MSPs across the US and Australia. SOC 2 Type 2 certified.
🛡️
SOC 2 Type 2
✓
Security · Confidentiality · Availibility
Certified · Accorp Partners CPA LLC · Oct 2025