Description

You will lead the design and optimization of enterprise data solutions.

Responsibilities

• Optimize database and query performance to meet SLAs, such as 2 second response time.
• Analyze execution plans and recommend strategies for indexing, partitioning, and query optimization.
• Oversee and enhance ETL/ELT workflows using Oracle Data Integrator ODI, ensuring scalability and data quality.
• Leverage AWS services (S3, Redshift, Glue, Lambda, DMS) for cloud-based data ingestion, transformation, and storage.
• Lead and mentor a team of data engineers, translating complex decisions for technical and non-technical stakeholders.

Required Skills

• 7+ years of experience in data engineering within enterprise-scale environments.
• Proven expertise in Oracle performance tuning, including query optimization, execution plans, indexing, partitioning, and parallelism.
• Strong proficiency in writing and optimizing complex SQL queries.
• Strong proficiency in understanding, writing, and debugging Stored Procedures and Functions.
• Hands-on experience with Oracle Data Integrator ODI.
• Solid understanding of data warehouse design, ETL/ELT processes, and data modeling.
• Experience with AWS data services (S3, Redshift, Glue, Lambda, DMS).
• Demonstrated leadership experience, including mentoring and guiding technical teams.
• Excellent verbal and written communication skills in English.

Key Skills

Education

Any Graduate