SQL Developer

Themesoft Inc.; Plano (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology company is seeking 4 SQL Developers to support its Climate Risk team in Plano, Texas. The roles involve managing a major data warehouse and creating data models related to natural disasters. Candidates should possess strong skills in Oracle, PL/SQL, and Informatica. The position includes both senior and hands-on roles within a collaborative environment, ensuring vital data management for regulatory purposes.

Qualifications

• Strong background in database management and development.
• Experience managing big data warehouses and ETL processes.

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.

Skills

Oracle

PL/SQL

Informatica

Shell scripting for API interaction

Experience fetching data from APIs

Job description

Please Note: This role has a final onsite interview and unfortunately we don\'t have Visa Sponsorship for this role.

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 Client\'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

Interview Process

• Virtual Technical Screening
• Onsite Interview

Regards,

Purnima Pobbathy

Senior Technical Recruiter

972 737 8626

| [e-mail] | Themesoft Inc