Data Engineer (Epic Clarity Migration)
Posted Updated
Description
Zencore is seeking a Data Engineer to lead a high‑volume healthcare data migration from Oracle Clarity to Google BigQuery. You will bridge legacy on‑prem infrastructure with modern cloud architecture and own complex data type conversions.
You will design migration processes, develop automated SQL scripts, validate replication at scale, troubleshoot pipeline issues, and document data lineage for clinical reporting purposes.
Design and execute migration from Oracle (Clarity) to Google BigQuery. Handle schema mappings and data type conversions (timestamps, numerics, char sets). Troubleshoot pipeline failures due to hardware latency and legacy constraints. Develop automated SQL scripts and testing frameworks for data validation at scale. Perform root cause analysis on data inconsistencies and document conversion logic. Optimize SQL queries in BigQuery to manage costs and latency. Collaborate with Data Analysts to verify business logic and clinical reporting. Deep understanding of Clarity data model, ETL Console, and Oracle structures. Advanced PL/SQL scripting and performance tuning. Experience moving on-prem data warehouses to the cloud (ETL/ELT). Proficiency in SQL; Python or Shell scripting for automation preferred.Skills
Sign in to read and join the discussion.