Job Description
We are seeking an experienced Lead Data Engineer to design, develop, and lead the delivery of enterprise-grade data integration and analytics solutions.
The ideal candidate will have deep expertise in Oracle performance tuning and Oracle Data Integrator (ODI), combined with strong leadership and communication skills.
In this role, you will lead technical decision-making, mentor team members, and collaborate with DBAs and business stakeholders to deliver high-performance, scalable data solutions.
Key Responsibilities:
* Optimize query and database performance to meet strict SLAs (< 2 seconds).
* Analyze execution plans and recommend indexing, partitioning, and optimization strategies.
* Partner with DBAs to validate and implement tuning recommendations.
* Oversee ETL/ELT workflows, ensuring scalability, efficiency, and data quality.
* Leverage AWS services (S3, Redshift, Glue, Lambda, DMS) for ingestion, transformation, and storage.
* Lead and mentor the team, fostering technical excellence and continuous improvement.
* Translate technical decisions into clear explanations for both technical and business stakeholders.