Principal Business Metrics Platform Development Engineer – Oracle Cloud

Oracle; Región Centro; Presencial; MXN 1,455,000 - 2,184,000; Jornada completa

Descripción de la vacante

A leading tech company located in Mexico is seeking a highly skilled Data Engineer to manage data pipelines and develop automated solutions. The ideal candidate will have strong expertise in Oracle Database 19c and advanced SQL capabilities, along with proficiency in Python for data engineering tasks. Familiarity with cloud platforms and experience in AI/ML techniques will be significantly valued. The role emphasizes collaboration and robust operational background across various environments.

Formación

• Strong expertise in Oracle Database 19c and above with advanced proficiency in SQL.
• Intermediate to advanced PL/SQL skills for developing packages and exception handling.
• Proficiency in Python for data engineering and automation is mandatory.

Responsabilidades

• Develop and manage data pipelines using Oracle and Python for automation and data quality.
• Utilize cloud infrastructure for data management, particularly in Oracle Cloud.
• Create dashboards and reports using Oracle APEX and Oracle Analytics Cloud.

Conocimientos

Oracle Database expertise (19c+)

Advanced SQL

PL/SQL development

Python proficiency

AI/ML techniques

Oracle APEX

Data Visualization

Cloud platform experience

Git for version control

Jira for task management

Herramientas

Oracle Analytics Cloud

DBMS_CLOUD

oracledb driver

Descripción del empleo

• Oracle & Data Core (Mandatory): The candidate must demonstrate strong expertise in Oracle Database 19c and above, with advanced proficiency in SQL—covering CTEs, analytic functions, and window functions. Intermediate to advanced PL/SQL skills are required for developing packages, jobs, and robust exception handling. Hands‑on experience with Materialized Views across all refresh modes (Fast, Complete, On Demand) is essential, as is proficiency with table partitioning strategies such as Range, Interval, and Hash.
  Proven experience using Data Pump (expdp/impdp) for data export and import is required. Familiarity with Oracle’s JSON capabilities, including SODA Collections and Duality Views, is highly desirable. The role also demands strong debugging capabilities to identify and resolve data inconsistencies across schemas and between DEV, UAT, and PROD environments.
  
• Cloud Technologies (Desirable): The candidate should have practical experience with cloud platforms such as Google Cloud Platform, Microsoft Azure, or Amazon Web Services. Experience with Oracle Cloud Infrastructure (OCI) is highly preferred, particularly with services like Autonomous Database and Object Storage. A solid understanding of cloud security—including IAM, compartments, and policy configuration—is required. Experience using DBMS_CLOUD and DBMS_CLOUD_PIPELINE for cloud-based data ingestion, automation, and orchestration is expected. Knowledge of Pre‑Authenticated Requests (PARs), database cloning, environment refreshes, migrations, and production cutovers is considered a strong advantage.
  
• Python for Data & Automation (Mandatory): The candidate must be highly proficient in Python, with demonstrable experience in data engineering and process automation. This includes advanced scripting for data processing, external service integration, and API consumption.
  Experience connecting Python applications to Oracle using the oracledb driver is required. The candidate must be capable of automating data ingestion from multiple external sources, performing data quality validations, executing cross‑environment comparisons, and processing large datasets in formats such as CSV and JSON. Experience with cron or similar scheduling tools for running automated jobs is also required.
  
• Artificial Intelligence & Machine Learning (Big Plus): Hands‑on experience with AI and Machine Learning techniques is highly valued. The candidate should be familiar with implementing classification models, pattern analysis, and anomaly detection solutions.
  Experience applying predictive models to support business analytics and operational decision‑making is a significant advantage. The ability to operationalize AI/ML outputs within production systems and data pipelines is also desired.
  
• Data Visualization & Consumption (Mandatory): Strong experience in Oracle APEX is expected, including the development of dashboards, Interactive Reports, and Interactive Grids. The candidate must be comfortable consuming views and materialized views as primary data sources.
  Experience with Oracle Analytics Cloud for enhanced reporting and advanced analytics is highly desirable.
  
• Operations: Proficiency with Git for version control and Jira for task and workflow management is required. The candidate must have operational experience across DEV, UAT, and PROD environments, including production support, hot fixes, incident response, and post‑deployment validations.
  The role requires effective collaboration with distributed teams, particularly across Mexico and India.
  
• Functional Profile (Key Competencies): The ideal candidate demonstrates strong analytical and logical reasoning abilities, with a solid foundation in data modeling. Exceptional attention to detail—especially concerning data consistency and quality—is essential.
  The role requires technical autonomy, sound decision‑making, and effective communication with both technical and non‑technical stakeholders. The candidate must be capable of owning end‑to‑end data processes, from ingestion through analytical delivery.
  

Qualifications

Career Level - IC4

Responsibilities

Highly skilled Data Engineer with strong expertise in Oracle Database (19c+), advanced SQL, PL/SQL development, Materialized Views, partitioning, Data Pump, and cross‑environment data debugging. Proficient in Python for data engineering, automation, API integration, data quality validation, and large‑scale file processing, with experience connecting Python to Oracle using oracledb. Brings hands‑on experience with major cloud platforms—particularly Oracle Cloud Infrastructure—for Autonomous Database, Object Storage, DBMS_CLOUD, migrations, and environment management. Experienced in AI/ML model application for classification, anomaly detection, and analytics integration. Capable in Oracle APEX dashboard development and familiar with Oracle Analytics Cloud. Strong operational background with Git, Jira, and multi‑environment support (DEV/UAT/PROD). Demonstrates exceptional analytical ability, attention to detail, data modeling expertise, and full ownership of end‑to‑end data solutions, working effectively in distributed teams.