Data Warehouse Developer

Responsiblties:

• Develop and maintain Oracle PL/SQL packages and scripts to maintain daily operation of data loading from servers and ETL process.
• Develop and maintain reports and daily data feeds to other city agencies.
• Monitor and maintain real-time and overnight data processing schedules.
• Understanding existing ETL Workflows. Modifying/re-architect ETL workflows.
• Develop data models and ER diagrams for existing and new databases.
• Design, develop, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
• Work with the business users and internal teams in designing and delivering correct, high-quality data.
• Provide technical support and production support to all the data warehouse projects.

Key Skills:

• Data Marts.
• Cubes.
• ETL.
• Quality Assurance/Quality Control.
• Software Development Lifecycle Management.
• Unit Testing.
• Debugging.
• Data Flow Diagramming.