Data Engineer, Epic Clarity Migration

Job not on LinkedIn

🕒 February 5

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Zencore

WebsiteLinkedInAll Job Openings

11 - 50 employees

🤖 Artificial Intelligence

Artificial Intelligence • Cloud Computing • Consulting

Zencore is a premier Google Cloud consulting and engineering firm founded by a team of former Google engineers and executives. The company specializes in data, AI, and cloud migration services, delivering comprehensive implementation and operational solutions. Zencore is a trusted advisor to some of Google Cloud's largest and most complex clients, helping them to reduce risk and ensure success through tailored plans that maximize value and optimize performance. With expertise in Google Cloud services, Zencore provides solutions in infrastructure modernization, application development, machine learning, and artificial intelligence. Zencore's global reach and boutique model ensure a strong collaborative culture and client-focused approach.

📋 Description

• Design and execute technical processes to migrate data from Oracle (Clarity) to Google BigQuery. • Handle complex schema mappings, specifically resolving incompatibilities between Oracle data types and BigQuery (e.g., handling timestamps, numerics, and character sets). • Troubleshoot pipeline failures related to hardware latency and legacy infrastructure constraints. • Develop automated SQL scripts and testing frameworks to validate data replication accuracy at scale. • Perform deep-dive root cause analysis on data inconsistencies, distinguishing between genuine data errors and artifacts of the conversion process. • Create technical documentation for data lineage and conversion logic. • Optimize SQL queries for performance within the BigQuery environment to manage costs and reduce latency. • Collaborate with Data Analysts to verify business logic and ensure the migrated data meets clinical reporting standards.

🎯 Requirements

• Deep understanding of the Clarity data model, ETL Console, and underlying Oracle structures. • Advanced PL/SQL scripting, performance tuning, and understanding of Oracle legacy hardware constraints. • Proven track record of moving on-premise data warehouses to the cloud (ETL/ELT). • Proficiency in SQL is mandatory. Experience with Python or Shell scripting for automation is highly valued.