Data Engineer, Epic Clarity Migration

Job not on LinkedIn

πŸ•’ February 5

πŸ‡¦πŸ‡· Argentina – Remote

⏰ Full Time

🟠 Senior

🚰 Data Engineer

Where this job comes from

Posted on Zencore 's careers page β†—Zencore 's careers page, not through a job board

First seen by Remote Rocketship February 5

Still open on Zencore 's site. Checked 3 hours ago.

Apply Now
Logo of Zencore

Zencore

11 - 50 employees

πŸ€– Artificial Intelligence

πŸ’Ό Consulting

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.

Apply Now

πŸ“Š Check your resume score for this job

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

Built byΒ Lior Neu-ner. I'd love to hear your feedback β€” Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok