Senior Oracle ETL Developer - Hybrid

Title: Senior Oracle ETL Developer - Hybrid

Location: Raleigh, NC, United States

Length: Long term

Restriction: W2 or C2C

Description:

*** Very long term project initial PO for 1 year, expect to go for 4+ years *** ***Hybrid***

Description:

senior ETL and reports developer to provide business and systems analysis, modeling, design, and programming for FNS/SNAP reports development and maintenance operations using ORACLE, and PL\SQL programming technologies.

Selected candidate must understand the underlying data sources (databases) and interpret requirements provided by the business to analyze operational issues and develop appropriate diagnostic and/or tracking data via reports and dashboards. Duties include but are not limited to gathering and documenting requirements for new as well as changes to existing data extracts and report, developing complex queries against big tables storing CLOBS/XML, necessary supporting data structures, and report layouts, and writing effective SQL queries that perform well even against large tables. This role will also analyze existing queries and report and query data to fix issues and extract data and develop and analyze operational performance metrics and reports to ensure the quality and integrity of extracts though the use of validation and audit strategies. This position will have responsibility for 24x7 On Call support rotation.

Required Skills

Experience in using Oracle, Oracle Utilities, ETL tools 7Years

Experience with PL/SQL scripting and relational database modeling. 7Years

Experience with structured system development methodologies 7Years

Ability to develop relationships and partnerships with customer by responding to needs and exhibiting an sense of urgency and independently identify options. 7Years

Ability to organise, prioritise, and follow complex and/or detailed technical procedures. 7 Years

Experience with Business Intelligence tools such as Business Objects or BIRT5Years

Highly Desired Skills

Experience with Agile (Scrum, Kanban, or SAFe) development 3 Years

Data Warehouse experience 4Years

Experience with developing dashboards with Power BI and Azure Synapse 2Years

Ability to lead and mentor the team and take ownership 5 Years

Desired Skills:

Familiarity with Amazon RedShift & Tableau 2 Years

Experience with Dell Boomi 2 Years