Sobre este puesto de Oracle Autonomous Data Warehouse (ADW) Database Administrator & ETL Engineer en Accenture Federal Services
The Work:
We are seeking an experienced Oracle ADW Database Administrator & ETL Engineer to support the implementation and administration of Oracle Autonomous Data Warehouse (ADW) and the development of data integration pipelines using Oracle Cloud Infrastructure (OCI) Data Integration. This role will be responsible for building scalable data solutions, optimizing analytical performance, and supporting enterprise reporting and analytics initiatives.
Key Responsibilities
- Provision, configure, and administer Oracle Autonomous Data Warehouse (ADW) environments within OCI.
- Design, develop, and maintain ETL/ELT pipelines using OCI Data Integration Cloud Service.
- Build and support data ingestion, transformation, and staging processes for analytics and reporting.
- Design, implement, and maintain STAR schemas and dimensional data models.
- Monitor and optimize database performance, storage utilization, and query efficiency.
- Collaborate with analytics, data engineering, and infrastructure teams to support reporting and data modeling needs.
- Manage security, access controls, and OCI resource configurations.
- Document data models, ETL processes, mappings, and system configurations.
Here’s What You Need:
- 3–5 years of experience as an Oracle Database Administrator, Data Engineer, or ETL Engineer.
- Hands-on experience with Oracle Autonomous Data Warehouse (ADW).
- Experience developing and managing pipelines with OCI Data Integration Cloud Service.
- Strong knowledge of Oracle Cloud Infrastructure (OCI) administration and configuration.
- Advanced SQL skills, including performance tuning and query optimization.
- Experience designing and maintaining STAR schemas and dimensional data models.
Bonus Points If You Have:
- Experience integrating ADW with Oracle Analytics Cloud (OAC).
- Familiarity with OCI services such as Object Storage, Data Catalog, Data Flow, and GoldenGate.
- Knowledge of cloud-based data warehousing and ETL/ELT best practices.
- Experience with data governance, metadata management, and cloud security practices.
Eligibility Requirements:
- U.S. Citizen – Dual Citizen
As required by local law, Accenture Federal Services provides reasonable ranges of compensation for hired roles based on labor costs in the states of California, Colorado, Connecticut, Hawaii, Illinois, Maine, Maryland, Massachusetts, Minnesota, New Jersey, New York, Ohio, Vermont, Virginia, Washington, and the District of Columbia. The base pay range for this position in these locations is shown below. Compensation for roles at Accenture Federal Services varies depending on a wide array of factors, including but not limited to office location, role, skill set, and level of experience. Accenture Federal Services offers a wide variety of benefits. You can find more information on benefits here. We accept applications on an on-going basis and there is no fixed deadline to apply.