Job Overview
We are seeking a seasoned Data Engineering expert to lead the delivery of high-performance data integration and analytics solutions. As Lead Data Engineer, you will be responsible for designing, developing, and implementing enterprise-grade data solutions using Oracle performance tuning and ODI.
Key Responsibilities:
* Optimize database query performance to meet strict service level agreements (SLAs) under two seconds.
* Analyze execution plans and recommend indexing, partitioning, and optimization strategies to ensure efficient data processing.
* Collaborate with Database Administrators (DBAs) to validate and implement tuning recommendations.
* Oversee Extract, Transform, Load (ETL)/Extract, Load, Transform (ELT) workflows to ensure scalability, efficiency, and data quality.
* Leverage Amazon Web Services (AWS) services such as S3, Redshift, Glue, Lambda, and DMS for ingestion, transformation, and storage.
* Lead and mentor the team in technical excellence and continuous improvement.
* Presentation of technical decisions in clear explanations for both technical and business stakeholders.
Required Qualifications:
* Seven plus years of experience in data engineering within large-scale environments.
* Expertise in Oracle performance tuning, including query optimization, execution plans, indexes, partitioning, and parallelism.
* Hands-on experience writing and optimizing complex Structured Query Language (SQL) queries.
* Expertise in Oracle Data Integrator (ODI).
* Experience in data warehouse design, ETL/ELT processes, and data modeling.
* Proven leadership experience, including team mentoring and technical guidance.
* Excellent communication skills, with the ability to collaborate effectively with DBAs, technical teams, and business stakeholders.