Experis: Backend/ ETL Developer (NJ/12M)

Back-End Developer is needed in Jersey City, United States.

This job has been crawled from the web.

Client: Experis

Location: Jersey City, United States (Hybrid)

Contract: Contractor, 12 Months Contract

Position Summary:

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. In addition, the candidate will be responsible for Liquidity report specific derivations.

Primary Skill:

Oracle Exadata

Secondary Skill:

Oracle SQL / PLSQL

Tertiary Skill:

Python

Required Skills:

• 7-10 years experience in Oracle Exadata, SQL, PL/SQL
• 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
• 2-3 years experience in SQL Performance tuning. Perform application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE and AWR Reports.
• 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

Desired Skills:

• Experience working in regulatory projects is strongly desirable
• Experience working in Containers
• Knowledge about Python and Apache Airflow
• Maintain high standard and follow best practices by re-factoring existing code to enhance readability, performance and general structure
• Experience in CICD, Jenkins, Git
• Experience working in Agile teams