What are the responsibilities and job description for the Hiring - Sr. LIMS Developer/Data Cleansing Engineer - Remote position at Cube Hub, Inc.?
Job Details
Job Description
Job Title: LIMS Developer / Data Cleansing Engineer
Location: Remote
Experience: 5 Years
Flexibility: Flexible working hours
Job Description
We are looking for an experienced LIMS professional with strong SQL and Oracle skills to support a major data-cleansing and environment-setup initiative. The ideal candidate will have hands-on experience with LabVantage LIMS (v8 ), strong analytical ability, and the capability to work independently in a remote setting.
Primary Responsibilities
1. Environmental Setup & System Cloning
- Configure environments and databases in the Baxter DMZ for data cleansing activities.
- Validate systems and ensure readiness before data processing.
- Create and configure data-filtration scripts to filter Baxter and Vantive data while excluding SIMTRA data during continuous replication.
- Remove security groups, permissions, and security keys from cloned systems in the DMZ infrastructure.
2. Data Cleansing
- Analyze database structures and develop cleansing scripts for all relevant tables.
- Remove SIMTRA-related data (Bloomington and Halle Data), including associated manufacturing sites, product codes, documents, attachments, and PII.
- Ensure all SIMTRA data is completely purged from the cloned system.
3. Testing & Validation
- Draft and execute verification scripts to ensure zero SIMTRA data is shared with Vantive.
- Perform regression testing to validate system accuracy post-cleansing.
4. Documentation
- Prepare detailed documentation to enable Vantive to clone the application on their environment.
- Provide step-by-step instructions for integrations and system setup on Vantive's side.
Required Qualifications
- 5 years of hands-on experience with LIMS (preferably LabVantage v8 ).
- Strong experience with SQL and Oracle (ability to write complex queries).
- Experience in LIMS development & configuration.
- Solid understanding of build and deployment processes.
- Advanced technical knowledge of Java modules and frameworks (web services, Hibernate, JMS).
- Experience working with Java EE application servers such as Oracle WebLogic, JBoss EAP, or IBM WebSphere.
- Strong analytical, communication, and organizational skills.
- Ability to work independently with minimal supervision.
- Experience with Jasper Reports is a plus.