Description

You will design, develop, and maintain metadata-driven ETL interfaces for large-scale data processing.

This role is hybrid.

Responsibilities

• Design and develop batch and ETL interfaces using proprietary metadata-driven approaches.
• Maintain and support existing interface processes, including production troubleshooting and issue investigation.
• Maintain data lineage to ensure end-to-end traceability for ETL changes.
• Develop specific derivations for Liquidity reporting and refactor code for improved readability and performance.

Required Skills

• 7+ years of experience with Oracle Exadata, SQL, and PL/SQL.
• Proven experience implementing ETL solutions for large data volumes using Star Schema, data partitioning, and data compression.
• Strong expertise in SQL performance tuning using EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, and AWR Reports.
• Deep understanding of Oracle Server Process Architecture, including SGA and PGA memory structures.
• Hands-on experience with Oracle VPD.
• Proficiency with Git, Jenkins, and CI/CD pipelines.
• Strong knowledge of computer science data structures and algorithms.
• Experience working within Agile teams.

Preferred Skills

• Knowledge of Python and Apache Airflow.
• Experience with Containers and Tableau.
• Experience working on regulatory projects.

Key Skills

Education

Any Graduate