Description

You will design, automate, and support data extraction, transformation, and loading applications within a data warehouse and data lake environment.

Responsibilities

• Design and develop dimensional hierarchies and data models to support Enterprise Data Management reporting.
• Perform data ingestion from heterogeneous sources into on-premises or cloud storage including Snowflake and AWS.
• Manage ETL processes and automate data pipelines using DBT, ODI, and Shell Script.
• Configure RPD metadata, including physical, BMM, and presentation layers, and set up LDAP Authentication.
• Develop dynamic, interactive dashboards and ensure data quality through rigorous validation.

Required Skills

• 5+ years of experience in data development and ETL management.
• Expertise in Oracle PL/SQL and Oracle SQL.
• Proficiency with DBT, ODI, and Shell Scripting.
• Hands-on experience with Snowflake and AWS data environments.
• Experience developing RPD metadata and customized analytics repositories.
• Knowledge of API development frameworks.
• Experience with cloud-native data integration technologies.
• Ability to design data models for large-scale data processing.

Preferred Skills

• Experience with cloud-native data integration.
• Knowledge of API development frameworks.

Key Skills

Education

Any Gradute