Data Transformation Specialist

ETL Developer

We are seeking a highly skilled ETL developer to join our team.

• Job Description :
• Develop, deploy and maintain ETL workflows for a GMP-validated platform used across the globe.
• Extract, transform and load data from lab systems (gLIMS, MODA, LabWare, Thermo Fisher) and flat files (Excel, CSV).
• Configure and maintain ETL parameters including target DB environments (Dev, Test, Stage, Prod), data classes, study identifiers, folder paths and runtime settings.
• Integrate and transform data into the Oracle 19c business layer ensuring data quality and compliance with GMP standards.
• Troubleshoot ETL failures, protocol errors, ODBC connectivity issues and Oracle-specific exceptions.
• Required Skills and Qualifications :
• Strong experience with Biovia Pipeline Pilot and ETL workflow design.
• Proficient in Oracle 19c SQL Server and working with flat file data sources.
• Experience with lab systems integration (gLIMS MODA LabWare Thermo Fisher).
• Strong troubleshooting skills for ETL and database-related issues.
• Knowledge of GMP regulations environmental monitoring data and validation documentation.
• Agile development experience and collaborative mindset.

Benefits :