@Orchard LLC has been retained by a specialty Federal Consulting firm, focused exclusively in the areas of BI Reporting, Data Analysis, Data Engineering, and Data Science, with market-leading solutions and services supporting these areas of need within the Government sector. Our client is seeking an Oracle Developer with AWS experience to join a data warehouse (DW) and BI development team supporting their federal customer’s data warehouse and financial reporting system. The candidate should have strong ETL and PL/SQL experience and be able to provide technical leadership, guidance, and support in implementing strategic technology approaches and designing advanced solutions for the customer. This is a full-time position on a multi-year contract with on-site work performed at the client’s office located in Washington, D.C., Top Secret clearance required.
As the Oracle AWS Developer, you will:
- Work with an existing DW team to convert our On-Premises Oracle EE (19c) Data Warehouse over to AWS GovCloud in an Oracle RDS platform.
- Create tables, views, materialized views, indexes, constraints, and PL/SQL-based ETL routines in support of our business intelligence platform.
- Apply changes to objects and code to keep pace with the yearly changes in the OLTP system and ensure that the ETL runs a efficiently and often as possible.
- Work in a fast-paced Agile environment within JIRA for your sprint workload and backlog grooming of future stories and tasks.
Your background will need to include:
- Bachelor’s degree required
- 5-7 years’ experience building data warehouse fact and dimension tables, views, materialized views, and bitmap/b-tree indexes.
- Direct solid experience using PL/SQL code to perform ETL for both full loads and incremental loads from an OLTP system to a Dimensional Data Warehouse.
- QA (testing and documentation) experience for PL/SQL development and peer reviews.
- Experience with converting PL/SQL ETL to other options available in AWS (GovCloud preferred) such as Glue or equivalent.
- Preferred experience for Oracle to Redshift conversions where the majority of the conversion is not automatable.
- Experience working within an Agile/SAFe teaming environment with multiple vendors and stakeholders.
- Momentum Financials experience a plus.
- Top Secret clearance required.
- Willingness to work 100% on-site in Washington, DC (metro accessible)
