Description

Design, automate, and support data extraction, transformation, and loading applications within data warehouse and data lake environments.

Responsibilities

• Design dimensional hierarchies and data models to support Enterprise Data Management reporting.
• Manage ETL processes using DBT, ODI, Oracle PL/SQL, and ShellScript.
• Develop RPD metadata, including physical, BMM, and presentation layers, and configure LDAP Authentication.
• Build dynamic, interactive dashboards and execute data quality validation.
• Perform data ingestion from heterogeneous sources into on-premises or cloud storage, including Snowflake and AWS.

Required Skills

• 10+ years of experience in data development.
• Expertise in Oracle PL/SQL and Oracle SQL.
• Proficiency with ETL tools including DBT and ODI.
• Hands-on experience with ShellScript.
• Experience with Snowflake and AWS cloud environments.
• Strong knowledge of Oracle database for batch application development.
• Experience with RPD metadata design and analytics repository customization.
• Ability to develop API frameworks and use cloud-native data integration technologies.

Preferred Skills

• Experience gathering, processing, and analyzing large-scale datasets.

Key Skills

Education

Any Graduate