Oracle Developer

Location: Onsite 3 days a wk; Hybrid – Office location is Charlotte NC

Required Pay Scale: $60-65hr W2

***Due to client requirements this role is only open to USC or GC candidates***

Summary

We are seeking a Senior Oracle Data Warehouse Developer to design, build, and optimize enterprisescale data integration and analytics solutions. This role requires deep Oracle database expertise (SQL/PL/SQL, performance tuning, partitioning, query optimization), handson experience with Apache NiFi, Python, and Informatica.

Responsibilities:

• 8 years of experience in data warehouse development with a strong Oracle database background.
• Expertlevel IDMC development of taskflow, mappings etc.
• Expert- level SQL and PL/SQL; deep knowledge of partitioning, indexing strategies, optimizer behavior, statistics, execution plans, and parallel processing.
• Handson experience building production pipelines with Apache NiFi (processors, flow files, back pressure, provenance, parameter contexts)
• Solid Python for data transformations, file/API integrations, and utility automation (e.g., pandas, PySpark).
• Proficiency with Linux/Unix, shell scripting, and job scheduling on Autosys
• Strong understanding of enterprise SDLC practices, Gitbased workflows, code reviews, and dev/test/prod release management.

Requirements include

Experience with Oracle Exadata, IDMC, SQL*Loader, and bulk load strategies.

Familiarity with Databricks, Snowflake

Knowledge of data governance and catalog tools (Collibra, Alation).

Understanding of security, privacy, and compliance controls (encryption, masking).

Core Competencies

Systems thinking with a bias to measurable performance and reliability.

Strong problemsolving and rootcause analysis on complex data issues.

Clear, concise communication-able to translate between business needs and technical solutions.

Ownership mindset, collaboration, and mentoring abilities in a fastpaced environment.

Success Metrics

SLA attainment for pipeline throughput and timeliness.

Measurable query and pipeline performance improvements (e.g., % reduction in runtime/cost).

Data quality SLAs: accuracy, completeness, and reconciliation rates.

Reusability and standardization of components; reduced manual effort via automation.

Positive stakeholder satisfaction and audit/controls compliance.

Database: Oracle 12c/19c/21c, Exadata; partitioning.

ETL/ELT: Apache NiFi, IDMC, Python (pandas), PL/SQL.

Orchestration/CI/CD: Git, Jenkins.

Data Ops: Linux/Unix, shell scripting, SQL*Loader, external tables, file and API integrations (REST/JSON).

About Matlen Silver

Experience Matters. Let your experience be driven by our experience. For more than 40years, Matlen Silver has delivered solutions for complex talent and technology needs to Fortune 500 companies and industry leaders. Led by hard work, honesty, and a trusted team of experts, we can say that Matlen Silver technology has created a solutions experience and legacy of success that is the difference in the way the world works.

Matlen Silver is an Equal Opportunity Employer and considers all applicants for all positions without regard to race, color, religion, gender, national origin, age, sexual orientation, veteran status, the presence of a non-job-related medical condition or disability, or any other legally protected status.

If you are a person with a disability needing assistance with the application orat any point in the hiring process, please contact us at email and/or phone at info@matlensilver.com // 908-393-8600