We are seeking skilled Database Analysts with strong SQL/PLSQL expertise and FRICEW component knowledge to design, develop, and support custom reporting solutions. Join our data analytics team to deliver accurate data extraction, advanced data modeling, and production-ready reports for enterprise business intelligence initiatives.
Role Summary
As a Database Analyst, you'll leverage deep SQL/PLSQL skills to develop FRICEW components, perform complex data extraction, design sophisticated data models, and create optimized reports. You'll collaborate with business teams, execute comprehensive testing cycles, provide production support, and ensure data accuracy through rigorous troubleshooting and performance optimization.
Technical Development
- Deep understanding of FRICEW Components (Forms, Reports, Interfaces, Conversions, Enhancements, Workflows)
- Design, develop, deploy, and support custom and standard technical components
- Data extraction using SQL/PLSQL for business reporting requirements
- Data modeling and report layout designing for optimal presentation
- Write complex PL/SQL packages, procedures, functions, and triggers
Quality Assurance & Testing
- Perform unit testing, integration testing, and support UAT
- Validate data accuracy and report integrity across environments
- Document test cases, results, and defect resolutions
Production Support & Optimization
- Troubleshoot and resolve report issues including performance optimization
- Support production environments with bug fixes and change requests
- Monitor report performance and implement tuning strategies
Skills: testing,data extraction,database,modeling,sql,data,components