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)
•
Last updated on Jan 7, 2021