Data Warehouse DeveloperThe 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 warehouseCreate test scripts and support all testing phases/activitiesAssist with requirements gatheringLog task status using JIRAAd hoc data requests and data analysisNote: work can be performed remotelyRequired skills (at least 3 years' experience):Experience in data warehouse projectsKnowledge of PL/SQLAbility to write intermediate to advanced SQL statementsSkills:Oracle Big Data Application; Data Warehouse ToolsOracle Business Intelligence Enterprise Edition (OBIEE)Additional skills preferred:ETL experience using Oracle Data Integrator (ODI) or willingness to learn itExperience with Oracle tools, e.g.
SQL Developer and OBIEEDimensional data modelingConfiguration Management conceptsData profiling, data managementKnowledge of cloud platforms (AWS, MS Azure)