Tech Stack

Description

You will develop and validate SQL-based data migration pipelines to transfer client data into Salesforce-based products for pharmaceutical and life sciences clients. Working closely with a Data Migration Architect, you will translate field mappings and transformation specifications into reliable processes, ensure data integrity, and continuously improve the QA framework.

Requirements

• Proven experience with SQL-based ETL pipelines and data migration
• Ability to implement complex hierarchical inclusion logic
• Experience developing non-linear SQL transformations and record synthesis
• Strong analytical and problem-solving skills for data integrity issues
• Familiarity with Salesforce or similar CRM platforms preferred

Responsibilities

• Build and maintain SQL-based transformation pipelines for data ingestion and ETL
• Develop and execute SQL-based QA framework with automated validation scripts
• Conduct deep profiling of source data to identify quality gaps and structural inconsistencies
• Troubleshoot and resolve transformation defects and load errors
• Collaborate with Data Migration Architect and cross-functional teams