The Senior ETL and Reports Developer will analyze requirements, develop complex queries, and maintain ETL processes and reports using Oracle and PL/SQL, ensuring quality and integrity of extracts.
Job Title: Senior ETL and Reports Developer (Hybrid)
Location: Durham, NC
Duration: 12+ Months
Job Description:
The client requires the services of a 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.
The client seeks a contractor to assist with implementation and maintenance of data extracts, ETL batch jobs, and reports, for client using Cúram Software product and Oracle. The selected candidate will analyze and identify reporting requirements for client Case Management System reports and implement recommendations to effectively report data of mid to high level complexity. This is related to varied business metrics and for designing, coding, testing, debugging, and documenting data interfaces and reporting solutions, while enhancing existing data extracts and reports to ensure that solutions continue to meet business needs.
Duties:
- 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.
Skills:
Top Skills
Amazon Redshift
Azure Synapse
Birt
Business Objects
Dell Boomi
Etl Tools
Oracle
Pl/Sql
Power BI
SQL
Tableau
Similar Jobs
.png)
Hardware • Information Technology • Security • Software • Cybersecurity • Conversational AI
Design and develop hardware for routing products, contributing to system hardware design, specifications, and product realization, working with various teams.
Top Skills:
Arm ProcessorsCadence Allegro Design Entry HdlDdr4Ddr5EthernetHyperlynxI2CPcie Gen1Pcie Gen2Rs232SataSpiSpiceUartUsbVerilogX86 Processors
AdTech • eCommerce • Food • Marketing Tech • Retail
Lead ServiceNow platform architecture and strategy. Collaborate with stakeholders to implement ITSM capabilities, enhance UX, and ensure platform health and governance.
Top Skills:
AIAiopsCmdbFlow DesignerItilItsmServicenow
AdTech • eCommerce • Food • Marketing Tech • Retail
Lead the cloud services team to deliver Azure-based solutions, manage product roadmaps, and drive cloud adoption while coaching and developing team members.
Top Skills:
AdoAnsibleArmAWSAzcliAzureGitPowershellPythonTerraform
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
