Job Description

Primary Skills: Oracle, Python, Shell Scripting,
\xe2\x80\x93

"The Data Warehousing Developer is responsible for the development of the Enterprise Data Warehouse and Business Intelligence (BI) solutions. This role analyzes business and technical requirements and data warehouse models, to understand the detailed data management requirements and collaborates on the design, planning and modification of data warehouses and other BI solutions.
The incumbent creates and maintains database objectives for all environments, across multiple hardware and DBMS software platforms. Additionally, this role provides technical database expertise and problem-solving support to resolve DMS issues and assist in the monitoring of database performance.
Develop and maintain Data Repositories using Oracle database programming skills with Oracle PL/SQL, SQL, SQL Loader, Sync Sort and Linux shell scripting.
Proficient in one or more of following programming languages: Shell Scripting, SQL, Python, R, Java.
Experienced and knowledgeable with Microsoft SSIS, SSRS, and SSAS, Power BI.
Experienced and knowledgeable with AWS Lambda, S3, Glue, Athena, Redshift.

• Provide business expertise for the development of Business Intelligence solutions
• Provide technical expertise to the development and implementation of solutions using basic dimensional modeling techniques,

make recommendations for improvements in these areas when necessary

• Provide technical support for existing Data Warehouse ETL (Extract, transform, load) processes
• Assure quality of design and implementation of projects
• Trouble-shoot application software/hardware problems as they apply to design, implementation, or installation activities
• Schedules and coordinate application maintenance activities.
• Participate in on-call, overnight off-hour production problem resolution activities
• Follow DMS related standards and procedures, knows where they are located, and incorporates them; follows ETS software

development processes

• Research, evaluate, and test new software and DW related tools and facilities as they pertain to the existing DW environment and

applications

• Monitor current DW applications and develop procedures, where necessary, to improve the DW environment as required
• Identify and suppors quality improvement initiatives
• Perform other assignments to comply with the IS&T corporate purpose and mission to add business value, increase revenue,

decrease costs, improve productivity, and support the strategic initiative/directive
"

Job Summary

Role Based Competencies

Tech - Requirement Gathering
Beh - Assertiveness
Tech - Estimation
Tech - High level design
Tech - Low level design
Tech - Domain
Tech - Code quality and coding standards
Tech - Team Management
Beh - Problem Solving
Tech - Unit Testing
Tech - Agile Methodology
Tech - Systems Design and Architecture
Beh - Communication
Beh - Customer Orientation
Beh - Collaboration
Beh - Innovation

Mandatory Competencies

Database - PL/SQL
Database - SQL
Python - Python
Java - Linux
Beh - Communication and collaboration

Good to Have Competencies