Why This Role Stands Out
This hybrid role offers a fantastic opportunity to hone your Oracle PL/SQL and ETL skills on a long-term project, developing impactful reporting solutions that directly address business needs. You'll thrive here if you enjoy complex data challenges and a collaborative environment where your expertise in relational database modeling and query optimization will be highly valued. Join a reputable company and contribute to critical projects with excellent growth potential.
Quick Overview
Job Description
Interview Type: Webcam Interview Only *** Very long term project; initial PO for 1 year, expect to go for 4+ years ***Hybrid***
Job Description
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.
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
- Gathering and documenting requirements for new as well as changes to existing data extracts and reports
- Developing complex queries against big tables storing CLOBS/XML, necessary supporting data structures, and report layouts
- Writing effective SQL queries that perform well even against large tables
- Analyzing existing queries and reports and querying data to fix issues and extract data
- Developing and analyzing operational performance metrics and reports to ensure the quality and integrity of extracts through the use of validation and audit strategies
- 24x7 On Call support/rotation responsibility
Skills/Requirements:
- Experience in using Oracle, Oracle Utilities, ETL tools Required 5 Years
- Experience with PL/SQL scripting and Relational Database modeling. Required 5 Years
- Experience with structured system development methodologies Required 5 Years
- Ability to develop relationships/partnerships with customer by responding to needs and exhibiting an sense of urgency; independently identify options. Required 5 Years
- Ability to organize, prioritize, and follow complex and/or detailed technical procedures. Required 5 Years
- Experience with Business Intelligence tools such as Business Objects or BIRT Required 5 Years
- Experience with Agile (Scrum, Kanban, or SAFe) development Required 2 Years
- Data Warehouse experience Required 2 Years
- Experience with developing dashboards with Power BI and Azure Synapse Highly desired 2 Years
- Familiarity with Amazon RedShift & Tableau Desired 2 Years
Similar jobs
- BI
Content Developer
NewBURGEON IT SERVICES LLC
Atlanta, GA🇺🇸RemoteYesterdayOracleMicrosoft OfficeMicrosoft PowerPoint+1Technology - BI
Reports Developer
NewBURGEON IT SERVICES LLC
Raleigh, NC🇺🇸HybridYesterdaySAFeOraclePL/SQL+9Technology - PA
Full Stack Lead (Kentico) - Fully Remote!!
NewPalni Inc
United States🇺🇸RemoteYesterdayDockerSQLSQL Server+15 - SI
Low-Code Developer/ Power Platform Developer
NewSolomons International
Raleigh, NC🇺🇸HybridYesterdaySQLAgileAzure+1Technology - TE
Workday Extend Developer || Mountain View , CA
NewTechridge, Inc.
Mountain View, CA🇺🇸On-siteYesterdayTechnology - AS
Full Stack Developer with Security Clearance
NewAthenix Solutions Group
Augusta, GA🇺🇸HybridYesterdayAgileConfluenceHTML+5Technology