Job title: Oracle Developer with Bank experience
Location: Jersey City NJ.
Duration: 12 month contract W2
Work Type: Onsite
Exp Required: 10 Yrs
MustHave:
710 years experience in Oracle Exadata SQL PL/SQL
23 years experience in SQL Performance tuning
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
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 of Python and Apache Airflow
Experience in CICD Jenkins Git
Experience working in Agile teams.
Responsibilities:
Designing and developing batch/ETL interfaces using the proprietary metadatadriven approach as part of the LIBRA Interface Team
Maintenance and support of the existing interface processes including investigation of issues and production troubleshooting
Maintaining the data lineage to facilitate the endtoend traceability as and when changes to the ETL
Liquidity reportspecific derivations
Implement ETL solutions for large volumes of data by applying various data warehouse modeling techniques like Star Schema Data partitioning Data compression Direct path loads etc. and that maximizes reusable 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 standards and follow best practices by refactoring existing code to enhance readability performance and general structure
Desired Skills:
Experience working on regulatory projects
Knowledge of Python
Tekdoors Inc. is a leading staffing and IT consulting firm with a global presence and 16 years of IT consulting experience. Headquartered in Arizona we are rated the Top 10 most emerging IT consulting companies in 2024. Our mission is to provide topquality IT and talent solutions to businesses of all sizes helping them achieve their goals and stay ahead of the competition. With offices and operations worldwide we have the expertise and resources to deliver customized solutions that meet the unique needs of our clients. Our team of experienced recruiters and consultants has a deep understanding of the IT industry and its everchanging demands.