Senior ETL/Database Developer

Key Duties/Responsibilities:
•         Performs ETL and database development activities for the Enterprise Data Warehouse in the Oracle Cloud Infrastructure, Oracle Autonomous Data Warehouse Environment
•         Reviews existing architecture and provides solution recommendations where applicable
•         Develops, tests, and implements scripts/jobs for data Extract Transform and Load (ETL) from data source(s) to target(s) in the data warehouse using ODI
•         Design, develop, and optimize ETL processes using Oracle tools and technologies
•         Create and maintain data pipelines to extract data from various sources, transform it according to business rules, and load it into Oracle data warehouses
•         Collaborate with data analysts and business stakeholders to understand data requirements and implement appropriate solutions
•         Troubleshoot and resolve data quality issues and performance bottlenecks
•         Document ETL processes, data mappings, and data lineage
•         Implement data quality checks and validation procedures
•         Participate in code reviews and adhere to best practices in ETL development
•         Hands-on experience working with and managing Oracle's Autonomous Data Warehouse (ADW) service