Key Responsibilities

- Migrate existing Medical Affairs data pipelines, reporting grains, datasets, and business logic into the IMD Hub target architecture.

- Re-point upstream and downstream integrations to ensure seamless transition from legacy platforms to IMD Hub.

- Validate migrated datasets, KPIs, metrics, and reporting outputs to ensure alignment with source systems and business requirements.

- Create and maintain Source-to-Target Mapping (STTM), data dictionaries, metadata, and technical documentation.

- Support deployment and operationalization of Facts, Dimensions, Gold datasets, Transactional datasets, and existing reporting assets.

- Collaborate with business, analytics, and engineering teams to resolve migration, reconciliation, and data quality issues.

- Support release management, CI/CD processes, monitoring, defect resolution, and production support activities.

- Drive data quality, governance, automation, and standardization initiatives across the IMD Hub ecosystem.

- Ensure migrated assets are scalable, maintainable, and aligned with enterprise data architecture standards.

Technical Skills

- Strong expertise in Snowflake (Stored Procedures, Tasks, Data Modelling, Data Pipelines, Performance Optimization, and Data Validation).

- Hands-on experience with Python, automation frameworks, and CI/CD processes.





- Strong understanding of Data Warehousing concepts including Facts, Dimensions, Medallion Architecture, Reporting Datasets, and RRDs.

- Experience in data migration, modernization, and transformation programs.

- Strong experience in data validation, reconciliation, testing, and root-cause analysis.

- Experience creating and maintaining STTM documents, metadata artifacts, and data dictionaries.

- Knowledge of data quality, governance, monitoring, and operational support frameworks.

- Ability to build and support scalable, secure, and maintainable enterprise data products.

Functional Skills

- Strong understanding of the Pharmaceutical / Life Sciences domain, preferably within Medical Affairs.

- Ability to understand, interpret, and validate business rules, KPIs, and reporting logic used in Medical Affairs analytics.

- Experience in translating business requirements into data mappings, validation scenarios, and migration strategies.

- Solid understanding of end-to-end data lineage from source systems through data products and reporting layers.

- Ability to work effectively with business stakeholders, Data Governance, Analytics, and Data Management teams.

- Strong documentation, communication and stakeholder management skills.

📌 Data Engineer (Bengaluru)
🏢 Bootminds Systems
📍 Bengaluru