Navitas Healthcare, LLC is looking to maintain and enhance existing data warehouse processes and systems, convert legacy ETL processes to modern enterprise ETL platforms, and develop new workflows to integrate additional datasets into the data warehouse environment.
Requirements
- SQL and PL/SQL*
- BI Publisher reports*
- Online Transaction Processing (OLTP)*
- Online Analytical Processing (OLAP)*
- ETL processes*
- Oracle Warehouse Builder and Attunity Compose
- Attunity Compose
Responsibilities
- Maintain and develop SQL and PL/SQL* code supporting enterprise transactional applications
- Maintain, convert, and develop BI Publisher reports* supporting transactional and reporting systems
- Perform database modeling for Online Transaction Processing (OLTP)* systems
- Perform database modeling for Online Analytical Processing (OLAP)* systems within the enterprise data warehouse
- Tune SQL queries to improve performance and efficiency
- Develop new ETL processes* using enterprise ETL tools
- Maintain existing ETL processes using legacy and modern ETL platforms (e.g., Oracle Warehouse Builder and Attunity Compose)
Other
- Only one candidate should be proposed for this role, and the candidate must meet all defined minimum qualifications.
- Additional years of experience beyond the minimum required qualifications
- Proven experience working in enterprise data warehouse environments supporting both transactional and analytical systems.