Job Title

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