HVR Engineer

Responsibilities

• Design, build, and optimize HVR channels to facilitate data movement from Oracle databases to Databricks.

• Collaborate with team leads and database administrators (DBAs) to implement and troubleshoot HVR agents on source and target databases.

• Understand existing ETL processes and support the migration/modernization of data pipelines as part of large-scale data warehouse initiatives, such as the Research Information Factory (RIF) project.

• Replicate configurations and patterns established in prior phases, adapting as necessary to project requirements.

• Monitor, analyze, and resolve issues related to data replication, field conversions, performance bottlenecks, or data quality.

• Work closely with offshore and/or on-site teams, integrating into a flexible resourcing model per project demands.

• Provide expertise and hands-on support for HVR-specific engineering challenges, including optimizing channel performance and resolving integration issues.

Qualifications

• Proven experience with HVR (High Volume Replication), particularly in engineering source-target connections and channel optimization.

• Strong background in Oracle databases and experience in data extraction, ETL, or data warehouse environments.

• Solid understanding and hands-on experience with Databricks or similar big data transformation platforms.

• Demonstrated ability to resolve technical issues in agent installation, data type conversions, and end-to-end pipeline troubleshooting.

• Ability to work independently, adapt to changing priorities, and effectively communicate within cross-functional teams.

• Previous experience in collaborating with third-party consulting and DBA teams (e.g., Infosys) is a plus.

Preferred

• Experience with large-scale data migration or modernization projects.

• Familiarity with associated cloud or platform services (such as Fivetran integrations).

• Prior work on similar projects in a Pharma or Research environment is advantageous. Engagement Model