Oracle Developer

Oracle Developer

Jersey City, NJ OR Charlotte, NC - Hybrid

Skills Grid: Python, Oracle Exadata, Oracle SQL PL/SQL

Year of Experience - 10

MUST HAVE ORACLE AND OBJECT-ORIENTED EXPERIENCE. MUST HAVE STRONG EXPERIENCE WITH COMPLEX QUERIES.

EXADATA IS A HUGE PLUS, BUT PERFER CANDIDATE WITH THAT EXPERIENCE.

MUST WORK AT LEAST 3-DAYS ONSITE FROM DAY ONE!

PERFECT CANDIDATE WILL COME FROM A BANKING BACKGROUND.

Seeking an Application Architect with our client in the financial industry located in Jersey City, NJ or Charlotte, NC. This is a 12 month contract position.

Responsibilities:

• The candidate for the Backend/ETL developer position will be responsible for designing and developing batch/ETL interfaces using the proprietary meta data driven approach as part of the LIBRA Interface Team
• The candidate will be responsible for maintenance and support of the existing interface processes including investigation of issues and production troubleshooting.
• Candidate will be responsible for maintaining the data lineage to facilitate the end-to-end traceability as and when changes to the ETL.
• Candidate will be responsible for Liquidity report specific derivations.
• Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads, etc. and that maximizes re-usable components and services that incorporate versioning, reconciliation, and exception handling.
• Perform application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, and AWR Reports
• Maintain high standard and follow best practices by re-factoring existing code to enhance readability, performance, and general structure.

Requirements:

• 10 years' experience in Oracle Exadata, SQL, PL/SQL
• 2-3 years' experience in SQL Performance tuning
• Should have a clear understanding of Oracle Server Process Architecture and memory structures PGA (Program Global Areas) SGA (System Global Areas) to optimize memory usage.
• Knowledge about Oracle VPD
• Expertise in performance profiling, ability to identify performance improvements and memory optimizations.
• Strong coding, debugging, and analytical skills.
• Knowledge about Oracle architecture and process
• Knowledge of computer science data structures and algorithms
• Experience with Analytic reporting tools like Tableau
• Analytical skills to perform technical and functional analysis with strong communication skills.
• Experience working in Containers.
• Knowledge about Python and Apache Airflow
• Experience in CICD, Jenkins, Git
• Experience working in Agile teams.

Desired Skills:

• Experience working in regulatory projects.