Senior ETL DB Developer

Performing ETL and database development activities.
- Providing solution recommendations for existing architecture.
- Developing, testing, and implementing scripts/jobs for data ETL.
- Creating and maintaining data pipelines.
- Collaborating with data analysts and business stakeholders.
- Troubleshooting and resolving data quality issues.
- Documenting ETL processes, data mappings, and data lineage.
- Implementing data quality checks and validation procedures.
- Participating in code reviews.
- Developing physical data model.
- Developing testing approach, plan, scripts, and documentation of results.
- Participating in developing requirements and design specifications.
- Monitoring the EDW and responding to incidents.
- Providing documentation to support the Kimball Dimensional Data Modeling Framework.
- Mentoring and educating team members.

Qualifications:
- Minimum 10 years of experience.
- Minimum of seven years of verifiable experience in database design, development, and warehouse architecture.
- At least two years of experience performing ETL development activities in an Oracle Autonomous Data Warehouse.
- Five years’ experience performing development in Oracle data warehouses.
- Proficiency in Oracle Database, PL/SQL, and SQL.
- Experience with Oracle Data Integrator or Oracle GoldenGate.
- Understanding of data warehousing concepts and dimensional modeling.
- Experience with Oracle Business Intelligence Enterprise Edition is a plus.
- Ability to perform technical leadership of an Oracle data warehouse team