Data Warehouse Developer

Data Warehouse Developer

Must be a USC

Must be clearable for a Public Trust clearance. Can't start until issued

The developer will participate in a range of activities that support the operations and maintenance of the existing data warehouse as well as incorporating additional datasets.

Job responsibilities

O&M

Investigate issues and fix code as needed. Identify improvements needed in the current code.

• Implement enhancements or system upgrades.
• Develop ETL jobs to bring data to the data warehouse
• Create test scripts and support all testing phases/activities
• Assist with requirements gathering
• Log task status using JIRA
• Ad hoc data requests and data analysis;

** Note

work can be performed remotely

Required skills (at least 3 years' experience)

• Experience in data warehouse projects
• Knowledge of PL/SQL
• Ability to write intermediate to advanced SQL statements

Skills

Required

Oracle Big Data Application; Data Warehouse

Tools;

Required

Oracle Business Intelligence Enterprise Edition (OBIEE)

Plus NOT Required

Oracle SQL Developer

Additional skills preferred

• ETL experience using Oracle Data Integrator (ODI) or willingness to learn it
• Experience with Oracle tools, e.g. SQL Developer and OBIEE
• Dimensional data modeling
• Configuration Management concepts
• Data profiling, data management
• Knowledge of cloud platforms (AWS, MS Azure)