Required Skills: PL/SQ, Informatica, Oracle
Job Description
Client: Bank of America
Role: Oracle Developer
Location: Hybrid in Plano, tx or Jersey City, NJ 3 times a week
Onsite Interview in Plano, TX or Jersey City, NJ is a must
Interview Process:
Virtual Code Pair
Onsite Interview
Any work authorization s 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
Work Locations
- 2 positions in Plano, Texas
- 2 positions in Jersey City, New Jersey
- Hybrid Schedule: 3 days onsite per week
Interview Process
- Virtual Technical Screening
- Onsite Interview
Next Steps