Note: The job is a remote job and is open to candidates in USA. Accenture Federal Services is seeking an Oracle Autonomous Data Warehouse (ADW) Database Administrator and ETL Engineer to implement and administer ADW and develop data integration pipelines using OCI Data Integration. The role builds scalable data solutions, optimizes analytical performance, and supports enterprise reporting and analytics initiatives.
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
Skills
- 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
- U.S. Citizen – Dual Citizen
- Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States
- 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
Benefits
- Remote work
- Certifications and industry training
Company Overview