Senior Oracle Data Warehouse & ETL Engineer

Talent Groups; Augusta (ME); On-site; USD 110,000 - 150,000; Full time

Job summary

Talent Groups is seeking a senior Oracle database developer to lead complex data warehouse and ETL initiatives. The role requires seven years in application development and five years with Oracle SQL/PL-SQL, plus strong production support and performance tuning skills.

You will troubleshoot production issues, optimize queries, and ensure data quality across loads. Collaboration with analysts and stakeholders is essential to deliver reliable, well-documented solutions.

Qualifications

• Minimum of seven (7) years of progressively responsible application development, database programming, and production-support experience.
• At least five (5) years of hands-on experience with Oracle databases, SQL, and PL/SQL.
• Experience with data warehouses, ETL processes, production data loads, and data-quality validation.

Responsibilities

• Monitor and validate scheduled and ad hoc data loads, reconcile source and target results, investigate discrepancies, and resolve data-quality issues.
• Investigate production incidents, analyze application and database behavior, identify root causes, correct defects, and verify that solutions do not introduce unintended impacts.
• Translate business needs, operational concerns, and user-reported issues into clear technical requirements and workable solutions.
• Review and understand assigned tasks, dependencies, and acceptance criteria before development; seek clarification when needed.
• Analyze design specifications, identify risks, and provide feedback on alternative designs and performance considerations.
• Develop and execute unit, integration, system, regression, and data-validation tests to confirm functionality and data accuracy.
• Create and maintain accurate system, program, operational, and user documentation.
• Participate in reviews of system designs, database designs, source code, and deployment procedures.
• Assist technical and business users in understanding application functionality and reporting capabilities.
• Manage work independently, prioritize, meet deadlines, and coordinate with team members.
• Identify risks and blockers, and communicate status and resolution details clearly to stakeholders.

Skills

SQL Proficiency

PL/SQL

Data Warehousing

Performance Tuning

Production Support

Stakeholder Communication

Tools

Oracle SQL Developer

Oracle

ETL Tools

Data Integration

Source Control

Job description

Talent Groups is seeking a senior Oracle database developer to lead complex data warehouse and ETL initiatives. The role requires seven years in application development and five years with Oracle SQL/PL-SQL, plus strong production support and performance tuning skills.

You will troubleshoot production issues, optimize queries, and ensure data quality across loads. Collaboration with analysts and stakeholders is essential to deliver reliable, well-documented solutions.