SQL Oracle Developer

Overview

Hybrid
Depends on Experience
Contract - W2

Skills

Oracle
PL/SQL
Informatica
Shell scripting
Data Connect
SQL Developer
data warehouse
API
Big Data
Extract
Transform
Load
Scripting
SQL

Job Details

Job Details
Have 4 openings available for an SQL Oracle Developer
Onsite Interview in Plano, TX or Jersey City, NJ is a must

Interview Process:
Virtual Code Pair
Onsite Interview

Hybrid in Plano, TX or Jersey City, NJ 3 times a week

Any work authorization as long as they don t need sponsorship now
Overview
We are hiring 4 SQL Developers to support the Climate Risk team. This team manages a large, authorized data warehouse and provides critical data to various lines of business, including regulatory POCs. The work involves understanding and modeling data related to natural disasters (e.g., floods, earthquakes) and their impact on trades and Bank of America s exposure.
Role Breakdown
  • 2 Senior SQL Developers
    • Lead conversations with business stakeholders
    • Drive technical direction and strategy
    • Provide mentorship and oversight
  • 2 SQL Developers (Hands-On)
    • Focused on development and implementation
    • Support production and build custom features
Responsibilities
  • Manage and maintain a big data warehouse
  • Integrate third-party vendor data
  • Perform data modeling around climate risk scenarios
  • Support both production and new development efforts
  • Use Data Connect, an internal tool
  • Implement ETL mappings, procedures, and triggers
  • Understand and apply dimensional modeling and data warehouse structures
Must-Have Skills
  • Oracle
  • PL/SQL
  • Informatica
  • Shell scripting for API interaction
  • Experience fetching data from APIs
Nice-to-Have Skills
  • Mulesoft
Work Locations
  • 2 positions in Plano, Texas
  • 2 positions in Jersey City, New Jersey
  • Hybrid Schedule: 3 days onsite per week
Interview Process
  1. Virtual Technical Screening
  2. Onsite Interview
Next Steps
  • Touchbase Scheduled: Friday at 2:00 PM
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.