Description

You design, build, and maintain complex ETL pipelines for the Data Lake and Warehouse.

This role is hybrid.

Responsibilities

• Develop data pipelines using SQL, PL/SQL, and Informatica IICS on Oracle Exadata.
• Design data management architecture and implement ETL solutions for enterprise data warehouses.
• Create data models and ER diagrams for existing and new databases.
• Perform extraction, transformation, and loading activities to support business requirements.
• Maintain and improve existing processes, including SQL and ETL performance tuning.

Required Skills

• 5+ years of experience as an ETL Developer.
• 2+ years of experience with Oracle database full lifecycle development, including data modeling and architecture.
• Strong expertise in PL/SQL programming, including cursors, exception handling, stored procedures, and performance tuning.
• Proficiency in SQL and ETL processes with a focus on unit testing and support.
• Hands-on experience with ETL tools, specifically Informatica IICS.
• Ability to design data management solutions for data lakes and data marts.

Preferred Skills

• Experience with Oracle Exadata database.
• Strong problem-solving skills for complex data structures.

Key Skills

Education

Bachelor's degree