Description

You will build and maintain data warehousing solutions using PL/SQL and SAS DI Studio.

This role is on-site.

Responsibilities

• Build and maintain SAS DI Studio jobs, job flows, and troubleshoot failures.
• Develop PL/SQL stored procedures, functions, triggers, and packages.
• Integrate data mappings from various sources into the Enterprise Data Warehouse using SAS Data Management.
• Analyze execution plans, optimize ETL job efficiency, and perform code reviews.
• Manage the full data warehousing lifecycle from requirement analysis and design to implementation and testing.

Required Skills

• 5+ years of experience in data warehousing environments.
• Proficiency in PL/SQL development, including packages and triggers.
• Hands-on experience with SAS DI Studio and SAS Data Management.
• Strong understanding of Star Schema, Snowflake Schema, Dimensions, and Fact tables.
• Experience with Linux/Unix shell scripting.
• Bachelor's degree.

Key Skills

Education

Bachelor's degree