Senior Developer – EMDA Analytics (ETL, Biovia Pipeline Pilot)

0 years

0 Lacs

Posted:6 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Contractual

Job Description

About the Role:

ETL Developer

Key Responsibilities:

  • Design, develop, and optimize ETL protocols using

    Biovia Pipeline Pilot v2017R2

    to 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.
  • Collaborate with

    DBAs

    and EMDA support teams to resolve data access, performance, and integration issues.
  • Support

    audit trail retrieval

    , data verification processes, and validation documentation (ADLC plans, SOPs, design specifications).
  • Participate in

    Agile development cycles

    and contribute to continuous improvement initiatives.
  • Interpret environmental monitoring data and support EMDA modules including:
  • Heatmaps
  • MODA History & Trend Check
  • Utility/Water Trending
  • Automated Reports
  • ASRAT (Aseptic Site Risk Assessment Tool)

Skills & 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.

Preferred Experience:

  • Prior experience in

    pharmaceutical or biotech environments

    .
  • Hands-on experience with EMDA modules and data visualization tools.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You