Oracle Advance Engineering
ey
Job Description
- Design, develop, test, and support ETL/ELT solutions using Oracle Data Integrator (ODI).
- Build and maintain AWS data pipelines using services such as Amazon S3, AWS Glue, Amazon Redshift, and related cloud services.
- Develop and optimize data transformation logic using SQL, PL/SQL, and PySpark.
- Create and maintain PL/SQL procedures, functions, packages, triggers, and scripts to support data integration and processing requirements.
- Analyze and troubleshoot SQL and PL/SQL code, resolve data issues, and support basic performance improvements.
- Support data ingestion, integration, validation, reconciliation, and production deployment activities.
- Orchestrate and monitor workflows using Apache Airflow or equivalent scheduling tools.
- Contribute to data lake and lakehouse solutions, including Apache Iceberg-based implementations where applicable.
- Investigate pipeline failures and improve performance, stability, and operational reliability.
- Collaborate with business, analytics, architecture, and engineering teams to translate requirements into scalable data solutions.
- Follow engineering standards for documentation, code reviews, version control, testing, and release management.
- Mentor junior team members and contribute to continuous improvement of delivery practices.